Bob,
I put in a request for a new feature that would accomplish the same thing, but
in a different way. I was suggesting a way to access and change the "current
of sys_new" column values in a trigger. That way, we could create an insert or
update trigger in which we could manipulate, verify, or set the values of not just
timestamp columns but any column in the row being inserted or updated.
Bill
On Thu, 19 Apr 2001 11:43:37 -0700, Bob Simms wrote:
>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.
