Subject Re: [firebird-support] "in" list as a parameter...
Author Dmitry Kuzmenko
Hello, Sergio!

Tuesday, May 22, 2012, 3:25:43 PM, you wrote:

S> Hello! I have a simple SP with something like this:

S> select my_field
S> from some_table
S> where id in (1,3,56,100)

S> How can I do to pass "(1,3,56,100)" a an input parameter?


Select something
From Table T
Where :ParamStr Containing '~'||T.ID||'~'

then you set :paramstr to string like this

Dmitry Kuzmenko,