Hi Helen,

Yes, I did make that mistake? before and corrected it to TIBODataBase,
but it made no difference. The Commits repost the entire row and
the Rollsback cycle thro all the TIBOQueries I might have open at
that point.

TIBOTable <-> TIBOTransaction
TIBOTable <-> TIBOQuery and TIBOTable

however TIBOTransaction <-> TIB_TransactionSource when
seems to work since I get proper IB_TransactionSourceOnStatusChanged
events, matching the current TIBOTransaction statii.

Best regards
Hans

====================================================================


Helen Borrie wrote:

>
> At 11:08 PM 04-08-01 -0600, you wrote:
> >Hello,
> >
> >Same setup as previos CommitRetaing question. (IBO4)
> >
> >Got a TIBOQuery hooked up to TIB_DataBase with AutoCommit = False
> >to enable Transaction CommitRetaining and RollBackRetaining control.
> >
> >All works, I can commit or rollback.
> >
> >The program goes thru various screens opening TIBOQUERY tables,
> >lots of them M/D via DataSource properties, all in READ ONLY
> >mode, to finally get to a R/W table for user updates.
> >
> >None of the READ ONLY tables are closed, most screens Modal.
> >
> >Interesting effect, when a RollBackRetaining is issued after
> >an update on the last R/W table, it takes a while and the reason
> >is that IB rolls back and re-issues all SQL for every open table of
> >every open screen as seen in IB_Monitor. Question why ?
> >
> >When I close all R/O tables when reaching the last screen with
> >the R/W table, a RollBackRetaining only affects this only open
> >table. What I'm I doing wrong, any ideas ?
> >
>
> Hans:
>
> "Got a TIBOQuery hooked up to TIB_DataBase"
>
> Is this a typo or are you really trying to use the native database component with the TDataset data access objects?
>
> Helen
>
> All for Open and Open for All
> InterBase Developer Initiative · http://www.interbase2000.org
> _______________________________________________________
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/