>>>>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.


If this is the case " the odbc driver and/or VFP's side of it was written before SQL had date type, so it defaults to what it knows." , this very important encashment of the DATE type field in MSSQL 2008 is quite useless regarding the VFP developers. Is't so?