Using IN on ZQuery.Filter

The forum for ZeosLib 7.2 Report problems. Ask for help, post proposals for the new version and Zeoslib 7.2 features here. This is a forum that will be edited once the 7.2.x version goes into RC/stable!!

My personal intention for 7.2 is to speed up the internals as optimal a possible for all IDE's. Hope you can help?! Have fun with testing 7.2
Post Reply
marsupilami
Platinum Boarder
Platinum Boarder
Posts: 1918
Joined: 17.01.2011, 14:17

Re: Using IN on ZQuery.Filter

Post by marsupilami »

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
User avatar
aehimself
Zeos Dev Team
Zeos Dev Team
Posts: 766
Joined: 18.11.2018, 17:37
Location: Hungary

Re: Using IN on ZQuery.Filter

Post by aehimself »

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.
You do not have the required permissions to view the files attached to this post.
Delphi 12.1, Zeos 8 from latest GIT snapshot
Using:
- MySQL server 8.0.18; libmariadb.dll 3.3.8
- Oracle server 11.2.0, 12.1.0, 19.0.0; oci.dll 21.13
- MSSQL 2012, 2019; sybdb.dll FreeTDS_2435
- SQLite 3.45.2
marsupilami
Platinum Boarder
Platinum Boarder
Posts: 1918
Joined: 17.01.2011, 14:17

Re: Using IN on ZQuery.Filter

Post by marsupilami »

I uploaded that doument to the SourceForge files section. Thanks for sharing :)

Best regards,

Jan
User avatar
aehimself
Zeos Dev Team
Zeos Dev Team
Posts: 766
Joined: 18.11.2018, 17:37
Location: Hungary

Re: Using IN on ZQuery.Filter

Post by aehimself »

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.1, Zeos 8 from latest GIT snapshot
Using:
- MySQL server 8.0.18; libmariadb.dll 3.3.8
- Oracle server 11.2.0, 12.1.0, 19.0.0; oci.dll 21.13
- MSSQL 2012, 2019; sybdb.dll FreeTDS_2435
- SQLite 3.45.2
Post Reply