Subject list of values in a parameter
Author l_gilbert_fr
Hello all,

I want to have something like that in a query :

select * from the_table where the_table_key in (:selection);

And in my program, I use :

my_query.ParamByName('selection').AsString := my_StringList.CommaText;


Is it really possible ?

In my tests, the key is an integer and IBO raises an exception when I set the parameter to "1,2" for example. The exception is normal because the parameter is seen as an single integer value.

If someone has a solution or an alternative.

Thank you.
Laurent.