|Subject||Re: [firebird-support] Record Visibility|
> I have a table in a database which I insert a record containing among othersAfter you modify any data in the database,
> 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.
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