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 - [email protected]
http://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-pascal
