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

Luiz Americo Pereira Camara luizamericop at gmail.com
Sun Apr 10 21:38:58 CEST 2016


2016-04-10 16:29 GMT-03:00 Tony Caduto <tony.caduto at gmail.com>:

> What about using a stored procedure to do it ?  You could pass the list
> for the in as a string and handle it in the stored procedure.  Of course
> that's no help if using sqlite or other that does not support stored
> procedures.
>

I'm working with multiple DB engines, so i try to avoid non standard
syntax/features.
My workaround is working fine, so no need to break this rule

Luiz
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freepascal.org/pipermail/fpc-pascal/attachments/20160410/2b564266/attachment.html>


More information about the fpc-pascal mailing list