Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Empty Datetime from MySQL and VFP table -- Mismatch
Message
De
25/06/2005 05:55:59
 
 
À
24/06/2005 15:11:57
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
SAMBA Server
Database:
MySQL
Divers
Thread ID:
01026419
Message ID:
01026499
Vues:
23
?NVL( SQLResult.ProcDT, {} ) = NVL( IOL_ACT.ProcDT, {} )
.T.
Has anyone seen this behaviour? Is this a bug?

It is not a bug. If MySQL is like SQL Server, there is no such thing as an empty date. The empty date in SQL Server is NULL. NULL is not the same as empty, that is why you need to wrap it in the NVL function.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform