In message <av6khq+tamg@...>, Didier Gasser-Morlay
<Didiergm@...> <Didiergm@...> writes

>Hi all,
>
>for some application I need to mark a record as deleted rather than
>actually delete it. and I would like this to be performed in the
>delete trigger but cannot find a way to do an update & stop the
>deletion from happening. raising an exception seems to cancel the
>update I did.
>
>Also is there a way to have a 'silent exception' (ie not sending back
>a message to the client, a bit like Delphi's ABORT) ?
>
>Thanks in advance
>Didier

I use an ACTIVE boolean field in the table, which indicates whether the
record should be considered deleted or not. We don't delete our deletes
(if you see what I mean), we just make them inactive.

--
Pete Clark