| Subject | Re: [firebird-support] Insert Trigger which makes an Update if pk allready there possible? |
|---|---|
| Author | Martijn Tonies |
| Post date | 2004-08-20T12:52:50Z |
Hi Andreas,
DELETE - it doesn't abort the action to substitute another.
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com
> Is it possible to write an Insert Trigger that test for the existence ofA trigger fires only when you do an INSERT, UPDATE or
> the pk and then make an Update of the data if it allready exist?
DELETE - it doesn't abort the action to substitute another.
> Or must I use a Stored Procedure?Yes.
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com