怎么解决查询失业人员信息时出的错误

来源：互联网发布：黑页源码带音乐编辑：程序博客网时间：2024/05/05 01:11

在控件的itemchanged函数中，调用父类的itemchanged()函数出错

if SUPER:: EVENT ItemChanged(row,dwo,Data) < 0

在该函数里有执行sql语句select。。。。from v_ys_grjbzl where

视图的原因

CREATE OR REPLACE VIEW V_YS_GRJBZL AS
SELECT --xtjgdm,
(select csdm from ae01 c,s_zhcs_to_aa10 d where c.aab001=a.dwsxh
and d.aaa100='BAE001' and c.bae001=d.aaa102) xtjgdm,
grsxh, dwsxh,gmsfhm,
xm, xb, csrq, rylb, zglb, jflb, ygxz,
hkxz, cjgzrq, ryhbbz, grzt, jbr, jbrq, grbgjlh, spbz, lsbz, spr,
sprq, mz, xzzw, gwylb, hkszd, ylstjfnx, systjfnx, nbstjfnx, yilstjfnx,
bzgz, sczhgzrq, lxrylb, zzrybz, zzryyjss, ygmsfhm, cxzbm, jzddz, jzdyzbm,
cbrlxdh, cbrlxsj, dkyhhh, dkyhhm, dkyhzh, jfly, ssjwh, nbdylx, dfdw, dfyhhh,
dfyhhm, dfyhzh, yjyzbm, yjdz, yjlxrxm, yjlxrdh, whcd, grsf, zyjszw, grjsdj,
jg, grbz1, grbz2, bz, nycbdc, yjrylb, yjys, syyjys, yjbz, gdxybfbz
FROM ys_grjbzl a;

视图里查不到xtjgdm，导致没有数据。

视图的xtjgdm基于ae01,往ae01里导入数据。

执行以下sql语句

insert into ae01 (BAE001, AAB001, CAB003, AAB999, AAB004, AAB021, CAZ011, CAZ012, AAA017, AAE007, AAE004, AAE005, AAE006, AAE159, CAE005, CAE006, AAZ099, AAB077, AAB451, CAC005, AAB034, BHE974, AAB023, AAE108, CAB086, CAB087, CKE113, CKE114, CAB084, CAB085, CKE115, CAB093, CAB083, CAC586, CAB071, CAB080, CAB081, CAA013, BCE326, AAE013, CAEA2X, CAEA2Y)
values ('441302', '2179556', '01', '0783-484747', '叶丽英', '60', '', '2179556', '1', '', '', '', '高营房横巷15号', '', '', '', '', '', '', '', '441302', '', '', '', '', '', '', '', '', '130501', '', '', '', '20', '0783-2062621', '', '', '', '1', '', '20160703015537', '');

0 0