Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email firstname.lastname@example.org
Long data type and trigger OLD value
From: Vitaly Veksler (vvekslernearpost.com)
Date: Tue Jun 29 2004 - 09:14:08 CDT
I have created a trigger to do something with the previous value of a particular record. My trigger def looks like this:
CREATE TRIGGER ANNOUNCEMENT_UPDATE FOR ANNOUNCEMENT AFTER UPDATE EXECUTE
INSERT INTO ANNOUNCEMENT_HISTORY VALUES
IF $rc <> 100
THEN STOP ($rc, 'unexpected error');
Field BODY is of type LONG. I get this error message when I try to create this trigger:
General error;-9000 POS(116) System error: Not yet implemented:OLD of datatype LONG.
Has anyone figured out a way to work around this limitation?