RE: Timestamp when a record is updated...

[Chris Bipes <ChrisB@xxxxxxxxxxxxxxx>]

Ok, here is what I found through T&E.  DFU will fire the trigger if you
add/update/delete a record.  If you bring up a record and change nothing,
there is no update by DFU, therefore no pulling of the trigger.  This would
be the same as having your application look at the before and after image of
the record and only performing the update if something was changed.  To the
best of my experience, DFU does something like this.

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



-----Original Message-----
From: End of the Trail [mailto:endofthetrail@skyenet.net]
Sent: Thursday, August 19, 1999 8:52 PM
To: RPG400-L@midrange.com
Subject: Re: Timestamp when a record is updated...


>Joe Teff:
>A trigger is fired by the database itself and not by any application.
>If the database changes, the trigger fires - no exceptions.

That is interesting because my experience and the Ibm blurp found in small
print says DFU does not change the attirbutes of a file.

After setting up a trigger on a file and changing the data in it with DFU,
the trigger never fired.  I spent the afternoon double checking my program,
the file, the data, and the trigger.  A co-worker, interested and helping
research my trouble, stumbled upon a one sentence answer in one of the IBM
supplied text.  I run the same test using the same program, data, and
trigger... except made the change using DBU.  Everything ran like a charm.
I will double check and run it again using DFU.  BUT.... I will be surprize
if it work....  didn't before!

Eurrat

+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---