Subject Re: [firebird-support] Insert Trigger which makes an Update if pk allready there possible?
Author Nando Dessena

A> Is it possible to write an Insert Trigger that test for the existence of
A> the pk and then make an Update of the data if it allready exist?

yes; you can create a view on the table and define your before insert
trigger on the view.

As others have mentioned, you can do the same in a slightly simpler
but less transparent way by means of a stored procedure.

Nando Dessena
I support Firebird, I am a Firebird Foundation member!
Join today at