Subject | list of values in a parameter |
---|---|
Author | l_gilbert_fr |
Post date | 2013-03-19T10:02:43Z |
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.
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.