Maybe the 'Update or Insert Table .... ' sql statement does it all
for you automatically

----- Original Message -----
From: "Mr. John" <mr_johnmr@...>
To: <firebird-support@yahoogroups.com>
Sent: Tuesday, November 10, 2009 12:36 PM
Subject: [firebird-support] Is it possible to cancel UPDATE with update
trigger ?


> Hi !
> 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.
> Thanks.
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>
>