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