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