Good point Cetin. Thanks for pointing that out. I'll that in mind too...

>Hilmar,
>He has different field namings in each table which would make scatter name more expensive than alternatives IMHO. Also with a scatter array approach he might do much faster inserts doing up to 65000/250 = 260 per insert/append/gather.
>Cetin
>
>>As Tracy suggested, I would try SCATTER NAME.
>>
>>If it works, you have additional advantages, like, you can access individual components by name, like this:
>>
>>

>>use client
>>scatter name loRecord
>>? loRecord.FirstName, loRecord.LastName
>>

>>
>>
>>>I'm having an issue with scatter and gather where data is dropping off. I am scattering data from a table that is in a database and gathering into a free table that must remain free. Their are 250 fields total. Some of the fields are long so I had to use the replace statement to update those.
>>>
>>>This was working for a long time but it seems that my problem occured recently as I've been adding more fields (short field names, matching field name, etc.) to both the database table and free table. Could this be a issue with a memory limitation or the limits of scatter/gather?
>>>
>>>I'd love to use scatter to laArray Memo AND Gather From laArray Memo but I cannot guarentte that the field names, types, length are in order/same in both the database table and the free table.
>>>
>>>Could I just replace:
>>>
>>>

>>>select <destimation>
>>>append blank
>>>gather memvar memo
>>>

>>>
>>>WITH...
>>>
>>>

>>>select <destimation>
>>>scatter memo memvar
>>>INSERT INTO <table name> FROM MEMVAR
>>>

>>>
>>>Does INSERT INTO work better thatn gather memvar memo?
>>>
>>>This was a project that I inherited from a client that a prior programmer started and the EXE/Database/Free Tables are running at multiple locations.
>>>
>>>I am using VFP 6 and any help would be greatly appreciated to resolve my issue.
>>>
>>>Regards,
>>>Torrey
>>>
>>>
>>>
>>>CODE SAMPLE I AM USING:
>>>
>>>

>>>select <source>
>>>scatter memo memvar
>>>
>>>select <destimation>
>>>append blank
>>>gather memvar memo
>>>
>>>replace sdoor1_loose with <source>.sdoor1_loo
>>>replace sdoor2_loose with <source>.sdoor2_loo
>>>replace sdoor3_loose with <source>.sdoor3_loo
>>>replace sdoor4_loose with <source>.sdoor4_loo
>>>