David Latham wrote,
>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
This is a bug. Unfortunately there is no workaround available. The problem
will be
solved with the next version.
Thomas
--
Thomas Anhaus
SAP DB, SAP Labs Berlin
[EMAIL PROTECTED]
http://www.sapdb.org/
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
