× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. MIDRANGE-L
  3. July 2000

RE: field auditing

  • Subject: RE: field auditing
  • From: Rob Berendt <rob@xxxxxxxxx>
  • Date: Mon, 24 Jul 2000 13:28:50 -0500
 
You compare the file buffers passed to the trigger program.




pascal.bellerose@progisys.com on 07/24/2000 01:24:56 PM
Please respond to MIDRANGE-L@midrange.com@Internet
To:     MIDRANGE-L@midrange.com@Internet
cc:      
Fax to: 
Subject:        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. 
T7l7phone / Telephone :   (418) 871-4880 
T7l7copieur / Fax :            (418) 871-0486 
Site internet / Website :       www.PROGISYS.com 
Courriel / E-mail :              progisys@progisys.com 







<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2650.12">
<TITLE>RE: field auditing</TITLE>
</HEAD>
<BODY>

<P><FONT SIZE=2>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 ).</FONT></P>

<P><FONT SIZE=2>By the way the command for adding a trigger is </FONT>
</P>

<P><FONT SIZE=2>ADDPFTRG</FONT>
</P>

<P><FONT SIZE=2>hth</FONT>
</P>

<P><FONT SIZE=2>Pascal Bellerose </FONT>
<BR><FONT SIZE=2>Programmeur-analyste / Software developer </FONT>
<BR><FONT SIZE=2>pascal.bellerose@progisys.com </FONT>
</P>

<P><FONT SIZE=2>PROGISYS inc. </FONT>
<BR><FONT SIZE=2>Tlphone / Telephone :&nbsp;&nbsp; (418) 871-4880 </FONT>
<BR><FONT SIZE=2>Tlcopieur / Fax 
:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (418) 
871-0486 </FONT>
<BR><FONT SIZE=2>Site internet / Website :&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
www.PROGISYS.com </FONT>
<BR><FONT SIZE=2>Courriel / E-mail 
:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
progisys@progisys.com </FONT>
</P>
<BR>
<BR>

<P><FONT FACE="Arial" SIZE=2 COLOR="#000000"></FONT>&nbsp;

</BODY>
</HTML>

 --- InterPersonal Message ---


From: 'chris.bipes@cross-check.com@Internet'(Chris Bipes)
Subject: RE: field auditing
To: 'MIDRANGE-L@midrange.com@Internet'('MIDRANGE-L(a)midrange.com')
Reply-To: 'MIDRANGE-L@midrange.com@Internet'(MIDRANGE-L@midrange.com)

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
+---

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2650.12">
<TITLE>RE: field auditing</TITLE>
</HEAD>
<BODY>

<P><FONT SIZE=2>Not with journaling but with a Physical File Trigger you 
can.&nbsp; Journaling</FONT>
<BR><FONT SIZE=2>will write all changes to the file and you would have to 
process each entry</FONT>
<BR><FONT SIZE=2>and see if the field in question was updated.&nbsp; If so, you 
can print a report</FONT>
<BR><FONT SIZE=2>or what ever you need to do.</FONT>
</P>
<BR>
<BR>

<P><FONT SIZE=2>Christopher K. Bipes&nbsp;&nbsp;&nbsp; <A 
HREF="mailto:ChrisB@Cross-Check.com">mailto:ChrisB@Cross-Check.com</A></FONT>
<BR><FONT SIZE=2>Sr. Programmer/Analyst&nbsp; <A 
HREF="mailto:Chris_Bipes@Yahoo.com">mailto:Chris_Bipes@Yahoo.com</A></FONT>
<BR><FONT SIZE=2>CrossCheck, Inc.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <A 
HREF="http://www.cross-check.com" 
TARGET="_blank">http://www.cross-check.com</A></FONT>
<BR><FONT SIZE=2>6119 State Farm Drive&nbsp;&nbsp; Phone: 707 586-0551 x 
1102</FONT>
<BR><FONT SIZE=2>Rohnert Park CA&nbsp; 94928&nbsp; Fax: 707 586-1884</FONT>
</P>

<P><FONT SIZE=2>If consistency is the hobgoblin of little minds, only geniuses 
work here.</FONT>
<BR><FONT SIZE=2>Karen Herbelin - Readers Digest 3/2000</FONT>
</P>

<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>From: Bart [<A 
HREF="mailto:Bart.Verweijen@advalvas.be">mailto:Bart.Verweijen@advalvas.be</A>]</FONT>
<BR><FONT SIZE=2>Sent: Monday, July 24, 2000 8:05 AM</FONT>
<BR><FONT SIZE=2>To: midrange-l@midrange.com</FONT>
<BR><FONT SIZE=2>Subject: field auditing</FONT>
</P>
<BR>

<P><FONT SIZE=2>Hi all,</FONT>
</P>

<P><FONT SIZE=2>Is it possible to make a logfile of changes to a particular 
field in a PF</FONT>
<BR><FONT SIZE=2>(not the whole file - journalling).</FONT>
</P>

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

</BODY>
</HTML>

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.