Hello Helen,

thanks for the effort to help me!

>1) the SQL of the query

SELECT * FROM ProgramsToMonitor

>2) the KeyLinks of the Query

ProgramsToMonitor.ProgramNo -> which is primary key

>3) the setting of RequestLive for the Query

RequestLive:=True

>Also, is your transaction set to AutoCommit?

Yes.

In my datamodul.Create I do:
PmcDbConnection.Username:='SYSDBA';
PmcDbConnection.Password:='masterkey';
PmcDbConnection.Connected:=True;
PmcDbTransaction.StartTransaction;
QProgramsToMonitor.Active:=True;

Regards
Rainer


-----Ursprüngliche Nachricht-----
Von: Helen Borrie [mailto:helebor@...]
Gesendet: Freitag, 11. April 2003 08:34
An: IBObjects@yahoogroups.com
Betreff: Re: AW: [IBO] Updating data ?


At 08:18 AM 11/04/2003 +0200, you wrote:

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

Rainer,
Please tell us:

1) the SQL of the query
2) the KeyLinks of the Query
3) the setting of RequestLive for the Query

Also, is your transaction set to AutoCommit? If you are calling
CommitRetaining, are you also calling StartTransaction?

Helen




Yahoo! Groups Sponsor
<http://us.ard.yahoo.com/M=249982.3083889.4452939.1728375/D=egroupweb/S=1705007183:HM/A=1524963/R=0/*http://hits.411web.com/cgi-bin/autoredir?camp=556&lineid=3083889&prop=egroupweb&pos=HM>
<http://us.adserver.yahoo.com/l?M=249982.3083889.4452939.1728375/D=egroupmail/S=:HM/A=1524963/rand=467847197>

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