>>>>>>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?
>>>>>
>>>>>Exactly which syntax did you use?
>>>>
>>>>

>>>>SCAN
>>>>    SCATTER NAME oDbf
>>>>    oDbf.orderno = lcStoreno +'-'+ ALLTRIM(STR(oDbf.orderno))
>>>>    IF !INDEXSEEK(oDbf.orderno,.F.,'rohserv','orderno')
>>>>        SELE rohserv
>>>>        APPEND BLANK
>>>>	GATHER NAME oDbf
>>>>        REPLACE rohserv.storeno WITH lcStoreno IN rohserv
>>>>        UNLOCK
>>>>    ENDIF
>>>>    RELEASE oDbf
>>>>    SELECT( lcTemp )
>>>>ENDSCAN
>>>>

>>>>
>>>>See, nothing special.
>>>>
>>>>>If memo fields are involved, did you remember to use the MEMO keyword?
>>>>
>>>>There is no memo fields.
>>>>
>>>>Thanks for the interest.
>>>
>>>Are you sure that these fields that can't be saved are spelled equally in both tables?
>>
>>Checked agan, and definitely.
>
>Can you name some of the missing fields, and their type?

I found the problem. The store queries its table into a temporary free table. The table is sent to the Home Office. But now the table is free, and the field name longer then 10 have been truncated to 10. When it arrives at the home office and it attempts to insert into the table, the field names for those truncated don't match. I know how to fix it. Thanks all for making think outside the box.