Barbara,

Thanks for the update. My experience was from the various projects I did while working in FPW, not VFP.

FWIW: I usually create temp tables and delete them when I'm done, anyway.

- Gerry

>Gerry, the NOFILTER clause or the 'added field' such as your BogusFld WILL force a new table instead of a filtered table. However, NOTHING will force a cursor to write to disk. Several months ago several of us did some exhaustive testing on this subject We found that if you have sufficient RAM, your cursor will always remain in memory. It still has a 'legal' file name, though, which can be found with the dbf() command. So, to append from a cursor, try:
>

>cFile = dbf('mycursor')
>append from (cfile)
>

>Barbara
>
>>For the most part, cursors are read-only. They're normally in memory only with no disk-based table used. The APPEND FROM command needs an absolute filename to work.
>>
>>You can usually force a cursor to store on the hard disk by forcing a bogus field into the query: SELECT < fields >, .T. AS BogusFld...
>>
>>- Gerry