Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Error empty date with MariaDB
Message
From
08/11/2021 03:41:09
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Error empty date with MariaDB
Miscellaneous
Thread ID:
01682648
Message ID:
01682648
Views:
44
I am using MariaDB 3.1 ODBC connector, and get the following error:
pdDate = {}
SQLEXEC(nHandl, "Update Users set Changed = ?pdDate")
&& Error message: Incorrect date value: '' for column users.ChangeD.
The same works in MySQL without problems. Also when I change the code it would work, but I don't feel comfortable with this solution:
pdDate = 0
SQLEXEC(nHandl, "Update Users set Changed = ?pdDate")
Also the following works:
pdDate = DATE()
SQLEXEC(nHandl, "Update Users set Changed = ?pdDate")
Is this a problem with the ODBC driver or some setting I could look at?
Christian Isberner
Software Consultant
Next
Reply
Map
View

Click here to load this message in the networking platform