一个新问题。以下排序为什么不能执行。在IB Expert 执行没有问题。sqlclientf.Close;
asql:='select a.czid ,b.name,sum(a.totalamt),count(*) '
+' from xld a, cz b where a.czid=b.czid and a.billdate>'''+DateToStr(datetime1.Date-1)+'''and a.billdate<='''+DateToStr(datetime2.Date)+'''';
if golusql<>'' then
begin
asql:=asql+golusql;
end;
asql:=asql+' group by a.czid,b.name order by 4 desc ,3 ' ;
sqlclientf.CommandText:=asql;
sqlclientf.Open;
asql:='select a.czid ,b.name,sum(a.totalamt),count(*) '
+' from xld a, cz b where a.czid=b.czid and a.billdate>'''+DateToStr(datetime1.Date-1)+'''and a.billdate<='''+DateToStr(datetime2.Date)+'''';
if golusql<>'' then
begin
asql:=asql+golusql;
end;
asql:=asql+' group by a.czid,b.name order by 4 desc ,3 ' ;
sqlclientf.CommandText:=asql;
sqlclientf.Open;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货