【结帖】执行sql报错！**

Jsun2007

sql语句在sqlserver里执行正常，但调用DataSetBroker1.DataSet.Open;报错

Jsun2007

sql语句如下：
select t.datetime as 时间,
round(t0.value,2) as DB1额定值烟流量,round(t1.value,2) as DB1实际值烟流量
from (select t.datetime,t.value from history t
where (wwRetrievalMode = 'Cyclic' and wwResolution = 5000 and opcquality=192)
and t.tagname in ('Z11DB1Value_1') and t.datetime >= '2007-11-26 08:30:00'
and t.datetime <= '2007-11-26 09:00:00') t0,(select t.datetime,t.value from history t
where (wwRetrievalMode = 'Cyclic' and wwResolution = 5000 and opcquality=192)
and t.tagname in ('Z11DB1Value_2') and t.datetime >= '2007-11-26 08:30:00'
and t.datetime <= '2007-11-26 09:00:00') t1,
(Select distinct t.datetime  
from openquery(InSQL,'select  t.datetime from history t  
where t.tagname in ("Z11DB1Value_1","Z11DB1Value_2")
and t.datetime >=''2007-11-26 08:30:00'' and t.datetime <=''2007-11-26 09:00:00''
and (wwRetrievalMode = "Cyclic" and wwResolution = 5000 and opcquality=192)') t) t
where  t.datetime = t0.datetime and t.datetime = t1.datetime

lixy

用tquery控件处理吧。

Jsun2007

为什么？

Jsun2007

tquery不支持打印

lixy

那就用个视图，然后标准数据集连视图。

lixy

楼主请回馈

jiahaiminghr

由于长时间没有反馈，先结帖了。
有问题请开新帖。