Use datasets with a CommitAction of caFetchAll and make sure they are not huge datasets. If all rows are fetched then
you can call Commit as you please and the datasets will maintain their buffer of records in memory.

Jason Wharton
www.ibobjects.com

--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
Dear IBO users

What is the best my of doing commit that still leaves the dataset open?

I read that commitretaining/rollbackretaining isn't a good practice
cause it consume much more memory + prodcue some OAT problems.

How about if I need to close and open a dataset due to some changes in
the SQL statement. Will refresh do the trick?

jtsiy