Some time ago, I requested two new data types.
The first is a time / date stamp that would be set when a record is inserted,
and never again changed. The second would be a time / date stamp that would
be set at insertion, and then changed each time the record was updated.
In the second type, a sequence number could easily be added so the number
of times the record was changed could also be recorded in the same column.
All this would happen at the engine level, so no programming would be required,
and the data would survive packs and reloads.
. . . Bob S.
update, and then again At 06:37 AM 4/18/01, you wrote:
>Kayza,
>
>Accordingly to my test a record only updates when a (or more column) update
>is performed. That's why (IFGT(dependcol;0;(.#date);(.#date))) contains
>(.#date) twice; IFGT needs two statements. The second (.#date) NEVER
>performs (R:Base 4.5++) when only data is viewed.
>
>Jouke
>
>----- Original Message -----
>From: K Kleinman Zajac <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Sent: Thursday, April 19, 2001 2:32 AM
>Subject: Re: DateStamp on edit
>
>
> > >> Add a computed column to the table and set the contents to .#date.
> >
> > Jouke <<
> >
> > Wouldn't that cause the field to be updated every time the record was even
> > viewed?
------------------------------------------------------------
Bob Simms
Robert A. Simms and Co., Los Angeles
818-345-5306 Fax 818-345-5136
E-Mail: mailto:[EMAIL PROTECTED]
URL: http://www.pacificnet.net/simms
-------------------------------------------------------------
