>>>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?
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.