Home » Developer & Programmer » Forms » When I need a ":" in a SQL statment?
When I need a ":" in a SQL statment? [message #80059] Wed, 07 August 2002 16:57 Go to next message
Fico
Messages: 26
Registered: July 2002
Junior Member
As subject.

Thanks.

Report message to a moderator

Re: When I need a ":" in a SQL statment? [message #80062 is a reply to message #80059] Wed, 07 August 2002 20:06 Go to previous messageGo to next message
Robin
Messages: 73
Registered: October 2001
Member
Hi,
When u need to use value on form's item like text box, immage box etc, u need to use ':' sign left of that text or immage item.

eg.
select stud_id, name into :student.stud_id, :student.name from student_info where stud_id=:search.stud_id;

Report message to a moderator

Re: When I need a ":" in a SQL statment? [message #80067 is a reply to message #80059] Thu, 08 August 2002 01:47 Go to previous messageGo to next message
Tejpal Saraswat
Messages: 22
Registered: August 2002
Junior Member
In SQL Statement generally used the : with the bind variables when assigning the values to form items in INTO clause
or u used the : bind variables in Where condition

best regds
Tej

Report message to a moderator

Re: When I need a [message #80521 is a reply to message #80059] Mon, 07 October 2002 09:46 Go to previous message
Ibrahim
Messages: 16
Registered: October 2001
Junior Member
No Message Body

Report message to a moderator

Previous Topic: Re: Installation of D2K(VER 5)
Next Topic: CREATING USER IN ORACLE DATABASE
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 04:56:08 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.