2016-04-10 11:01 GMT-03:00 Tony Caduto <[email protected]>: > 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 - [email protected] http://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-pascal
