>>>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.
APPEND locks entire table, and INSERT_SQL locks header only (it's written in VFP manual at least). It will yield big difference for the case of multi-volume data import.
Edward Pikman
Independent Consultant