In SQL7 a timestamp is a datatype that is automatically updated every time a
row containing a timestamp column is inserted or updated. Browse mode
requires timestamp columns in tables that are to be browsed in DB-Library
applications. Values in timestamp columns are not datetime data, but
binary(8) varbinary(8) data, indicating the sequence of SQL Server activity
on the row. A table can have only one timestamp column.
The timestamp datatype has no relation to the system time.
It is simply a monotonically increasing counter whose values will always be
unique within a database.
In SQL Server, use Datetime or smallDateTime
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Aaron Scott-Boddendijk
Sent: Thursday, February 24, 2000 11:04 AM
To: Multiple recipients of list database
Subject: Re: [DUG-DB]: Timestamp or Bytes...
> Hiya, small question which is giving me a bit of a head ache.... in sql7
> I have a table with a timestamp field, but when using an ADO comp in
> Delphi the fields editor creates it as TBytesField instead of TDateTime as
> I'd imagine it to be, should I just use DateTime fields or what?
like the filesystem I suspect timestamp is not in a format directly
compatible
with TDatetime - although their ranges will certainly overlap...
--
Aaron Scott-Boddendijk
Jump Productions
(07) 838-3371 Voice
(07) 838-3372 Fax
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
