471,084 Members | 1,041 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,084 software developers and data experts.

timestamp conundrum

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.
Jul 19 '05 #1
4 2282
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.

Jul 19 '05 #2
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.

Jul 19 '05 #3

"D. Pickering" <dc*****@hps.com> wrote in message
news:x3*********************@newssvr30.news.prodig y.com...
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
Thanks for replying!

Actually, I did only have one timestamp field but as I said it alwasy set a
value of 00000, so I just ended up making it a Date field instead and
setting it manually. Might work better when I upgrade to version 4.0.15.


"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.


Jul 19 '05 #4

"D. Pickering" <dc*****@hps.com> wrote in message
news:x3*********************@newssvr30.news.prodig y.com...
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
Thanks for replying!

Actually, I did only have one timestamp field but as I said it alwasy set a
value of 00000, so I just ended up making it a Date field instead and
setting it manually. Might work better when I upgrade to version 4.0.15.


"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.


Jul 19 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by Craig Bailey | last post: by
reply views Thread by Bill | last post: by
2 posts views Thread by rong.guo | last post: by
4 posts views Thread by Jim Ford | last post: by
4 posts views Thread by Jim Owen | last post: by
2 posts views Thread by subnunciation | last post: by
7 posts views Thread by JJ | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.