Re: capture date stamp on create and update
From: Kevin Gillins <kevin_gillins_at_compuserve.com>
Date: Wed, 15 Sep 1999 21:51:30 -0600
Message-ID: <7rpivt$58r$1_at_ssauraaa-i-1.production.compuserve.com>
--
Kevin Gillins
Management Information Consulting
Boston Office
978-887-3300
Date: Wed, 15 Sep 1999 21:51:30 -0600
Message-ID: <7rpivt$58r$1_at_ssauraaa-i-1.production.compuserve.com>
I would use 2 triggers. On update and on insert triggers.
Whenever the insert trigger fires it populates both columns with sysdate.
When the update trigger fires it will update the modify column.
Or you could put the code in your form somewhere.
--
Kevin Gillins
Management Information Consulting
Boston Office
978-887-3300
Received on Thu Sep 16 1999 - 05:51:30 CESTPadmaja Raghavapudi <padmaja_1_at_hotmail.com> wrote in message news:LqWD3.128$664.49548_at_WReNphoon3...Hi all,
I am trying to capture the create and update date stamps for all the tables
in my database. I have "create" and
"modify" columns in all my tables. These need to be updated using forms
(Developer 2000, Forms 5). When
a new record is created (and commited), the sysdate value needs to go into
these "Create and "Modify"
columns of that table. If it is an existing record, the sysdate value needs
to go into the "Modify" column only.
How do I do it ?
I have different base table blocks in my form. How can I ensure that the
sysdate is written to each of the
underlying tables when the user inputs data into all the blocks and hits a
save on the form ?
Any info (or code samples) is greatly appreciated. Thanks.
-Padmaja
-**** Posted from RemarQ, http://www.remarq.com/?a ****-
Search and Read Usenet Discussions in your Browser - FREE -