TZQuery without TZupdatesql

The offical for ZeosLib 7.3 Report problems, ask for help, post proposals for the new version of Zeoslib 7.3/v8
Quick Info:
-We made two new drivers: odbc(raw and unicode version) and oledb
-GUID domain/field-defined support for FB
-extended error infos of Firebird
-performance ups are still in queue
In future some more feature will arrive, so stay tuned and don't hassitate to help
Post Reply
fjtrooper
Fresh Boarder
Fresh Boarder
Posts: 16
Joined: 07.02.2022, 19:52

TZQuery without TZupdatesql

Post by fjtrooper »

Hello! Can I use TZquery without TZupdateSQL? Or I will any problem if I don't use it?

Thanks!!!
User avatar
aehimself
Zeos Dev Team
Zeos Dev Team
Posts: 796
Joined: 18.11.2018, 17:37
Location: Hungary

Re: TZQuery without TZupdatesql

Post by aehimself »

Hello,

Of course you can use TZQuery (even for changing field values) but only for simple queries. In case you have a join or such, Zeos will even throw an exception to tell you that it won't work.
Only in those cases you need a TZUpdateSQL to tell Zeos how exactly to assemble your INSERT / UPDATE query.
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
fjtrooper
Fresh Boarder
Fresh Boarder
Posts: 16
Joined: 07.02.2022, 19:52

Re: TZQuery without TZupdatesql

Post by fjtrooper »

Ok perfect!
Thanks!
Post Reply