>I read that the date data type was added to sql server in server 2008. For the following statement:
>
>lnr=sqlexec(lnh,"select cast(dt_date as date) as date_ from activity","curactivity")
>
>dt_date is a datetime data type. In the cursor curactivity, date_ become character (10), not vfp's data type date.
>Is there anyway to directly convert this this vfp's date datatype?
Try searching on this problem here, I believe the problem was discussed - we need to use some property to map.
Alternatively, you may cast it in VFP side (reselecting data again).
If it's not broken, fix it until it is.
My Blog