Create Trigger in Vstudio -- 2

[Ruslan Zasukhin]

On 19/6/07 1:24 PM, "Bart Pietercil" <bart.pietercil at gmail.com> wrote:

> Second Problem: When in VStudio I select the trigger, the trigger
> text has the complete execute text
> 
> I select trigger "trigger_tbl_users_BI" and the trigger text reads:
> 
> CREATE OR REPLACE TRIGGER "trigger_tbl_users_BI" BEFORE INSERT
>      ON "tbl_users" FOR EACH ROW
>      BEGIN
>          NEW.creation_dt = NOW();
>          NEW.modification_dt = NOW();
> NEW.objptr_modified_by = @user_id;
> NEW.objptr_created_by = @user_id;
>      END;
> CREATE OR REPLACE TRIGGER "trigger_tbl_users_BU" BEFORE UPDATE
>      ON "tbl_users" FOR EACH ROW
>      BEGIN
>          NEW.modification_dt = NOW();
> NEW.objptr_modified_by = @user_id;
>      END;
> 
> The same goes for the second trigger
> 
> Bug? Mantis?

Yes this is not good.

Interesting, if they no really broken...


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]