Hello,
as far as I know, Zeos doesn't support the in operator. You need to express it in a series of or's.
Best regards,
Jan
Using IN on ZQuery.Filter
-
- Platinum Boarder
- Posts: 1999
- Joined: 17.01.2011, 14:17
Re: Using IN on ZQuery.Filter
In this forum post there used to be a link to a PDF document called zExpression.pdf. It's a really nice one describing what you can do with the .Filter property. Unfortunately the link is not valid anymore (says 404 for me) but I managed to grab it for myself before it disappeared so I'll just reupload it here (hope I am allowed to do that though )
@Ronaldobim is right though, neither I can see an IN clause what you could use.
@Ronaldobim is right though, neither I can see an IN clause what you could use.
You do not have the required permissions to view the files attached to this post.
Delphi 12.2, Zeos 8 from latest GIT snapshot
Using:
- MySQL server 8.0.18; libmysql.dll 8.0.40 x64 5.7.19 x68, libmariadb.dll 3.3.11
- Oracle server 11.2.0, 12.1.0, 19.0.0; oci.dll 21.15
- MSSQL 2012, 2019; sybdb.dll FreeTDS_3102
- SQLite 3.47
Using:
- MySQL server 8.0.18; libmysql.dll 8.0.40 x64 5.7.19 x68, libmariadb.dll 3.3.11
- Oracle server 11.2.0, 12.1.0, 19.0.0; oci.dll 21.15
- MSSQL 2012, 2019; sybdb.dll FreeTDS_3102
- SQLite 3.47
-
- Platinum Boarder
- Posts: 1999
- Joined: 17.01.2011, 14:17
Re: Using IN on ZQuery.Filter
I uploaded that doument to the SourceForge files section. Thanks for sharing
Best regards,
Jan
Best regards,
Jan
Re: Using IN on ZQuery.Filter
The original link is available again, but I suppose it has a better place published. Thank @mdaems (and whoever sent it to him) for the document though
Delphi 12.2, Zeos 8 from latest GIT snapshot
Using:
- MySQL server 8.0.18; libmysql.dll 8.0.40 x64 5.7.19 x68, libmariadb.dll 3.3.11
- Oracle server 11.2.0, 12.1.0, 19.0.0; oci.dll 21.15
- MSSQL 2012, 2019; sybdb.dll FreeTDS_3102
- SQLite 3.47
Using:
- MySQL server 8.0.18; libmysql.dll 8.0.40 x64 5.7.19 x68, libmariadb.dll 3.3.11
- Oracle server 11.2.0, 12.1.0, 19.0.0; oci.dll 21.15
- MSSQL 2012, 2019; sybdb.dll FreeTDS_3102
- SQLite 3.47