>>>>>>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?
>
>I can't know that until I get my hands on a MSSQL 08. Maybe a cursorschema would work, forcing a date format - but that's more work than a single select * via SPT. IOW, I don't see a good solution until there's an ODBC driver, and since ODBC is becoming forgotten by M$ (they'll probably say you should use OleDB), I'm not expecting one. There may be a workaround, I don't know.

Hi Drugan,
It works with the {SQL Native Client 10.0}, not with the {SQL Server}
Thanks for your replay.