>>>>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.
Greg Reichert