> 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
