Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Empty Datetime from MySQL and VFP table -- Mismatch
Message
From
25/06/2005 05:55:59
 
 
To
24/06/2005 15:11:57
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
SAMBA Server
Database:
MySQL
Miscellaneous
Thread ID:
01026419
Message ID:
01026499
Views:
22
?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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform