Information générale
Forum:
Microsoft SQL Server
Versions des environnements
SQL Server:
SQL Server 2008
Thanks Naomi. I searched and found that if you are using remote views you can set a property so that datetime is converted to date. But I don't think that is available for Sql Passthrough.
As far as casting in vfp, I know that works, and I had already done that... but I was hoping to avoid the extra step. But it looks like it is unavoidable.
>>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).
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement