Re: Row Change Timestamp

I do stand corrected. That other thread led me astray, or I read it
wrong.
This table:
CREATE TABLE ROB/RAULDATE
(MODDATE TIMESTAMP NOT NULL for each row on update
as row change timestamp,
crtuser char (18) with default USER,
MYDATA CHAR (5 ) NOT NULL)
RCDFMT RAULDATER


with three rows inserted, A, B, C

with this program (caution, cycle!!);
FRAULDATE UP E DISK
/free
select;
when mydata='A';
mydata='D';
when mydata='B';
mydata='E';
when mydata='C';
mydata='F';
when mydata='D';
mydata='A';
when mydata='E';
mydata='B';
when mydata='F';
mydata='C';
endsl;
update rauldater;
/end-free

Updated the row change time stamp to the current timestamp.
If I used sql to
UPDATE RAULDATE SET CRTUSER='PETE'
and rerun the program it does not change CRTUSER from 'PETE' to 'ROB'.
I guess that's a difference between "as row change" vs "with default".


Rob Berendt