> How can I do this manually with a transaction ? My problem is, that in my
> app, all datasets, that has been opened, should stay open, but on the

other

> side, the lifetime of the transactions should be as short as possible.

This

> could be my solution.

This is your solution as long as your dataset isn't too big. Even still, set
it to caInvalidateCursor and call Commit every so often and this will keep
the transaction OAT moving along nicely without impacting the dataset too
much.

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