Re: Timestamp Column. -Reply

Posted in 1998

Robert Wines — Wed, 29 Apr 1998 17:29:19 -0500 — source: Informix-list mailing list archive (1991-1998)

I would not recommend using datetime as a timestamp. Given the speed of SMP systems it is possible that someone can submit a record during .001 and someone else submit a record at .0019. I would suggest you use an integer, start a transaction that locks the row, compares the integer, make whatever updates you need then increment the integer and release the lock. robert_wines @ ama-assn.org