>>>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?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.