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