Board index » delphi » ado and timestamp with msde

ado and timestamp with msde


2003-10-22 07:37:23 AM
delphi267
hi all,
using Delphi 7 and Msde
i have a table with a field defined as a timestamp , when i try to read this
data i get an error :
'cannot access field UPDATE_DATE as type SQLtimestamp.'
i tried to read the data with the getdata function ,but the result isn't
clear.
thanks in advance
beppe
 
 

Re:ado and timestamp with msde

"beppe" <XXXX@XXXXX.COM>schrieb im Newsbeitrag
Quote
>using Delphi 7 and Msde

i have a table with a field defined as a timestamp , when i try to read
this
data i get an error :
'cannot access field UPDATE_DATE as type SQLtimestamp.'

i tried to read the data with the getdata function ,but the result isn't
clear.
The MSDE (=M$ SQL Server) datatype "timestamp" is *not* the same
as the SQL/92 datatype "timestamp".
Use the datatype "datetime" instead.
hth
Andreas