Subject Re: [firebird-support] Firebird/ASA/Clarion
Author Martijn Tonies
> >> ...
> >
> > 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,
yada)
> > ...
> > ... ...
> >
> > 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 ?

Sure did...

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