Subject Re: [IBO] Updating data ?
Author Paul Vinkenoog
Hello Rainer,

> I have a little application using TIB_Connection, TIB_Transaction,
> TIB_DataSource, TIB_Query, TIB_Grid and TIB_UpdateBar.
> My application runns fine, I can see the data in the grid, I can
> modify it and all looks fine but....
> If I look into the database via IBConsole the modifications don't
> show! (even not after commit and then select again).
> It looks like I can do what I want, it never has any effcts on my
> database :-(

Believe me: if you post and commit succesfully from your application,
the data are in the database.

If you don't see them in IBConsole, try Refresh (in IBConsole, that
is). If you still don't see them, it might be the transaction
isolation level in effect in IBConsole: if it isn't "Read Committed"
it can't see any data inserted from another transaction context (in
this case: from your app). You would then have to disconnect from the
database in IBConsole and reconnect.

I don't know if you can change the transaction isolation level in
IBConsole.


Greetings,
Paul Vinkenoog