[fpc-pascal] Sqldb - How to pass an array of values as a param to be used with SQL IN operator?

leledumbo 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 mailing list