求助:hh表数据转入至ff表
求助:将hh表xm2父母亲的姓名、出生日期、住址信息转入至ff 表中的f_xm 父亲的姓名\f_csrq 父亲的出生日期及aadr 住址,m_xm 母亲姓名,m_csrq 母亲的出生日期 二表以bh为连接。附表
本人用vfp6.0
123.rar
(681 Bytes)
谢谢!!!
CLOSE DATABASES SET COLLATE TO "MACHINE" USE ff IN 0 INDEX on bh TAG bh USE hh IN 0 SELECT hh SET RELATION TO bh INTO ff SCAN REPLACE addr WITH hh.addr IN ff IF LEFT(hh.cw, 2) == "父" REPLACE F_xm WITH hh.xm2, F_csrq WITH hh.csrq IN ff ELSE REPLACE M_xm WITH hh.xm2, M_csrq WITH hh.csrq IN ff ENDIF ENDSCAN SET RELATION TO SELECT ff DELETE TAG bh BROWSE