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