> BTW, another possibility to rollback a group of updates is to use savepoints > if your database supports them. tsqltransaction has savepointbegin(), > savepointrollback() and savepointrelease() and the savepointlevel property. > A cascade of updates in tdatraset.post() can be automatically rollback in > case of an error by activting tmsesqlquery.controller.options > dso_postsavepoint. > Sometimes also useful in this context are dso_cancelupdateonerror and > dso_cancelupdatesonerror.
I think the problem is not how to rollback failed post, but why if applyupdates result error, we can not continue to next process, for example to rollback or savepointrollback. IMHO, we need new event property in t*connection i.e onerrorupdates, and with this event we can execute rollback or ssavepointrollback if while applyupdate(s) executed and we get error from db server. Thanks _______________________________________________ MSEide-MSEgui-talk mailing list [email protected] https://lists.berlios.de/mailman/listinfo/mseide-msegui-talk
