I now about common code into stored procedure,but in my case that is what I need ,thanks for your suggestion




________________________________
From: Dimitry Sibiryakov <sd@...>
To: firebird-support@yahoogroups.com
Sent: Tue, November 10, 2009 10:05:41 PM
Subject: Re: [firebird-support] Is it possible to cancel UPDATE with update trigger ?

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

And all this because you are afraid to rub your fingers off typing
one more trigger?.. Have you ever heard about copy-paste? May be you
heard about code reuse, so you can carry common code into Stored
Procedure...
If all this is not an option for you, you can replace table with
view. In this case you can implement any crazy logic in triggers.

SY, SD.


------------------------------------

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

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]