On Mon, 3 Dec 2001, Flemming Frandsen wrote:
> General error;-5016 POS(102) Missing delimiter: ). (SQL-S1000) > CREATE TRIGGER a_update FOR TEST.A AFTER UPDATE EXECUTE ( > INSERT INTO TEST.changelog (oid) VALUES (:OLD.string_field ) > ) I get the same error with: CREATE TRIGGER a_update FOR TEST.A AFTER UPDATE EXECUTE ( INSERT INTO TEST.changelog (oid) VALUES (:OLD.string_field ); ) I get another error if I ommit the : infront of old: Syntax error or access violation;-5010 POS(120) Missing value specification. (SQL-37000)(DBD: st_prepare/SQLPrepare err=-1) CREATE TRIGGER a_update FOR TEST.A AFTER UPDATE EXECUTE ( INSERT INTO TEST.changelog (oid) VALUES ( old.string_field ); ) This is quite natural as I know that I must have the :, what puzzles me is that it doesn't matter what I put after the : I always get the "Missing delimiter )" error, the trigger works if I use a constant string in place of :OLD.string_field. Any clues to spare, anyone? -- Regards Flemming Frandsen aka. Dion/Swamp http://dion.swamp.dk
