General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Hi Sergey,
Thank you for the replay. How can I assign a Null value to a date field in VFP.
Ali
>Hi Ali,
>
>I don't know about Access but ODBC doesn't support empty dates. You may consider using Null's instead.
>
>>Hi every body,
>>
>>Thanks for the reply. I have got a problem with access DATETIME fields. While they have none blank values they work great. However, when I try to empty a DATETIME Access field through ODBC in VFP6, I get the following error:
>>
>>Connectivity error: [Microsoft][ODBC Microsoft Access Driver]
>>Data type mismatch in criteria expression.
>>
>>How can I fix this problem?
>>
>>Thank you,
>>Ali
>>
>>
>>
>>
>>
>>>>Hi every body,
>>>>
>>>>I have a question for you. I am accessing an Access database through ODBC. What is the equivalent of ‘Short Date’ in FoxPro?
>>>>
>>>>Thank you,
>>>Ali,
>>>
>>>You can run select through ODBC and check what data type FoxPro uses for a ‘Short Date’ field in the cursor created.
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