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

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.