Subject | Re: [IBO] Passing input arguments with TIB_Query |
---|---|
Author | Markus Ostenried |
Post date | 2005-01-13T17:12:28Z |
At 16:12 Thursday, 13.01.2005 +0000, yaedos2000 wrote:
"SELECT OUT_ID, OUT_TID FROM SP_SELECT_ID(:IN_TID);"
Then you can access the parameter with ParamByName('IN_TID').
HTH,
markus
>Hi, I've tried that, but I keep getting an error message when I tryyou need to put a ':' character before your parameter, like this:
>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);"
"SELECT OUT_ID, OUT_TID FROM SP_SELECT_ID(:IN_TID);"
Then you can access the parameter with ParamByName('IN_TID').
HTH,
markus