CODEWITHSUNDEEP
sql-serverdelphidateadofield
durumdara
durumdara

Reputation: 3463

Delphi 6, ADO, MS database "Date" field is same as ftWideString

I want to copy elements to a remote MS-SQL database. I got conversion error on it.

When I checked the ADOTable structure I saw the MS field

WHENCREATED DATE [NULL]

is converted to 

ftWideString 10

Hmmmmm....

Is it normal? Or I can set something to Date fields are come as TDateTime?

The Provider is "SQLOLEDB.1"

Upvotes: 5

Views: 1524

Answers (1)

Alex K.
Alex K.

Reputation: 175766

Its a DATE (yyyy-mm-dd) type which was introduced in SQL Server 2008 as an alternative to the DATETIME type.

Because SQLOLEDB.1 precedes this there is a backward conversion to DBTYPE_WSTR, using an updated provider (SQLNCLI) would be preferable.

Upvotes: 7

Related Questions