> >What's going wrong? > A semicolon is required after the insert statement :
Yes, I know, but that wasn't what was wrong, I get the same error with the ; General error;-5016 POS(103) Missing delimiter: ). (SQL-S1000)(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 ); ) -- Regards Flemming Frandsen aka. Dion/Swamp http://dion.swamp.dk
