| Subject | Re: [firebird-support] Passing multiple values to a parameter of a stored procedure |
|---|---|
| Author | Helen Borrie |
| Post date | 2008-11-10T21:07:34Z |
At 06:15 AM 11/11/2008, you wrote:
You can pass the list in as an input string and parse it in a loop so that you process each list member in turn with an equality test and operate on the found records one at a time inside the loop.
Or you can construct an executable statement to which you concatenate your input list, and use EXECUTE STATEMENT to execute it.
./heLen
>Greetings All,No. The IN() argument is specifically a list of constants.
>
>I'm using Firebird 1.5
>
>
>Is there anyway to pass as an input parameter these values 1,15,16 (or others) so that I can have a where clause like this?
>
> WHERE DCTBD.TBD_ID IN(:V_TBD_ID_LIST)
You can pass the list in as an input string and parse it in a loop so that you process each list member in turn with an equality test and operate on the found records one at a time inside the loop.
Or you can construct an executable statement to which you concatenate your input list, and use EXECUTE STATEMENT to execute it.
./heLen