Suppose we have a cursor with some records tagged for export and we want to append these records into a table. VFP does not support APPEND FROM CURSOR soe we have to do something like:

select mycursor
copy to array myarray for somecondition
select newtable
append from array myarray

It appears that the copy to array command does not clean out any old data from the array so that subsequent appends pull in some of the old data that was not overwritten by the last copy to array command. This would be consistent with VFP documentation. (I think) So my question is - Is this technique the best way to accomplish an APPEND FROM CURSOR and if it is, how do I make sure the array is empty before I copy to array again?

Or is there a better way?


Thanks for any insights.