Hello! Can I use TZquery without TZupdateSQL? Or I will any problem if I don't use it?
Thanks!!!
TZQuery without TZupdatesql
Re: TZQuery without TZupdatesql
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.
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.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
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
Re: TZQuery without TZupdatesql
Ok perfect!
Thanks!
Thanks!