Subject AW: [firebird-support] transaction
Author Olaf Kluge
Hello,

Hello Olaf

When you insert/delete/update a record (row) in a table it is only visible
to the current transaction. Others transactions can not see the changes
until a COMMIT is executed.

You can use POST_EVENT to say them that a COMMIT was executed and so they
can refresh their data and see the new values.

Greetings.

Walter.


In other words, if I execute a procedure an insert a record in the first
table and seconds later with the same procedure (one step and the same call)
it inserts a record in a second table - the first record is only visible if
the procedure finished? (all steps)

Thank you