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