In addition to a dateUpdated, and a dateEntered field,
[DateEntered = (IFNULL(DateEntered,.#Date,DateEntered)) ]
my tables also have an updatedBy field. This lets you know who made
the last change. It is the 'User' at the time the record was updated.
As long as we are asking for cookies, I would like mine
with chocolate chips.
Thanks,
Randy Peterson
>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.
