>>>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.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.