thanks Leyne for your opinion.




________________________________
From: "Leyne, Sean" <Sean@...>
To: "firebird-support@yahoogroups.com" <firebird-support@yahoogroups.com>
Sent: Tue, November 10, 2009 11:12:43 PM
Subject: RE: [firebird-support] Is it possible to cancel UPDATE with update trigger ?

> Is it possible to cancel update inside UPDATE trigger and perform delete
> and insert ?
> I have complex triggers for insert and delete and instead of writing also
> an update trigger i want to force
> update =delete+insert.

I think you want to use a VIEW with triggers that apply the operations to the real tables.

In that way you can replace any of the operations with whatever logic you want.

Sean







[Non-text portions of this message have been removed]