An example, please.
You'll have to wait till tomorrow; I'm off to bed (it's 1 a.m. here
).
Or you could try yourself; the normal flow when adding/deleting/modifying a record is:
SQLQuery.Update;
SQLTransaction.Commit;
Just leave out the "SQLTransaction.Commit" and the SQLQuery should update itself
but not reflect the changes to the database.
Note, though, that I've never tried anything like this, so I might be completely wrong ...