Page 1 of 1

TZQuery without TZupdatesql

Posted: 15.09.2022, 14:47
by fjtrooper
Hello! Can I use TZquery without TZupdateSQL? Or I will any problem if I don't use it?

Thanks!!!

Re: TZQuery without TZupdatesql

Posted: 15.09.2022, 15:56
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.

Re: TZQuery without TZupdatesql

Posted: 15.09.2022, 19:42
by fjtrooper
Ok perfect!
Thanks!