Subject Re: [firebird-support] Record Visibility
Author Ivan Prenosil
> I have a table in a database which I insert a record containing among others
> a money value. It's Ok! The problem is the following one: When I insert a
> record in this table, a trigger append a record in other table too.
> Nevertheless, when I do a 'select sum' statement on the table which the
> trigger has inserted record, then the value (money value) itsn't summed up
> to I undoing the connection with database and newly reconnect, although the
> new record is display, including its value, in a common select statement.
> The trouble is the sum.
> After Reconnect, like I've told above, it working perfectly.
> Remembering, all of trasactions it is committed.

After you modify any data in the database,
only transaction that made these modifications can see them.
(including indirect modifications through triggers)

After you commit you transaction,
all Read Commited transactions can see new values.

If you want other Snapshot (a.k.a. Repeatable Read)
transactions to see changes, you must
first commit the changes,
then start the snapshot transaction