各位老师好！
我想将a表的部分字段复制到b表，2个表有相同的字段，也有不相同的字段。需要复制的是相同字段的一部分，不是全部相同的字段。不相同的字段不复制。
用了以下方法：
COPY TO 复制个数1 FIELDS LIKE qihao,h1,h2,h3,h1s1,h1s2,h1s3,h1s4,h1s5,h1s6,h1s7,h1s8......（共49个字段）结果是b表不相同的字段都没有了；


insert into 复制个数1(qihao,h1,h2,h3,;
                      h1s1,h1s2,h1s3,h1s4,h1s5,h1s6,h1s7,h1s8,h1s9,h1s10,h1s11,h1s12,h1s13,h1s14,h1s15,;
                      h2s1,h2s2,h2s3,h2s4,h2s5,h2s6,h2s7,h2s8,h2s9,h2s10,h2s11,h2s13,h2s13,h2s14,h2s15,;
                      h3s1,h3s2,h3s3,h3s4,h3s5,h3s6,h3s7,h3s8,h3s8,h3s10,h3s11,h3s12,h3s13,h3s14,h3s15,;
select qihao,h1,h2,h3,h1s1,h1s2,h1s3,h1s4,h1s5,h1s6,h1s7,h1s8,h1s9,h1s10,h1s11,h1s12,h1s13,h1s14,h1s15,;
                      h2s1,h2s2,h2s3,h2s4,h2s5,h2s6,h2s7,h2s8,h2s9,h2s10,h2s11,h2s12,h2s13,h2s14,h2s15,;
                      h3s1,h3s2,h3s3,h3s4,h3s5,h3s6,h3s7,h3s8,h3s9,h3s10,h3s11,h3s12,h3s13,h3s14,h3s15;
FROM 分列统计15期 CLEAR
结果是select后面的语句太长，VF死机。

COPY TO ARRAY sz1 FIELDS like qihao,h1,h2,h3,;
               h1s1,h1s2,h1s3,h1s4,h1s5,h1s6,h1s7,h1s8,h1s9,h1s10,h1s11,h1s12,h1s13,h1s14,h1s15,;
               h2s1,h2s2,h2s3,h2s4,h2s5,h2s6,h2s7,h2s8,h2s9,h2s10,h2s11,h2s12,h2s13,h2s14,h2s15,;               
               h3s1,h3s2,h3s3,h3s4,h3s5,h3s6,h3s7,h3s8,h3s8,h3s10,h3s11,h3s12,h3s13,h3s14,h3s15;
               all
运行没有问题，但不知道是否将49个字段的记录都复制到数组。
SELECT 复制个数1
append FROM ARRAY sz1 FIELDS qihao,h1,h2,h3,;     
                         h1s1,h1s2,h1s3,h1s4,h1s5,h1s6,h1s7,h1s8,h1s9,h1s10,h1s11,h1s12,h1s13,h1s14,h1s15,;
                         h2s1,h2s2,h2s3,h2s4,h2s5,h2s6,h2s7,h2s8,h2s9,h2s10,h2s11,h2s12,h2s13,h2s14,h2s15,;               
                         h3s1,h3s2,h3s3,h3s4,h3s5,h3s6,h3s7,h3s8,h3s8,h3s10,h3s11,h3s12,h3s13,h3s14,h3s15
运行结果是找不到sz1.

第四种方法：
scatter FIELDS qihao,h1,h2,h3,;
               h1s1,h1s2,h1s3,h1s4,h1s5,h1s6,h1s7,h1s8,h1s9,h1s10,h1s11,h1s12,h1s13,h1s14,h1s15,;
               h2s1,h2s2,h2s3,h2s4,h2s5,h2s6,h2s7,h2s8,h2s9,h2s10,h2s11,h2s12,h2s13,h2s14,h2s15,;               
               h3s1,h3s2,h3s3,h3s4,h3s5,h3s6,h3s7,h3s8,h3s8,h3s10,h3s11,h3s12,h3s13,h3s14,h3s15;
               to sz1
运行没有问题
gather from sz1 FIELDS qihao,h1,h2,h3,;     
                         h1s1,h1s2,h1s3,h1s4,h1s5,h1s6,h1s7,h1s8,h1s9,h1s10,h1s11,h1s12,h1s13,h1s14,h1s15,;
                         h2s1,h2s2,h2s3,h2s4,h2s5,h2s6,h2s7,h2s8,h2s9,h2s10,h2s11,h2s12,h2s13,h2s14,h2s15,;               
                         h3s1,h3s2,h3s3,h3s4,h3s5,h3s6,h3s7,h3s8,h3s8,h3s10,h3s11,h3s12,h3s13,h3s14,h3s15
运行后提示找不到sz1

请各位老师帮助指导。谢谢。

你说的是复制指定字段的数据吧。也就是将a中的部分字段的数据追加到b。我以以为用以下两种方法都可以。
1、建立一个中间空表temp，只包含需要从a中复制的字段。
sele temp
appe from a
sele b
appe from temp
2、建立一个视图 V_b
其中只选需要增加的字段，也可以全选，只更新需要的字段。
sele v_b
appe from a

* 是不是这样的结果
CLOSE DATABASES ALL
USE 表b IN 0
ZAP
TEXT TO lcStr NOSHOW TEXTMERGE
qihao,h1,h2,h3,h1s1,h1s2,h1s3,h1s4,h1s5,h1s6,h1s7,h1s8,h1s9,h1s10,h1s11,h1s12,h1s13,h1s14,h1s15,h2s1,h2s2,h2s3,h2s4,h2s5,h2s6,h2s7,h2s8,h2s9,h2s10,h2s11,h2s12,h2s13,h2s14,h2s15,h3s1,h3s2,h3s3,h3s4,h3s5,h3s6,h3s7,h3s8,h3s9,h3s10,h3s11,h3s12,h3s13,h3s14,h3s15
ENDTEXT
SELECT 表b
APPEND FROM 表a FIELDS &lcStr
BROWSE

[此贴子已经被作者于2021-5-19 10:09编辑过]

APPEND FROM ... 相同字段会自动对应的
这样看看

CREATE CURSOR t1 (f1 I,f2 I,f3 I,f4 I,f5 I,f6 I,f7 I)
FOR i=1 TO 10
    INSERT INTO t1 VALUES (i,2*i,3*i,4*i,5*i,6*i,7*i)
ENDFOR
CREATE CURSOR t2 (f1 I,f3 I,f5 I,f7 I)
APPEND FROM DBF("t1")
SELECT * FROM t2

所以，这样就可以：
USE 表b
ZAP
APPEND FROM 表a
SELECT * FROM 表b

sdta老师，你好！
你帮我写的程序，试运行，在后面第二行显示：语法错误。不知为什么？

楼上的代码是用VFP9写的
错误代码第几行？

sdta老师，你好！
错误：APPEND FROM 分列统计15期 FIELDS &lcStr  &&语法错误

分列统计15期 这个表在你的附件中怎么没有看到

xuminxz老师，你好！
你的2个思路，非常好！
第一个思路，我试了，运行顺畅。第二个思路，视图要求在数据库环境下，我的表都是自由表，所以没试。但我想也会很好。
谢谢！

就是表a