Subject Re: [IBO] Correct use of transactions for 24x7
Author Jason Wharton
> I would have liked to close the transaction immediately after
> fetching the data, but then the grid data is cleared - any
> suggestions will be appreciated.

Set the MaxRows to the query to 50 and set its CommitAction to caFetchAll
and you should have the behavior you like.

Jason Wharton
CPS - Mesa AZ