General information
Category:
ActiveX controls in VFP
>What´s this hej stuff, are you one of the natives?
The folks were born and raised in Danmark.
>Anyway, it´s a local view, and the stuff ultimately ends up in an Excel sheet, but the whole thing seems to go haywire already at the ADO level.
>
>I did not write the VB code and I don´t know a lot about ADO, but my view contains something like this:
>
>SET DATE ANSI
>SELECT Db.This, Db.That, Db.The_Other, DTOC(Db.Date) AS Date FROM DB
>
>Somehow ADO (or whatever) seems to recognize the Date field as a DATE type.
>
Hmmmm. I guess it begs the question of why you are converting the date to a char type.
Again, I tested on a local view. The field still comes back as a char type. Why don't you post your ADO code...
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only