trigger after insert
Bart Pietercil
bart.pietercil at gmail.com
Tue Sep 25 10:07:25 CDT 2007
Hi List,
can somebody explain why this trigger
CREATE OR REPLACE TRIGGER "trigger_tbl_users_AI" AFTER INSERT
ON "tbl_users" FOR EACH ROW
BEGIN
if @user_id IS null then
NEW.objptr_created_by = New.recid;
NEW.objptr_modified_by = New.recid;
End IF
END;
generates this error when executed in the sql editor:
Error: Kernel error: 0x91504. Trigger "trigger_tbl_users_AI": time
"AFTER" is not supported in this context.
TIA
Bart
More information about the Valentina
mailing list