Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Error empty date with MariaDB
Message
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Error empty date with MariaDB
Divers
Thread ID:
01682648
Message ID:
01682648
Vues:
45
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform