community.borland.com
Article #28794: Reflecting database changes
Problem
When a user posts a record, other users cannot see that record unless the
database is closed and opened again.
Solution
All changes made to the database must be committed before the changes
can be visible to others. When another user actually sees the committed
changes depends on the transaction isolation level they are using.
If another user is using snapshot isolation he/she will not see
the change until he/she commits and starts a new transaction. If
he/she is using read committed isolation he/she will see the change
the nest time he/she selects the changed record.
Last Modified: 25-JUN-02