Subject | AW: [firebird-support] transaction |
---|---|
Author | Olaf Kluge |
Post date | 2011-05-07T23:14:42Z |
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
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