On Thursday 08 September 2011 18:07:45 wahono sri wrote: > > 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. > Why does try..except..end or tmsesqlquery.onupdateerror not work for you?
Martin _______________________________________________ MSEide-MSEgui-talk mailing list MSEide-MSEgui-talk@lists.berlios.de https://lists.berlios.de/mailman/listinfo/mseide-msegui-talk