Hi All,
I'm wondering if someone can help me with a problem I'm having (maybe a
bug?)
I've got a table I've defined a trigger for... I've simplified it to the
following:
CREATE TRIGGER UPDATE_USR FOR USR
AFTER UPDATE (NameFirst, NameLast, SitePerm, Active) EXECUTE (
VAR txt_msg VARCHAR(250);
SET txt_msg = 'Updated User: ' || UsrID || ' Record Changed From: ' ||
OLD.NameFirst || OLD.NameLast || OLD.SitePerm || chr(OLD.Active) || ' TO:
' ||
NEW.NameFirst || NEW.NameLast || NEW.SitePerm || chr(NEW.Active);
INSERT TEST.SYS_NOTE (Source, msg) VALUES ('USR', :txt_msg); )
If I update the USR table with the following SQL I get the subsequent
information in the SYS_NOTE table:
update usr
set namelast = 'Jones'
where usrid = 'DSmith'
Updated User: DSmith Record Changed From: DavidSmith1,3,5T TO:
DavidJones,3,55
After testing, it appears that all columns after the column(s) that I've
updated have invalid information in the NEW record. Checking the database
confirms the correct information is stored in the DB. Does anyone have any
suggestions, or is this a bug? I've tried comparing the NEW columns to NULL
with the same result...
I'm running version 7.3.0.21 on Windows 2000
Thanks,
Dave
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
