Is this possible in a trigger?

by fernando@[EMAIL PROTECTED] (Fernando) May 6, 2008 at 05:05 PM

This is a multi-part message in MIME format.
--------------060303090705090407080607
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

I want to keep a history of changes on a field in a table.  This will be 
the case in multiple tables.

Can I create a trigger that loops the OLD and NEW values and compares 
the values and if they are different creates a change string as follows:

e.g;

FOR EACH field IN NEW
    IF field.value <> OLD.field.name THEN
       changes := changes
            || field.name
            || ' was: '
            || OLD.field.value
            || ' now is: '
            || field.value
            || '\n\r';
    END IF
END FOR;

Your help is really appreciated.

Thank you.

--------------060303090705090407080607
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
</head>
<body bgcolor="#ffffff" text="#000000">
<font face="Comic Sans MS">I want to keep a history of changes on a
field in a table.  This will be the case in multiple tables.<br>
<br>
Can I create a trigger that loops the OLD and NEW values and compares
the values and if they are different creates a change string as
follows:<br>
<br>
e.g;<br>
<br>
</font><tt>FOR EACH field IN NEW<br>
    IF field.value &lt;&gt; OLD.field.name THEN<br>
       changes := changes<br>
            || field.name<br>
            || ' was: '<br>
            || OLD.field.value<br>
            || ' now is: '<br>
            || field.value<br>
            || '\n\r';<br>
    END IF<br>
END FOR;</tt><font face="Comic Sans MS"><br>
<br>
Your help is really appreciated.<br>
<br>
Thank you.<br>
</font>
</body>
</html>

--------------060303090705090407080607--

8 Posts in Topic:

Is this possible in a trigger?

fernando@[EMAIL PROTECTED

2008-05-06 17:05:37

Re: Is this possible in a trigger?

kgore4@[EMAIL PROTECTED]

2008-05-07 10:10:50

Re: Is this possible in a trigger?

kreno@[EMAIL PROTECTED]

2008-05-06 19:13:29

Re: Is this possible in a trigger?

xzilla@[EMAIL PROTECTED]