Subject | Re: [firebird-support] Firebird/ASA/Clarion |
---|---|
Author | Martijn Tonies |
Post date | 2004-04-01T21:41:26Z |
> >> ...yada)
> >
> > I really really really like rollback/commit. I once almost did just the
> > above.
> > On a remote production database, after a customer request, I ran:
> > DELETE FROM ORDERS <Run!>
> >
> > I then noticed quite a long run-time (cascading deletes yada, yada,
> > ...Sure did...
> > ... ...
> >
> > Next: "woops!!"
> >
> > Finished the run, pressed "Rollback".
> >
> > Changed the statement to:
> >
> > DELETE FROM ORDERS
> > WHERE ORDERNR = <nr>
> >
> > And used Run! again. That helped ;-)
>
>
> Did we hear a sigh-of-relief here ?
Anyway, no need for a log-file. Just used the transactions :-)
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com