>>>>We have a Point Of Sales application that consists of seperate two applications; a Home Office and Stores. At the end of the day, all the changes from the store are sent to the home office. These, using a Scatter / Gather in a Scan loop the Home Office's tables are updated. But, not all the fields are getting saved.
>>>>
>>>>With the stage set...
>>>>
>>>>If the field names and data types the same, can anyone think of any other reason the data would not be saved?
>>>
>>>Are the memo fields not copied? Even with the MEMO switch I think these don't get copied (this is for copying from atrrays -> memo)
>>
>> No Memo fields
>>>
>>>Hae you specified the field list?
>>
>> The table structures are near identical (with exception PK fields). There 126 fields in the table and two of the fields are not saved; they are in th middle of the list of field. But there is no explicit field list.
>>
>>>
>>>Why not just use a bulk copying command like APPEND FROM?
>>
>>May be I will.
>
>Or maybe instead of append and gather, use "insert into from memvar"

Another good idea.

The reason the method of using APPEND Blank was used is because this code was originally written VFP 5.0. (or earlier). It has little modification sence.