>>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
>Jos,
>
>Haven't tested it, but I would expect that
>
>INSERT INTO Table2(Field1, Field2) Values (Table1.Field1, Table1.Field2)
>
>would be the fastest.
A couple of years ago I had the same situation at work. I was shocked that
Scatter MEMVAR
insert into target from MEMVAR
was the fastest way to go in VFP6