Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Why I cannot search a NULL value ? BUG ?
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00824792
Message ID:
00824877
Views:
20
>>Hi,
>>
>>If i search a NULL on a INDEX with keys not nullable,
>>VFP fire a error "Data type mismatch"
>>
>>
>>SET NULL ON
>>CREATE CURSOR MyCursor ( A I UNIQUE)
>>x=NULL
>>SEEK m.x ORDER 1
>>
>>
>>For me, correct is ( like SQL Server ) not found.
>>
>Fabio,
>
>In VFP and most other languages, NULL = NULL is false. It's because neither side of the expression can be evaluated.

Whoops, George. NULL = NULL is NULL, not false.

Alan
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform