Datetimes not being set with b7

[Ruslan Zasukhin]

On 14/11/07 5:43 PM, "Mr. Bart Pietercil" <bart.pietercil at gmail.com> wrote:

Hi Bart,

> This trigger
> <code>
> CREATE OR REPLACE TRIGGER "trigger_tbl_users_BU" BEFORE UPDATE ON
> "tbl_users" FOR EACH ROW
> BEGIN
> NEW.modification_dt = NOW();
> if @user_id IS NOT null then
> NEW.objptr_modified_by = @user_id;
> END IF
> END;
> </code>
> 
> before b7 worked perfectly. Whenever a record was updated the
> modification_dt was updated.
> With b7 it is set to 00-00........
> 
> What is changed in b7? Do I need to rewrite the trigger ?

I think something is broken here.
Ivan is required to check this.

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