>>>>>>>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 again, and definitely.
>>
>>Strange, I never had a problem with SCATTER and GATHER construction (when I used it).
>>I even tested it with the different field order:
>>
>>CREATE CURSOR crsTest1 (Fld1 I, Fld2 D, Fld3 C(20))
>>
>>CREATE CURSOR crsTest2 (Fld2 D, Fld3 C(20), Fld1 I, Fld4 T)
>>FOR asd = 1 TO 20
>> INSERT INTO crsTest2 VALUES (DATE()+asd, REPLICATE([A],asd),asd, DATETIME()+asd)
>>NEXT
>>SCAN
>> SCATTER NAME oTest
>> SELECT crsTest1
>> APPEND BLANK
>> GATHER NAME oTest
>> SELECT crsTest2
>>ENDSCAN
>>SELECT crsTest1
>>BROWSE NORMAL
>>
>
>I point out to Tore, the problem that the free table was truncating the field names to 10 character, there for they did match.
>
>Thanks for the help.
I read it.
That didn't comes to my mind, but it should.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.