"Update or Insert" can perform also update but I want to replace update totally with delete and insert,of course with BEFORE UPDATE TRIGGER

Thanks.




________________________________
From: Hans <hhoogstraat@...>
To: firebird-support@yahoogroups.com
Sent: Tue, November 10, 2009 9:49:30 PM
Subject: Re: [firebird-support] Is it possible to cancel UPDATE with update trigger ?


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

----- Original Message -----
From: "Mr. John" <mr_johnmr@yahoo. com>
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
>
>
>
>







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