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.

Regards
Rainer

-----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:
- you REFRESH

Grtz,
Paul


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

ADVERTISEMENT


<http://rd.yahoo.com/M=246920.2960106.4328965.1728375/D=egroupweb/S=1705007183:HM/A=1529139/R=2/id=noscript/*http://www.gotomypc.com/u/tr/yh/cpm/grp/300_mapG/g22lp?Target=mm/g22lp.tmpl>
<http://us.adserver.yahoo.com/l?M=246920.2960106.4328965.1728375/D=egroupmail/S=:HM/A=1529139/rand=452894942>

___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - 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 <http://docs.yahoo.com/info/terms/> .




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