2016-04-10 11:01 GMT-03:00 Tony Caduto <tony.cad...@gmail.com>:
> Did you try putting quotes around the param ID in the sql query?
> in(":myparam")
> I am guessing it's the commas that are the problem.
>
Its the other way around the problem is the quotes
See the attached app.
When using Select * from Test where Id in (1,3) it works
but using Select * from Test where Id in (:idlist) and doing the param
binding does not work because is translated into:
Select * from Test where Id in ('1,3')
Luiz
project1.lpr
Description: Binary data
_______________________________________________ fpc-pascal maillist - fpc-pascal@lists.freepascal.org http://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-pascal
