Problem with Delphi and Firebird (interbase) database
Posted on 2006-06-27
We have two different programs. One is written in Borland C++ builder and the other in Delphi. THey are accessing one central database. When the C app updates the database the database refects the change without a problem. When the Dephpi app udates it works as well, but if the Delphi program runs the same Query twice :
Select * from X
and the C app has updated the X table in between the quereies the the Delphi app does not see the update.
If the Delphi app closes it's connection to the database and then re-opens it the it sees the change that was made by the C++ app. This works but uses alot of resources to accomplish.
Does anyone have any better ideas......