Hi Jos
I just did a quick test appending 10000 records, Using scatter/gather name took 2 seconds where scatter/gather using array took 1 second so in my simple test it would appear that the array method is faster by a factor of 2. YMMV.
Elmer
>Elmer, any speed difference between SCATTER to array vs. an object?
>
>
>>What about SCATTER and GATHER?
>>
>>Select Table1
>>scatter name oRec2copy
>>select Table2
>>append blank
>>gather name oRec2copy
>>
>>OR
>>
>>Select Table1
>>scatter to aRec2copy
>>insert into Table2 from array aRec2copy
>>
>>
>>
>>>Hi All,
>>>
>>>Looking for alternatives: given two tables with the same fields structure what is the fastest way to copy a single record from one file to another?
>>>
>>>Thanks