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:
00824855
Views:
17
>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.
George

Ubi caritas et amor, deus ibi est
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform