How to add records to a TSQLQuery without inserting them in the
database
lazarus / 16-Databases

----------------------------------------------------------------------
Jvan · 2021-05-28 22:14

Is it possible?

----------------------------------------------------------------------
lucamar · 2021-05-28 22:51

In theory yes: as long as you don't commit the transaction they should
be kept just in the (updated) query dataset, waiting to be committed
to the database.

However you should test it thoroughly, just in case ...

----------------------------------------------------------------------
Jvan · 2021-05-28 22:58

Quote from: lucamar on May 29, 2021, 12:51:16 amIn theory yes: as long
as you don't commit the transaction they should be kept just in the
(updated) query dataset, waiting to be committed to the database.

However you should test it thoroughly, just in case ...


An example, please.

----------------------------------------------------------------------
lucamar · 2021-05-28 23:08

Quote from: Jvan on May 29, 2021, 12:58:06 amAn 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:
Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i
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 ...