Hello Marco,

Yes I do a commit after each post.

I have a TIBOTransaction component in my datamodule and I do

Try
DMFoss.DBTrans.StartTransaction;
Except on EDataBaseError do
Begin
DMFoss.QDocuments.Cancel;
ShowMessage ....
Exit;
End;
End;
Try
DMFoss.QDocuments.Post;
DMFoss.DBTrans.Commit;
Except on EDataBaseError do
Begin
DMFoss.QDocuments.Cancel;
DMFoss.DBTrans.Rollback;
ShowMessage....
End;
End;

Properties of QDocuments.TIBOQuery


AutoFetchAll true
CommitAction CaInvalidateCursor
FetchWholeRows true
IB_Transaction DBTrans
SqlString Select * from Documents order by DocumentNr

DBTrans TIBOTransaction component

AutoCommit False
Isolation TiCommitted
RecVersion True
ServerAutoCommit False

Max


-----Oorspronkelijk bericht-----
Van: Marco Lauria [mailto:mslauria@...]
Verzonden: dinsdag 18 mei 2004 14:38
Aan: Max Bernaert
Onderwerp: [edp] [IBO] Problems with refresh of data.

Hello,

Are you committing the transaction after the inserts?
If you don't commit the transaction and this is not in autocommit mode,
You see the records only when the transaction is committed.
Regards
Marco

Marco Lauria
STARMAX s.a.s.

________________________________________
Da: Max Bernaert [mailto:edp@...]
Inviato: martedì 18 maggio 2004 14.20
A: IBObjects@yahoogroups.com
Oggetto: [IBO] Problems with refresh of data.

Hello,

After doing several inserts in a table. The new records seems not to be
available in my Delphi programs until I fully exit the program.
Even after an active := false followed by an active := true the data is
not visible.

The data is only visible if I alter the sql sentence of the TIBOQuery.

What I am doing wrong ?

Thanks for your help.

Max.



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





________________________________________________________________________
___
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 !

Yahoo! Groups Links