>I am doing:
>******************************
>use mytable
>append from other_table
>*******************************
>
>However if other_table is in use, append will fail
>
>Is there a way for appending from an table in use,
>even that I use other commands along or instead of "append"
>
>Moises
Assuming you did not access the table exclusively, you might reopen it and copy to a cursor or table; something like this:
select * from Origin where ...;
into cursor Tmp1
select Destination
append from (dbf("Tmp1"))
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)