>>>Thank You In Advance
>>>
>>>
>>>
>>>Winfred Majors
>>
>>Run with SYS(3054,11).
>>There is at least an index defined on a key that not accept a NULL value ( a field not nullable),
>>this tie comes brought back on the index.
>>After a great battle, this has been resolved in VFP9.
>>
>>Another issue: DELETED() and ODLVAL() are not supported in SQL SELECT.
>
>Interesting. Are you saying it's a bug in VFP8?
>

If you talk of the error 1886, yes it is a bug,
because you can seek a NULL value into a not nullable field.

VFPT, before VFP9, apply the field restrictions to the index key,
and this is a bug.

It is as to fire an error if you seek 40 into a field with a check for
BETWEEN(field,1,10).


>I'm getting this error from CursorRefresh method of CA. I do use LEFT JOIN and I thought at first it has to do with NULLs, so I added NVL for each field from the right table (now will have to undo it). It didn't help with the error.

now will have to undo it ? Not true.

now ( in VFP9 ) will CAN to undo it.

Fabio