Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Why I cannot search a NULL value ? BUG ?
Message
 
 
À
30/08/2003 13:02:58
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00824792
Message ID:
00824823
Vues:
25
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform