>>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