From: "Steve Harp" <steve@...>

> Hi All,
>
> I have two applications that use the same database; applications A & B.
>
> If A is running with the database open and I run a process using B,
> the changes aren't seen by A until I close and reopen the database.
> When B runs the process, it opens the database, updates some data, and
> closes the database. No transactions should be left open by B.
>
> What can I do in A to make sure that the changes made by B will be
> visible without having to close and open the database?
>

Make sure your transactions are set to read-committed. Then, you only need
to re-query the data for updated information.

HTH

Woody (TMW)