RE: field auditing

[Pascal Bellerose <pascal.bellerose@xxxxxxxxxxxx>]

Wow thanks Rob, pfew! I got the answer before I had received my message!

---

• Subject: RE: field auditing
• From: Pascal Bellerose <pascal.bellerose@xxxxxxxxxxxx>
• Date: Mon, 24 Jul 2000 13:51:31 -0400

Title: RE: field auditing

I thought of a trigger too but how can he know which field has been modified, 'Cos as far as I know the trigger will be activated on any changes made to the PF, not only the specified field ( if you could specify it somewhere ).

By the way the command for adding a trigger is

ADDPFTRG

hth

Pascal Bellerose
Programmeur-analyste / Software developer
pascal.bellerose@progisys.com

PROGISYS inc.
Téléphone / Telephone :   (418) 871-4880
Télécopieur / Fax :            (418) 871-0486
Site internet / Website :       www.PROGISYS.com
Courriel / E-mail :              progisys@progisys.com

 

---

• Subject: RE: field auditing
• From: Chris Bipes <chris.bipes@xxxxxxxxxxxxxxx>
• Date: Mon, 24 Jul 2000 12:32:51 -0400

Title: RE: field auditing

Not with journaling but with a Physical File Trigger you can.  Journaling
will write all changes to the file and you would have to process each entry
and see if the field in question was updated.  If so, you can print a report
or what ever you need to do.

Christopher K. Bipes    mailto:ChrisB@Cross-Check.com
Sr. Programmer/Analyst  mailto:Chris_Bipes@Yahoo.com
CrossCheck, Inc.        http://www.cross-check.com
6119 State Farm Drive   Phone: 707 586-0551 x 1102
Rohnert Park CA  94928  Fax: 707 586-1884

If consistency is the hobgoblin of little minds, only geniuses work here.
Karen Herbelin - Readers Digest 3/2000

-----Original Message-----
From: Bart [mailto:Bart.Verweijen@advalvas.be]
Sent: Monday, July 24, 2000 8:05 AM
To: midrange-l@midrange.com
Subject: field auditing

Hi all,

Is it possible to make a logfile of changes to a particular field in a PF
(not the whole file - journalling).

Thank you for replying,
Bart
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---

---

---