[fpc-pascal] Sqldb - How to pass an array of values as a param to be used with SQL IN operator?
leledumbo_cool at yahoo.co.id
Sun Apr 10 14:39:56 CEST 2016
> 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.
More information about the fpc-pascal