Subject Re: [IBO] Passing input arguments with TIB_Query
Author Markus Ostenried
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