Datetimes not being set with b7

Mr. Bart Pietercil bart.pietercil at gmail.com
Wed Nov 14 09:43:07 CST 2007


Hi Ruslan


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 ?

TIA

Bart Pietercil


More information about the Valentina mailing list