> > Johan,
> > ...
> >
> > The Martijn answer:
> >
> > How on earth do you get to mistakingly purge lots of records?
> >
> > Do you use tools with "autocommit = true"? If so, that's pretty
> > dumb, isn't it?
> > ...
>
>
> Martijn,
>
> Isn't this just quotes from another list? Probably not much to gain by
> arguing here :-)

Oh, c'mon - let me argue, let me start a fight! ;-)

> You could visit the comp.lang.clarion NG, and engage in the battle ...
>
> Now, why are they doing this on a production database? Because they are
> using ASA? I think it takes 'somewhat' more effort to backup+restore (or
> establish) a copy of an ASA database than an Fb one (for testing).

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 ;-)

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com