P
pqzemily
Unregistered / Unconfirmed
GUEST, unregistred user!
COM+中ADOQUERY执行语句
insert into gb_spb(DKJE,dwdm,alterkey, alterdate, recordno, projectid, sqlx, dcbh, spbh, rf1, rf1_fddbrxm,
rf1_dwmc, rf1_dwxz, rf1_zgbm, rf1_txdz, rf2, rf2_fddbrxm, rf2_dwmc, rf2_dwxz, rf2_zgbm, rf2_txdz, zl, th,
dh, tdzmj, gd, hd, st, yd, ld, mcd, jmdjgkyd, zjd, qyjsyd, jtyd, sy, wlytd, dymj, dyjzzd, gyftmj, gyftjzzd, bddj,
sbdj, jzxg, jzrjl, jzmd, yt, tddj, qsxz, syqlx, syqx, zzrq, sbjzwqs, jzwlx, qsly, txql, qlrzs, gymj, xbnr, cxqx, js,
jszh, zdmj, pfh, ztdzh, pfmj, txmj, sdrq, dydkje, qlsx, zjje, zjjnfs, jzwzdmj, rmzf, sprq, dyjzzdmj, gyqmj, ftjzzdmj,
txqllx)(select DKJE,dwdm,alterkey, alterdate, recordno, 2764, sqlx, dcbh, '审批国用（2005）第3号', rf1,
rf1_fddbrxm, rf1_dwmc, rf1_dwxz, rf1_zgbm, rf1_txdz, rf2, rf2_fddbrxm, '赵', rf2_dwxz, rf2_zgbm, rf2_txdz,
zl, th, '014010910064', tdzmj, gd, hd, st, yd, ld, mcd, jmdjgkyd, zjd, qyjsyd, jtyd, sy, wlytd, dymj, dyjzzd,
gyftmj, gyftjzzd, bddj, sbdj, jzxg, jzrjl, jzmd, yt, tddj, qsxz, syqlx, syqx, zzrq, sbjzwqs, jzwlx, qsly, txql, qlrzs,
gymj, xbnr, cxqx, js,
jszh, zdmj, pfh, ztdzh, pfmj, txmj, sdrq, dydkje, qlsx, zjje, zjjnfs, jzwzdmj, rmzf, sprq, dyjzzdmj, gyqmj, ftjzzdmj,
txqllx from gb_spb where ProjectID=8000025)
后，居然只有个别数据插入表中，其余都没有插进去，但SQL语句在SQLPLUS中执行是能够将数据全部插入到表中的，请问有哪位碰到过这种问题。
insert into gb_spb(DKJE,dwdm,alterkey, alterdate, recordno, projectid, sqlx, dcbh, spbh, rf1, rf1_fddbrxm,
rf1_dwmc, rf1_dwxz, rf1_zgbm, rf1_txdz, rf2, rf2_fddbrxm, rf2_dwmc, rf2_dwxz, rf2_zgbm, rf2_txdz, zl, th,
dh, tdzmj, gd, hd, st, yd, ld, mcd, jmdjgkyd, zjd, qyjsyd, jtyd, sy, wlytd, dymj, dyjzzd, gyftmj, gyftjzzd, bddj,
sbdj, jzxg, jzrjl, jzmd, yt, tddj, qsxz, syqlx, syqx, zzrq, sbjzwqs, jzwlx, qsly, txql, qlrzs, gymj, xbnr, cxqx, js,
jszh, zdmj, pfh, ztdzh, pfmj, txmj, sdrq, dydkje, qlsx, zjje, zjjnfs, jzwzdmj, rmzf, sprq, dyjzzdmj, gyqmj, ftjzzdmj,
txqllx)(select DKJE,dwdm,alterkey, alterdate, recordno, 2764, sqlx, dcbh, '审批国用（2005）第3号', rf1,
rf1_fddbrxm, rf1_dwmc, rf1_dwxz, rf1_zgbm, rf1_txdz, rf2, rf2_fddbrxm, '赵', rf2_dwxz, rf2_zgbm, rf2_txdz,
zl, th, '014010910064', tdzmj, gd, hd, st, yd, ld, mcd, jmdjgkyd, zjd, qyjsyd, jtyd, sy, wlytd, dymj, dyjzzd,
gyftmj, gyftjzzd, bddj, sbdj, jzxg, jzrjl, jzmd, yt, tddj, qsxz, syqlx, syqx, zzrq, sbjzwqs, jzwlx, qsly, txql, qlrzs,
gymj, xbnr, cxqx, js,
jszh, zdmj, pfh, ztdzh, pfmj, txmj, sdrq, dydkje, qlsx, zjje, zjjnfs, jzwzdmj, rmzf, sprq, dyjzzdmj, gyqmj, ftjzzdmj,
txqllx from gb_spb where ProjectID=8000025)
后，居然只有个别数据插入表中，其余都没有插进去，但SQL语句在SQLPLUS中执行是能够将数据全部插入到表中的，请问有哪位碰到过这种问题。