Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Why I cannot search a NULL value ? BUG ?
Message
From
30/08/2003 14:27:09
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00824792
Message ID:
00824828
Views:
14
Hi Jozef,

but why i need to ...

If field support NULL, VFP search null and found it.



SET NULL ON
CREATE CURSOR MyCursor ( A I )
INSERT INTO MyCursor VALUES (NULL)
INSERT INTO MyCursor VALUES (1)
INDEX ON A TAG myTag
x=NULL
? type('x') && type of x is "L"
SEEK m.x ORDER 1 && i SEARCH a logical NULL and found a numeric NULL
? found(),'null found '
LOCATE FOR A=NULL && i compare a logical NULL AND, correctly, NOT found it
? found(),' null not found '
<\pre>

Fabio
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform