Query.SQL.Add('select count(datename(weekday,dateadd(day,num,'+quotedstr(s1)+'))),星期,桥梁检查座数,count(datename(weekday,dateadd(day,num,'+quotedstr(s1)+')))*桥梁检查座数 as 检查座次 from Num,星期 where Num<=10 and 星期=datename(weekday,dateadd(day,num,'+quotedstr(s1)+'))group by datename(weekday,dateadd(day,num,'+quotedstr(s1)+')),星期,桥梁检查座数 COMPUTE SUM(count(datename(weekday,dateadd(day,num,'+quotedstr(s1)+')))*桥梁检查座数)');
var xx: _Recordset; i: Integer; begin xx:=Query.NextRecordset(i); 取值就用:xx.Fields[0].Value
与这个类似 你的查询结果返回的是两个结果集 with qry1 do begin Close; SQL.Clear; sql.Add('select * from tsttable COMPUTE sum(col1)'); Open; Recordset:=NextRecordset(inta) end;
NextRecordset函数必须使用定义的一个变量i,赋值为i:=1,即可移动到下一个结果集,可惜不能给自己分
i: Integer;
begin
xx:=Query.NextRecordset(i);
取值就用:xx.Fields[0].Value
with qry1 do
begin
Close;
SQL.Clear;
sql.Add('select * from tsttable COMPUTE sum(col1)');
Open;
Recordset:=NextRecordset(inta)
end;
下面的COMPUTE返回一个结果集 所以你要获取计算字段时,需要下移一个结果集OK 当我没来过