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

Just checked: isolation level in IBConsole is definitely Read
Committed, so you should see any committed changes from your app.

Make sure that in your application:
- you POST
- and COMMIT

And then in IBConsole:


> > 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