Subject Re: [firebird-support] Insert Trigger which makes an Update if pk allready there possible?
Author Martijn Tonies
Hi Andreas,

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

A trigger fires only when you do an INSERT, UPDATE or
DELETE - it doesn't abort the action to substitute another.

> Or must I use a Stored Procedure?


With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Upscene Productions