Create Trigger in VStudio

Ruslan Zasukhin sunshine at public.kherson.ua
Tue Jun 19 05:29:17 CDT 2007


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

Hi Bart,

> Hi List, Ruslan
> 
> I created 2 triggers with this statement:
> 
> 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;
> 
> I created this through the SQL-editor with ONE execute
> 
> 
> In VStudio 2 triggers are created
> 
> First problem: They only show up after reopening the DB (close DB-->
> open DB) -- Is this for Mantis ?

Please note button REFRESH in the top bar.




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




More information about the Valentina mailing list