ZEOS: How to disable auto POST in ZQuery
lazarus / 16-Databases

----------------------------------------------------------------------
blastertemp · 2012-07-06 09:23

When user add one row in DBGrid and move to another row, the new row
is POST into DB.
But user needs to add more than one row in DBGrid, and after
confirmed, POST them into DB together.

In ADOQUERY, we can set TADOQUERY.LockType  = ltBatchOptimistic;
But for ZQuery, how to disable auto POST in ZQuery?

Thanks!

----------------------------------------------------------------------
ttomas · 2012-07-06 10:46

You can use ZQuery1.CashedUpdates := True property
When you finish all updatest call ZQuery1.ApplyUpdates; or
CancelUpdates

----------------------------------------------------------------------
atasoft · 2012-07-06 16:48

Change the Autocommit property of ZConnection to False. This will
affect all the queries. The records of dbgid will still be posted but
not commited to db. Then you should add a button to commit the changes
to db.

----------------------------------------------------------------------
blastertemp · 2012-07-09 01:15

by setting ZQuery1.CashedUpdates = True, it works.
Thank you!