>>>>Try a NOFILTER clause in your SQL (...INTO CURSOR etc NOFILTER...). You're getting a filtered version of your base table from your query...
>>
>>Thanks Bruce, but that does not work either. If I copy the file to another file (giving it another filename) and try it, it still does not work. As soon as the CDX is set, the error occurs. I have dozens of other tables in the same database which work perfectly OK.
>
>Strange...have you tried a USE DBF AGAIN to see if that gets a better copy of the cursor? Also, maybe the old method of creating a new field in the SQL with the AS clause?
Bruce,
USE DBF AGAIN does not seem to work either. What I cannot figure out is that when my cursor is not indexed, why is it that CDX(1, 'cCursor') returns the .CDX of the parent table? It does not happen with any other file in the database.
Thanks again Bruce.
Sanjay
Sanjay Kapoor
Relatively speaking is a conversation with Einstein