trigger after insert

[Ivan Smahin]

Hello Bart,

Tuesday, September 25, 2007, 6:07:25 PM, you wrote:

> 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.

Sorry, I was wrong:
It  must  be  "BEFORE  INSERT"  trigger  to  get  ability  to operate
with NEW.field.


-- 
Best regards,
Ivan Smahin 
Senior Software Engineer
Paradigma Software, Inc
Valentina - The Ultra-Fast Database
http://www.valentina-db.com