adoquery1.Close;
adoquery1.SQL.Clear;
adoquery1.SQL.Add('select * from (select top 3000 wzdm as 尺码,sum(o_sl) as 销售数量,sum(o_zke) as 销售金额 from (select substring(wzdm,13,3) as wzdm,sum(o_sl) as o_sl ,sum(o_zke) as o_zke from vwokhtotal1 ');
adoquery1.sql.add(' where o_date>=:sdate and o_date<:edate Group by wzdm) as tmp group by tmp.wzdm order by 销售金额 desc ) d ');
adoquery1.sql.add(' union ');
adoquery1.sql.add('select '''+''',sum(o_sl),sum(o_zke) from vwokhtotal1 where o_date>=:sdate and o_date<:edate');
adoquery1.Parameters.parambyname('sdate').value:=datetostr(datetimepicker1.date);
adoquery1.Parameters.parambyname('edate').value:=datetostr(datetimepicker2.date);
adoquery1.open;提示:不正常的定义参数对象,提供了不一致或不完整的信息
sql可以在查询分析器中正常运行
adoquery1.SQL.Clear;
adoquery1.SQL.Add('select * from (select top 3000 wzdm as 尺码,sum(o_sl) as 销售数量,sum(o_zke) as 销售金额 from (select substring(wzdm,13,3) as wzdm,sum(o_sl) as o_sl ,sum(o_zke) as o_zke from vwokhtotal1 ');
adoquery1.sql.add(' where o_date>=:sdate and o_date<:edate Group by wzdm) as tmp group by tmp.wzdm order by 销售金额 desc ) d ');
adoquery1.sql.add(' union ');
adoquery1.sql.add('select '''+''',sum(o_sl),sum(o_zke) from vwokhtotal1 where o_date>=:sdate and o_date<:edate');
adoquery1.Parameters.parambyname('sdate').value:=datetostr(datetimepicker1.date);
adoquery1.Parameters.parambyname('edate').value:=datetostr(datetimepicker2.date);
adoquery1.open;提示:不正常的定义参数对象,提供了不一致或不完整的信息
sql可以在查询分析器中正常运行
解决方案 »
- 风传寒信,遥念故人
- Row handle referred to a deleted row or a row marked for deletion,请问这是什么问题呀?
- ActiveXForm智能提交
- 高强度送分交流代码--只要你有收集代码都可以近来溜溜-有进必给分(不够再给分)
- 如何让这些 speedbutton 能成一组???
- 求书
- 一个简单的问题——在线!!
- 座标问题
- 我在delphi6中写WebServices,现出"XML document must have a top level element. Line : 0"错误,我该如何解决??
- Delphi控制Excel的问题,如何选择性粘贴-->格式??(特急)
- 各位大哥 DELPHI里导入导出原理是怎么样?
- 关于BDE的问题?
sql.add('select * from ta where fdate = '' ' + datetostr(date) + '''');