adoquery4.ConnectionString:='Provider=MSDASQL.1;Extended Properties="Driver={Microsoft Visual Foxpro Driver};SourceType=DBF;SourceDB='+'E:\'+'"';
adoquery4.Close;
adoquery4.SQL.Clear;
adoquery4.SQL.Add('select case when a.name<>'''' then a.name '
+' else b.name end) as 姓名 ,' //第一列
+' a.totaljob, ' //第二列
+' a.totalpass, ' //第三列
+' (case when a.totaljob>0 then cast(cast(a.totalpass as float)/cast(a.totaljob as float)as numeric(10,4)) else 0 end)*100 as 一次通过率 , ' //第四列
+' a.worktime, ' //第五列
+' (a.error+b.error) as error, ' //第六列
+' (case when a.worktime>0 then cast(cast(b.error as float)/cast(a.worktime as float)as numeric(10,2)) else 0 end) as 缺陷产出率 , ' //第七列
+' (a.easyerror+b.easyerror) as easyerror, ' //第八列
+' (case when error>0 then cast(cast(easyerror as float)/cast(error as float)as numeric(10,4)) else 0 end)*100 as 易现缺陷比例 , ' //第九列
+' (a.bigerror+b.bigerror) as bigerror, ' //第十列
+' (case when error>0 then cast(cast(bigerror as float)/cast(error as float)as numeric(10,4)) else 0 end)*100 as 重大缺陷比例, ' //第十一列
+' a.others '
+' from "e:\btotal.dbf" a, "e:\ctotal.dbf" b'
+' where a.name=*b.name '); //除统计外的输出结果
Adoquery4.Open;
运行到最后一行的时候提示[Microsoft][ODBC Visual FoxPro Driver]command contains unrecognized phrase/keyword,请问是什么问题啊
adoquery4.Close;
adoquery4.SQL.Clear;
adoquery4.SQL.Add('select case when a.name<>'''' then a.name '
+' else b.name end) as 姓名 ,' //第一列
+' a.totaljob, ' //第二列
+' a.totalpass, ' //第三列
+' (case when a.totaljob>0 then cast(cast(a.totalpass as float)/cast(a.totaljob as float)as numeric(10,4)) else 0 end)*100 as 一次通过率 , ' //第四列
+' a.worktime, ' //第五列
+' (a.error+b.error) as error, ' //第六列
+' (case when a.worktime>0 then cast(cast(b.error as float)/cast(a.worktime as float)as numeric(10,2)) else 0 end) as 缺陷产出率 , ' //第七列
+' (a.easyerror+b.easyerror) as easyerror, ' //第八列
+' (case when error>0 then cast(cast(easyerror as float)/cast(error as float)as numeric(10,4)) else 0 end)*100 as 易现缺陷比例 , ' //第九列
+' (a.bigerror+b.bigerror) as bigerror, ' //第十列
+' (case when error>0 then cast(cast(bigerror as float)/cast(error as float)as numeric(10,4)) else 0 end)*100 as 重大缺陷比例, ' //第十一列
+' a.others '
+' from "e:\btotal.dbf" a, "e:\ctotal.dbf" b'
+' where a.name=*b.name '); //除统计外的输出结果
Adoquery4.Open;
运行到最后一行的时候提示[Microsoft][ODBC Visual FoxPro Driver]command contains unrecognized phrase/keyword,请问是什么问题啊
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货