>>>SQLexpress 2008, ODBC, Sqlserver Native Client 10.0, VFP9 SP1
>>>
>>>a) SQLEXEC(nhandle, "select ....","tempcurs") returns the DATE type fields as Character
>>>b) When I build a cursoradapter from an SQL table characterizes (translates) the DATE type fields as CHARACTER.
>>>Is this normal? Is it a bug?
>>
>>No, it returns it as a datetime (maybe you have a cursorschema in your class setting it to character?).
>>Cetin
>
>Hi Cetin,
>
>a) Why DATETIME, in the table I have difined it as DATE?
I guess the odbc driver and/or VFP's side of it was written before SQL had date type, so it defaults to what it knows.