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