Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Why I cannot search a NULL value ? BUG ?
Message
 
 
To
30/08/2003 13:02:58
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00824792
Message ID:
00824823
Views:
24
Fabio,

>
>IF ISNULL(m.searchValue)
>  GO BOTTOM
>  SKIP
>
The above code is not equivalent to supporting a null value, putting a table ot EOF() is just not the same.

You code should instead look likeL
if ( isnull( m.searchvalue ) )
   locate for isnull( searchedcolumn )
>2. If this is true, why SQL Server support this ?

SQL Server and VFP both full support null field values. In SQL you use IS NULL and IS NOT NULL to find those rows. In VFP you us the isnull() function.

>3. In fact VFP search NULL on index not nullable.

I don't think you truly understand NULL. NULL means that the value is completely indeterminate. Nulls can never be compared to each other or to anything esle. The only valid question to ask a value is if it is null or not, the isnull() function gives you the answer.

>VFP need a complete, coherent, support for NULL.

VFP's null model is complete and coherent once you understand what null means.
df (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform