>>Is it faster to use insert-sql to copy records from one table to another? If so, how do you use insert to move multiple records?
>>
>>Thanks in Advance,
>>
>>Bill Chadbourne
>>wchad@ime.net
>
>I do not know if it is faster or not but the VFP SQL would be
>
>Insert into Mytable from ArrayName
>
>So all records have to be copied from the source table to an array first then inserted into the target table. I forget which one only locks file header versus locking the entire file (shared file use), either inserting records or appending from.
The file has to be locked with both insert and append, because the record counter is in the header. Also, I believe that insert is supposed to be much faster.