Re: Timestamp when a record is updated...

["Eric N. Wilson" <doulos1@xxxxxxxx>]

You can write to a logical that does not include the timestamp field and the
database manager will handle filling the Timestamp field for you... Only on
adds. I would recommend that you make a trigger program that is attached to
the before insert and before update events. This way you do not have to
worry about including the code anywhere else (And it happens everytime all
the time anything updates/adds a record)

______________________________________________
Eric N. Wilson
President
Doulos Software & Computer Services
2913 N Alder St
Tacoma WA 98407


----- Original Message -----
From: Jocke Berggren <jocke@fsys.se>
To: <RPG400-L@midrange.com>
Sent: Thursday, August 19, 1999 2:02 AM
Subject: Timestamp when a record is updated...


> Is there any feature in the database that automaticly sets a
> timestamp value whenever a record is updated or added ?
>
> Else we must include z-add timestamp before every updat/write
> in all our porgrams :(
>
>
>
>
> +---
> | 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
> +---

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