Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Serious bug not fixed
Message
From
11/06/2004 04:01:44
 
General information
Forum:
Visual FoxPro
Category:
Visual FoxPro Beta
Miscellaneous
Thread ID:
00912289
Message ID:
00912563
Views:
7
VFP Data Engine allow a null expression into the where condition,
and this is a bug on the VFP Parser:

Run this:
CLEAR
CREATE CURSOR _TABLE (F1 L NULL)

SELECT 2 FROM _TABLE T1 WHERE ! .NULL. INTO ARRAY zz   && this skip the row
SELECT 2 FROM _TABLE T1 WHERE .NULL. INTO ARRAY zz     && this fire a syntax error
Previous
Reply
Map
View

Click here to load this message in the networking platform