>Because Cetin my code in the sample is striped. In this transaction there are other tables updated and when one of all updates faills all changes are to be rollbacked

OK I didn't use VFP transactions with a RV against SQL server. Have no idea.
PS: If it's an SPT cursor a disconnection would autocommit anyway (with implicit transactions).
Maybe profiler would show what's going on.
Cetin