|

楼主 |
发表于 2010-1-4 17:18:45
|
显示全部楼层
代码中SQL语句
TDecisionDataSet(DataSetBrokerComprehensive.DataSet).DecisionDef.SQL:='SELECT datepart(yy,FbeginTime) AS "发生时间", FBeginDepartment AS "起始部门",'
+'FCategories AS "事故类别", COUNT(AMIS_ACCIDENTMAIN.FAccidentID) AS "发生次数" FROM AMIS_ACCIDENTMAIN'
+'where datepart(yy,FbeginTime)='+cbBeginYear.Text+''
+'GROUP BY datepart(yy,FbeginTime), FBeginDepartment, FCategories'
+'ORDER BY datepart(yy,FbeginTime), FBeginDepartment, FCategories';
数据集SQL语句
SELECT FBeginTime AS "发生时间", FBeginDepartment AS "起始部门", FCategories AS "事故类别", COUNT(AMIS_ACCIDENTMAIN.FAccidentID) AS "发生次数"
FROM AMIS_ACCIDENTMAIN
GROUP BY FBeginTime, FBeginDepartment, FCategories
ORDER BY FBeginTime, FBeginDepartment, FCategories
运行后提示取字段 FbeginTime 无效错误,数据集SQL语句又不能改,这个怎么解决呢? |
|