Subject AW: [IBO] Updating data ?
Author Queck Rainer
Hello Paul,

thanks a lot for answering.
It defenetly is a problem in my little application. Even if I modify the data then terminate the app and restart it , I can see that the modifications have not taken place in the database.

What I do to modify my data:
In the TIB_Grid, I enter the column and modyfy the data. This results in a enabeling of the Post button in the TIB_Update bar.
I have assigned a evnt handler to the "AfterAction" where I now explicite call the TIB_Transaction.CommitRetaining;
Then I close my app and restart it and all modifications seem to be lost :-(

What is it I am doing wrong?
Thanks for further information.


-----Urspr√ľngliche Nachricht-----
Von: Paul Vinkenoog [mailto:paul@...]
Gesendet: Donnerstag, 10. April 2003 17:06
An: IBObjects (E-Mail)
Betreff: Re: [IBO] Updating data ?

> 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

Yahoo! Groups Sponsor



IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________ - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <> .

[Non-text portions of this message have been removed]