我用adoquery生成的dataset无法插入记录？
在插入一个合计数记录时，提示：'bmmc' 不允许被更改
bmmc字段是从数据库中由几个字段的值合并得来的。
我的代码如下：
with qryCheck do
begin
close;
sql.clear;
if trim(dwdm.text) = '' then
sql.add('select djh,rq,voucher.bmdm+xx.bmmc as bmmc,voucher.dwdm+zl.dwmc as dwmc,je,yjs,wjs from voucher inner join bmxx xx on xx.bmdm=voucher.bmdm inner join kszl zl on zl.dwdm=voucher.dwdm where voucher.bmdm='+''''+trim(bmdm.text)+''''+' and rq between '+''''+trim(rq1.text)+''''+' and '+''''+trim(rq2.text)+'''')
else
sql.Add('select djh,rq,voucher.bmdm+xx.bmmc as bmmc,voucher.dwdm+zl.dwmc as dwmc,je,yjs,wjs from voucher inner join bmxx xx on xx.bmdm=voucher.bmdm inner join kszl zl on zl.dwdm=voucher.dwdm where voucher.dwdm='+''''+trim(dwdm.text)+''''+' and voucher.bmdm='+''''+trim(bmdm.text)+''''+' and rq between '+''''+trim(rq1.text)+''''+' and '+''''+trim(rq2.text)+'''');
open;
end;
qryCheck.insert;
qryCheck.InsertRecord(['','','','',text,sumje,sumyjs,sumwjs]);
问题点数：20、回复次数：1Top
1 楼twp（twp）回复于 2002-07-05 12:05:31 得分 20
不要用插入纪录，你是想动态统计吗？如果是的话用EHlib中的gridEH吧。Top
