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