Subject Re: [IBO] Passing input arguments with TIB_Query
Author yaedos2000
OK, thanks :-)

--- In IBObjects@yahoogroups.com, Markus Ostenried <chef_007@g...>
wrote:
> At 16:12 Thursday, 13.01.2005 +0000, yaedos2000 wrote:
> >Hi, I've tried that, but I keep getting an error message when I try
> >to prepare the query, saying that IN_TID is an unknown column. Is
> >there anything else I should be doing?
>
> > "SELECT OUT_ID, OUT_TID FROM SP_SELECT_ID(IN_TID);"
>
> you need to put a ':' character before your parameter, like this:
> "SELECT OUT_ID, OUT_TID FROM SP_SELECT_ID(:IN_TID);"
>
> Then you can access the parameter with ParamByName('IN_TID').
>
> HTH,
> markus