No to lose data in TSQLQuery after closing the transaction
lazarus / 16-Databases

----------------------------------------------------------------------
taqtaq · 2012-12-08 18:14

How can I do to keep the data in a TSQLQuery after closing a
transaction?

If a TSQLQuery keeps data in memory, then why lost data when
Transaction.active: = False?

I mean something like what makes a TClientDataset in Delphi

----------------------------------------------------------------------
Zoran · 2012-12-08 18:28

Close the transaction with either:
Code: [Select]SQLTransaction.CommitRetaining;or
Code: [Select]SQLTransaction.RollbackRetaining;
Note that with the second variant, if any changes in database had been
made with the transaction, these get undone. With the first, they are
confirmed.

----------------------------------------------------------------------
taqtaq · 2012-12-11 11:54

Thanks