General information
Title:
VFPCOM.DLL and DateTime data types
I am using VFPCOM.DLL to convert a Foxpro cursor to an ADO Recordset. I thought everything was working correctly until I realized that I am having a problem with the DateTime data types. I verify that that the DateTime value in the Foxpro cursor is what I want (ie, "01/01/2000 12:00:00 AM"). After converting the cursor to an ADO Recordset, I retrieve the DateTime value from the ADO recordset (ie, lDate = oRetRs.fields("BeginDate").value). lDate is of type "T", but the value is "08/04/2000", which is today's date. All of my dates are being converted to the current date or I am wrongly pulling the date out of the recordset. Does anyone have any experience with this?
Thanks in advance.
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