Hi,
Thanks, Mr. Hilmar Zonneveld.

It is good that we don't need to declare the array first.

:) Wilfred

>>Hi,
>>
>>You may try to look is there any tool in Download can accomplish this.
>>But it doesn't seem diffcult;try:
>>
>>
>>1. DIMENSION aRecord[2]
>>SCAN
>>??SCATTER FIELDS CO_NAMEA,CO_ADDA TO aRecord
>>??SELECT TABLEB
>>??APPEND BLANK IN TABLEB
>>??GATHER FROM aRecord
>>ENDSCAN
>>
>>2. Select CO_NAMEA as CO_NAMEB, CO_ADDA as CO_ADDB
>>? FROM TABLEA INTO CURSOR TMP_TA
>> SELECT TABLEB
>> APPEND FROM DBF('TABLEA')
>>
>>:) Wilfred
>
>When using SCATTER and GATHER, I recommend taking a look at the NAME clause, which requires only a single variable (with a property for each field):
>
>

>local loRecord
>SCATTER NAME loRecord
>select (OtherTable)
>replace Field1 with loRecord.FieldA, Field2 with loRecord.FieldB
>