Hi Elmer. Yes I am using SCATTER/GATHER but was asking just in case there was something even faster. Thanks.
>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
In the End, we will remember not the words of our enemies, but the silence of our friends - Martin Luther King, Jr.