[fpc-pascal] Sqldb - How to pass an array of values as a param to be used with SQL IN operator?

[Luiz Americo Pereira Camara]

I switched most of my SQL queries to use Params instead of formatting
directly the SQL.

But until now i havent figured a way to pass an array of values (mostly
integers) to be used with IN operators.

Example:

SQL: Select  * from Customer where Id in (:idlist)

I need to query customers with Ids 1, 2 and 3

If i do

ParamByName('idlist').AsString := '1,2,3';

will not work.

Is there a way to accomplish this?

Luiz

_______________________________________________
fpc-pascal maillist  -  fpc-pascal@lists.freepascal.org
http://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-pascal