Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
MySQL rejects blank VFP date
Message
From
21/11/2022 22:27:59
Dennis Lim
D-Labs, Inc.
Manila, Philippines
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
MySQL rejects blank VFP date
Miscellaneous
Thread ID:
01685392
Message ID:
01685392
Views:
75
Hi All,

I cannot seem to put my finger on this situation. In a previous MySQL version, 5.7.27, it accepts blank VFP dates and populates the MySQL table with '0000-00-00'.

Now with 5.7.40, it says "Incorrect date value".

I am using ODBC 8.0.

TIA.
Next
Reply
Map
View

Click here to load this message in the networking platform