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.