>>>Hi All:
>>>
>>>I always thought that you cannot APPEND FROM a table that is in USE. If this is true, would the following work:
>>>
>>>

>>>select * ;
>>>from table1 ;
>>>into cursor curTest
>>>
>>>lcDbf = dbf(curTest)
>>>
>>>USE IN curTest
>>>
>>>use table2
>>>APPEND FROM (lcDbf)
>>>

>>>
>>>Thanks,
>>>
>>>Yossi
>>
>>No it won't work, because you close the cursor.
>>When you close it the table behind disappears.
>>But this should work:
>>

>>select * ;
>>from table1 ;
>>into cursor curTest
>>
>>lcDbf = dbf(curTest)
>>
>>use table2
>>APPEND FROM (lcDbf)
>>

>
>But if I make changes to the data in the cursor, how can I be sure that all the changes have been flushed to the DBF on the disk?

The physical file on disk may not exists at all.