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

b) I build the cursorschema as folows:

* some code

This.CursorSchema=""
Afields(aFieldList)
Local xcomma, lnI, lcField, lcType, lnWidth, lnDec
For lnI =1 To ALEN(aFieldList,1)
lcField = aFieldList[lnI, 1]
lcType = aFieldList[lnI, 2]
lnWidth = aFieldList[lnI, 3]
lnDec = aFieldList[lnI, 4]
xcomma=Iif(lnI=1,"",",")
This.UpdateNameList =This.UpdateNameList + m.xcomma+ lcField+" "+;
this.Tables+"."+lcField
This.UpdatableFieldList=This.UpdatableFieldList + m.xcomma + lcField
Do Case
Case Inlist(lcType, [Y], [D], [L], [M], [G], [I], [T] )
This.CursorSchema = This.CursorSchema + lcType
Case Inlist(lcType, [C], [V])
This.CursorSchema = This.CursorSchema + lcType + [(] + Transform(lnWidth) + [)]
Case Inlist(lcType, [N], [F])
This.CursorSchema = This.CursorSchema + lcType + [(] + Transform(lnWidth) + [,] + Transform(lnDec) + [)]
Case Inlist(lcType, [B])
This.CursorSchema = This.CursorSchema + lcType + [(] + Transform(lnDec) + [)]
Endcase
ENDFOR

c) Why the same problem in the results of the SQLEXEC statement that cursoradapter is not involved?