Sybase Adaptive Server Anywhere 6 Trigger - Trying to detect if im INSERTING or UPDATING

Question

In v10 of the Sybase Adaptive Server Anywhere inside a trigger i can check what event executed the trigged by using:

IF UPDATING THEN
-- Do Stuff
END IF;

IF INSERTING THEN
-- Do Stuff
END IF;

However in v6 this is not recognised. Any idea how i can do the same or will i just need to create two separate triggers. One for updating and one for inserting!

score 0 · Accepted Answer · answered Nov 13 '12 at 02:38

0

No, version 6 did not support this functionality. You will have to write separate triggers for each action. Please note that version 6 is almost fifteen years old; you should consider upgrading to a newer version.

answered Nov 13 '12 at 02:38

Graeme Perrow

56,086
21
82
121

1

ok thanks. Yes i know its old but im just working on a project for a customer. I dont control what database they use. – CathalMF Nov 13 '12 at 09:08

Sybase Adaptive Server Anywhere 6 Trigger - Trying to detect if im INSERTING or UPDATING

1 Answers1