Re: Undo capability

Depending on how complex the transaction, you can do this sort of thing by keeping your own log of the transactions and generating reversal syntax to undo them. This is not something I'd recommend unless you are prepared to spend quite a bit of time getting it right :) Of course transactions which update multiple, interdependant tables with for example autoincrementing keys and triggers are an absolute nightmare to do this with...

David.

Syb User wrote:

> No.
>
> Go to: http://sybooks.sybase.com/
>
> Read up on transaction management in the Transact-SQL User's Guide. This
> should help.
>
> <jean_ro_at_my-deja.com> wrote in message news:7j9mhl$qd5$1_at_nnrp1.deja.com...
> > I am trying to write an application that is hooked up to a database.
> > Is there anyway I can "undo" database transactions once they are
> > comitted?
> >
> > Thanks in advance for your help.
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Share what you know. Learn what you don't.
Received on Thu Jun 10 1999 - 01:51:11 CEST