> 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
http://www.ibobjects.com