OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
 
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
(
TRY
    INSERT INTO ANNOUNCEMENT_HISTORY VALUES
    (
        :OLD.ANNOUNCEMENT_GID,
        :OLD.BODY
    )
CATCH
  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?

Thank you,
Vitaly Veksler