Re: Update timestamp automatically when row changes

[CRPence <CRPbottle@xxxxxxxxx>]

  That's an Oops!  Correct that the default by omission is for 
Insert, not Update.  Sorry.  For DML UPDATE then SET DEFAULT or SET 
CURRENT TIMESTAMP.  Otherwise as already noted in other replies, an 
UPDATE TRIGGER in addition to the logical view omitting the 
TIMESTAMP column, or with both UPDATE and INSERT TRIGGERs.

Regards, Chuck

Rick.Chevalier@xxxxxxxxxxxxxxx wrote:
> If I understand what you are suggesting, that is what I'm
> doing now.  The timestamp field is defined with default
> CURRENT_TIMESTAMP.  I don't believe that updates on row
> changes however.
>
> I must have missed the PF default values thread.  I'll
> take a look at it and see if it will work.