Subject Re: [ib-support] Viewing Database Changes
Author Svein Erling Tysvær

>1) User 1 connects
>2) User 2 connects
>3) User 3 connects
>User 2 makes a database change to a record in the database.
>User 3 queries on the record and they see the change.
>User 1 queries on the record and they don't.

this has nothing to do with connections, but transactions. A transaction
only sees whatever was in the database when the transaction started plus
changes done within this very transaction.

>Is there a setting in the BDE or in Interbase to fix this?

The best way to fix this is to drop the BDE and go! The
BDE is fairly nice for desktop databases (I use it with Paradox tables all
the time), but is not fit for client/server databases in general and
Interbase/Firebird in particular. I don't think the BDE has any real
understanding of transactions and that is probably your problem. Try
checking the properties for your connections. Sorry for not being able to
offer more help, but I've never been adventurous enough to use the BDE
against Interbase!