>>>>>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 .

To be honest, I've lost what was the problem :)