我激活ADOQUERY时出现这样的错误,不正常的定义参数对象,提供了不一致或部完整的信息
我的SQL语句是
select xm as 姓名 , sum(gzl*zlxs) as 总计工作量,sum(gzl*zlxs*gzzy) as 所得金额 ,((sum(gzl*zlxs)+sum(hq)/count(cj)+sum(xmgzl)/count(cj))/(select sum(gzl*zlxs) from hs where xmid=:id )/(select count(distinct xm) from hswhere xmid=:id )+sum(zlxs)/count(cj)+sum(xmgzl)/count(cj) as 评定 from hs where xmid=:id group by xm
实在不知道为什么?
我的SQL语句是
select xm as 姓名 , sum(gzl*zlxs) as 总计工作量,sum(gzl*zlxs*gzzy) as 所得金额 ,((sum(gzl*zlxs)+sum(hq)/count(cj)+sum(xmgzl)/count(cj))/(select sum(gzl*zlxs) from hs where xmid=:id )/(select count(distinct xm) from hswhere xmid=:id )+sum(zlxs)/count(cj)+sum(xmgzl)/count(cj) as 评定 from hs where xmid=:id group by xm
实在不知道为什么?
ID XMID(项目ID) XM(姓名)CJ(图片名) GZL(工作量) ZLXS(质量系数) HQ(附加值) XMGZL(附加值2) JX(附加值3)和另外的表的ID XMMC(项目名称) 对应了
, sum(gzl*zlxs) as 总计工作量
,sum(gzl*zlxs*gzzy) as 所得金额 ,
(((sum(gzl*zlxs)+sum(hq)/count(cj)+sum(xmgzl)/count(cj))/
(select sum(gzl*zlxs) from hs where xmid= ' + id + ' )
/(select count(distinct xm) from hswhere xmid= ' + id + ' )
+sum(zlxs)/count(cj)+sum(xmgzl)/count(cj)) as 评定 from hs
where xmid= ' + id + '
group by xm');
你这样运行一下试试,不行就把表给我,[email protected],发了以后,和我说一声,(在线等你)
'sum(gzl*zlxs*gzzy) as 所得金额 ,'+
'((sum(gzl*zlxs)+sum(hq)/count(cj)+sum(xmgzl)/count(cj))/(select'+
' sum(gzl*zlxs)'+ 'from hs where xmid=:id )/(select count(distinct xm)'+
' from hswhere 'xmid=:id )'+
'+sum(zlxs)/count(cj)+sum(xmgzl)/count(cj) as 评定 from hs'+
' where xmid=:id group by xm
id(自动增加) xmid(int), xm(STR) ,cj(STR), gzl(小数) ,zlxs(小数) ,hq(小数) ,XMGZL(小数), jx(小数)
xmdf表
id, xmmc