Subject RE: [IBO] 3.6.Dd
Author John Tomaselli
Thanks Geoff and Jason. I Guess that this just never has been an issue in
any of my apps and I obviously skipped the classes on timeouts. I remember
trying to get this to work with ib_events and DMLCache, not realizing how
easy you can do this now.

-----Original Message-----
From: Geoff Worboys [mailto:geoff@...]
Sent: Thursday, May 03, 2001 11:48 PM
Subject: Re: [IBO] 3.6.Dd

> If the grid is left untouched for a few minutes it
> automatically updates and I now have 6 records in
> the grid.

This will probably be the transactions OAT automation. I think ONE of
the following will help...

* If you the transaction isolation to tiConcurrency (the default) then
you will stop the query from seeing the results of other
transactions - you will also disable the OAT automation, so you must
manage that for yourself.

* Disable OAT automation for that transaction - set
IB_Transaction.TimeoutProps.Attempt := 0;

* Setup the query so that CommitAction is set to caFetchAll, and also
set AutoFetchAll to true. In that way, when the transaction tries to
commit and performs a FetchAll, there is nothing left to fetch so
nothing happens.


Geoff Worboys
Telesis Computing

Your use of Yahoo! Groups is subject to