TZQuery and TZUpdateSQL.

In this forum we will discuss things relating the ZEOSLib 6.6.x stable versions

Moderators: gto, EgonHugeist

Post Reply
GGL
Fresh Boarder
Fresh Boarder
Posts: 1
Joined: 20.10.2009, 11:02

TZQuery and TZUpdateSQL.

Post 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!!!!!
Darkbow
Fresh Boarder
Fresh Boarder
Posts: 19
Joined: 01.09.2009, 12:28

Post 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.
delphi2pk
Fresh Boarder
Fresh Boarder
Posts: 5
Joined: 09.06.2009, 12:00

Re: TZQuery and TZUpdateSQL.

Post 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.
Post Reply