Page 1 of 1
TZQuery and TZUpdateSQL.
Posted: 20.10.2009, 16:02
by GGL
Hi, all. I've just started using ZEOSlib, and have a little problem with it.
I use TZQuery with TZUpdateSQL. ZQuery.UpdateOject := ZUpdaetSQL;
How to decide what type of modification to use?(insert, delete or update)
ZQuery hasn't property UpdateKind... Plz help me!!!!!
Posted: 22.10.2009, 10:08
by Darkbow
I have not used TZUpdateSQL but my guess would be you have to fill the DeleteSQL, InsertSQL and ModifySQL properties of your TZUpdateSQL, and then TZQuery will use whatever SQL fits to the operation it must do.
Re: TZQuery and TZUpdateSQL.
Posted: 23.10.2009, 11:13
by delphi2pk
GGL wrote:Hi, all. I've just started using ZEOSlib, and have a little problem with it.
I use TZQuery with TZUpdateSQL. ZQuery.UpdateOject := ZUpdaetSQL;
How to decide what type of modification to use?(insert, delete or update)
ZQuery hasn't property UpdateKind... Plz help me!!!!!
TZQuery is enough to update a single table. But if you want to update/insert/delete more than one table then use TZUpdateSQL where you can update multiple tables at once.