Claudio,

> TIB_DSQL used to produce an exception if no row was returned or more than
> one row was returned. I prefer to use TIB_Cursor and close it explicitly

(or

> use the AfterFetchEof event when I set AutoFetchAll to true and call here
> AbortFetching and Close).

If you make it to EOF then your OAT is free to move on as I allow the
transaction handle to be released once all cursors have reached EOF and no
other changes are pending.

There is nothing wrong with doing it this way, I just thought I would make
it known where precisely IBO watches to see when it can check for the OAT
opportunity.

Regards,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com