QR_Query.Close;
QR_query.SQL.Clear;
QR_query.SQL.Add('select distinct E_EmployeeNo e,S_saleDate d ,sum(s_number*s_price) a from sale ');
QR_query.SQL.Add(' where S_saleDate>=:d and S_saleDate<=:t and E_EmployeeNo=:n ');
QR_query.SQL.Add('group by S_saleDate order by S_saleDate');
QR_query.ParamByName('d').AsDate:=system0.DateTimePicker3.Date;
QR_query.ParamByName('t').Asdate:=system0.DateTimePicker4.Date;
QR_query.ParamByName('n').AsString:=edit17.Text;
try
QR_query.Open;
Except
QR_Query.ExecSQL
End;
上面的代码,运行会出现下面的错误,为什么?
---------------------------
main
---------------------------
When GROUP BY exists, every simple field in projectors must be in GROUP BY.
---------------------------
确定
---------------------------
急啊,救命!
谢谢!
QR_query.SQL.Clear;
QR_query.SQL.Add('select distinct E_EmployeeNo e,S_saleDate d ,sum(s_number*s_price) a from sale ');
QR_query.SQL.Add(' where S_saleDate>=:d and S_saleDate<=:t and E_EmployeeNo=:n ');
QR_query.SQL.Add('group by S_saleDate order by S_saleDate');
QR_query.ParamByName('d').AsDate:=system0.DateTimePicker3.Date;
QR_query.ParamByName('t').Asdate:=system0.DateTimePicker4.Date;
QR_query.ParamByName('n').AsString:=edit17.Text;
try
QR_query.Open;
Except
QR_Query.ExecSQL
End;
上面的代码,运行会出现下面的错误,为什么?
---------------------------
main
---------------------------
When GROUP BY exists, every simple field in projectors must be in GROUP BY.
---------------------------
确定
---------------------------
急啊,救命!
谢谢!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货