Subject RE: [firebird-support] Firebird caching query results
Author Leyne, Sean
> In my environment I have a software which insert new rows on a certain
> table. This software and the firebird server is running on the same machine.
> I have a software running on a client which query the the server.
> The problem is there are some sort of cache, because I'm getting the old
> rows. If I query the database from the the server works fine (I get the new
> rows), but when I'm in na cliente I always get the same old rows from hours
> ago.

Your monitoring app is not closing transactions and opening new transactions -- FYI, there is a transaction type which allows for all data changes to be visible.


Sean