That should work. It only will update the "FIRST" timestamp (so if you have
more than one, check the first one).
Also it can't be type time,date, or datetime, but must be type timestamp,
preferably for max compatiblity, timestamp(14).
dp
"Bill" <no@where.com> wrote in message
news:bl**********@sparta.btinternet.com...
I was under the impression from the manual that if you added a field to a
table of type timestamp this would automatically be updated after each
insert/update of a new record, but all I get is 00000000.
Is there something else I should set?
Thanks.