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