Set,

Thanks. Then would a call to commit or commitretaining be enough
in the Afterpost event for the dataset ? I changed my code to this :

procedure TMaterial_Frm.qrMaterialAfterPost(IB_Dataset: TIB_Dataset);
begin
try
trMaterial.CommitRetaining;
except
trMaterial.RollBackRetaining;
raise;
end;
end;

And I've put the Commit in the OnClose event of the form.

Any idea ?

thanks,

Nico Callewaert


-----Oorspronkelijk bericht-----
Van: Svein Erling Tysvar [mailto:svein.erling.tysvaer@...]
Verzonden: vrijdag 6 april 2001 11:52
Aan: IBObjects@yahoogroups.com
Onderwerp: RE: [IBO] Modified property not working ?

>NeedToPost is always True after the dataset goes into edit-mode, even

when
you

>didn't change anything.

Nice to know, I never checked that.

>One more thing : when a user inserts a record, and he cancels his insert,

is

>it necessary to call a commit or commitretaining after a cancel. Or

there

>was no physical transaction yet??

I think the transaction started when you opened your dataset. For the OAT
(Oldest Active Transaction) to advance the transaction has to be
committed/rolled back (CommitRetaining won't do), but I think IBO can
manage quite a bit automatically if it just manages to read to the end of
your dataset (i.e. no large query returning 100 000 records). I'd guess it
would manage that even though you edited and called cancel (i.e without
using Commit), but it is purely a guess from my side.

Set

Yahoo! Groups Sponsor

Click Here to Find Software Faster


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



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