General information
Category:
Internet applications
Title:
ADO and FoxPro date fields
Hi
I'm using ADO from an ASP page to query a FoxPro table using the VFP ODBC driver. One of the fields in the query is a date field - 'date_deliv'. When this field is empty in the Fox table, the ADO recordset contains "12:00:00 AM". Apparently ADO is treating the field as a DateTime field. I checked the ADO data type for the field, and it is a dbf date type field. Is there any way to have ADO return empty date fields without inserting the time, or do I have to check the field for a value of "12:00:00 AM" to determine if I have an empty date?
TIA
Bill Sabo
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