>>Chuck,
>>
>>Add
NOFILTER clause to your select statment. That will force foxpro to create a physical cursor instead of filtered view of underlaing table.
>
>Thanks for the info. Haven't used the
NOFILTER clause before. Will that leave a .dbf file on disk after the program is closed? One of the reasons I like to use CURSORs for temporary use is that they don't clutter up the directory with temp files left over after the program is closed; and therefore, I don't have to deal with deleting them in my cleanup code.
The temporary DBF/CDX will be deleted as soon as you close cursor.
--sb--