>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
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
