Re: parameters in query

From: Tom <mail_at_yahoo.com>
Date: Thu, 7 Apr 2005 15:34:39 +0200
Message-ID: <d33cu2$n4$1@ss405.t-com.hr>

problem is more complex
we have aplication in delphi but without code, dont' ask why it's too long. In edit box i write query, in another input and pick type of variable. After execution on screen we have listing of requestes data depending on input variables. So aplication works only with bind variables (database level)...
and delphi aplication reqognize only this syntax:

select * from order where id_order in (:d_order) "&" is unknown!!!

"HansF" <News.Hans_at_telus.net> wrote in message news:pan.2005.04.07.14.26.26.947492_at_telus.net...
> On Thu, 07 Apr 2005 14:52:03 +0200, Tom interested us by writing:
>
>> in sql plus i wrote
>> select * from order where id_order in (&d_order)
>> and input value of parameter 1,5,9 and it's ok!!
>>
>
> Now you are seeing that TOAD != SQL*Plus
>
> You want substitution variables, not bind variables, for this particular
> situation. Bind variables work at the database level (they are the ones
> with :), whereas substitution variables are tool based and TOAD's
> implementation is much different that SQL*Plus.
>
> Consider also checking the TOAD site and FAQ for help.
Received on Thu Apr 07 2005 - 08:34:39 CDT