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.Sqlite will accept double qoutes as will MySQL postgres will not though. On Apr 10, 2016 7:40 AM, "leledumbo" <leledumbo_c...@yahoo.co.id> wrote: > > But until now i havent figured a way to pass an array of values (mostly > integers) to be used with IN operators. > > That, unfortunately, is not possible. It's a DBMS limitation, parameterized > values are actually passed as is to DBMS. So there's nothing you can do > unless you can convince DBMS maintainer to implement it. > > > Is there a way to accomplish this? > > No other way than direct formatting for now. > > > > > -- > View this message in context: > http://free-pascal-general.1045716.n5.nabble.com/Sqldb-How-to-pass-an-array-of-values-as-a-param-to-be-used-with-SQL-IN-operator-tp5724873p5724874.html > Sent from the Free Pascal - General mailing list archive at Nabble.com. > _______________________________________________ > fpc-pascal maillist - fpc-pascal@lists.freepascal.org > http://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-pascal >
_______________________________________________ fpc-pascal maillist - fpc-pascal@lists.freepascal.org http://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-pascal
