Pablo might have referred to the "timestamp" datatype in MS/Sybase SQL
Server. This is really a binary type of counter which changes to a new
database-wide unique value each time the row is updated. It can be used to
implement optimistic concurrency.
--
Tibor Karaszi
"Bob Hairgrove" <rhairgroveNoSpam_at_Pleasebigfoot.com> wrote in message
news:3e2707f5.1213124_at_news.webshuttle.ch...
> On Thu, 16 Jan 2003 09:40:02 -0600, Pablo Sanchez <pablo_at_dev.null>
> wrote:
>
> >Even worst, some DBMS update the timestamp any time the row is
> >affected since the timestamp data type is used for other purposes.
>
> Huh??
>
> Once you have written a value to a column, it should stay the same
> (unless you have a trigger implemented to update it)...
>
>
> Bob Hairgrove
> rhairgroveNoSpam_at_Pleasebigfoot.com
Received on Thu Jan 16 2003 - 14:35:00 CST
