>>>>I can't confirm this. When I get a temp file and do a DBF(), I can find the open cursor through Win Explorer where DBF() says and with the same name.
>>>>
>>>>>
>>>>>ie if the file returned by dbf() for the cursor is, 45679812.tmp ,
>>>>>actuallly the tmp file in the disk is 45679813.tmp
>>>>>
>>>>>I checked on my m/c,
>>>>>Pl. check and inform me, if true ?
>>>
>>>
>>>Yeah. It sems I am wrong.
>>>Now I got 2 tmp files created with dbf returned file name and +1 file name.
>>>when I selcted a table having 11,300 records and 250 fields.
>>
>>Got the point.
>>issue this in command box,
>>
>>select * from table into cursor mycursor
>>?file(dbf('mycursor'))
>>?dbf('mycursor')
>>
>>You will get .f.
>>Go immediately to Explorer and see it manually, the file is not there.
>>istead (file+1).tmp will be there.
>>Now wait for some seconds, or refresh the explorer, you se the file there.
>>and now go to command window give command .
>>
>>?file(dbf('mycursor'))
>> returns .t.
>>
>>Some refresing and GUI dealy. thats all.
>
>Would it be better to use NOFILTER?

Even then the problem is same if I use nofilter.
I did not see any additional advantage .