str:='select a.enterpriseid ,a.enterprisename ,b.vrealmoney,b.ovrealmoney,c.vaz,d.vbzjs,e.rvaz,f.vaguerdon,';
str:=str+' b.srealmoney,b.osrealmoney,c.saz ,d.sbzjs,e.rsaz,f.saguerdon,';
str:=str+' b.irealmoney,b.oirealmoney,c.eiz,d.lbzjs,e.reiz,f.eiguerdon,b.erealmoney,b.oerealmoney,c.elz,d.ebzjs,e.relz,f.elguerdon';
str:=str+' from "basicinfo" a,"bili" b,"bzview" c,"Tpzjs" d,"Tbnsd" e,"Tbnjl" f,"correlation" g';
str:=str+'where a.enterpriseid=b.enterpriseid and a.enterpriseid=c.enterpriseid and a.enterpriseid=d.enterpriseid and a.enterpriseid=e.enterpriseid and a.enterpriseid=f.enterpriseid and a.enterpriseid=g.enterpriseid';
str:=str+' b.srealmoney,b.osrealmoney,c.saz ,d.sbzjs,e.rsaz,f.saguerdon,';
str:=str+' b.irealmoney,b.oirealmoney,c.eiz,d.lbzjs,e.reiz,f.eiguerdon,b.erealmoney,b.oerealmoney,c.elz,d.ebzjs,e.relz,f.elguerdon';
str:=str+' from "basicinfo" a,"bili" b,"bzview" c,"Tpzjs" d,"Tbnsd" e,"Tbnjl" f,"correlation" g';
str:=str+'where a.enterpriseid=b.enterpriseid and a.enterpriseid=c.enterpriseid and a.enterpriseid=d.enterpriseid and a.enterpriseid=e.enterpriseid and a.enterpriseid=f.enterpriseid and a.enterpriseid=g.enterpriseid';
改为:
str:=str+' from basicinfo a,bili b,bzview c,Tpzjs d,Tbnsd e,Tbnjl f,correlation g ';
select a.enterpriseid ,a.enterprisename ,b.vrealmoney,b.ovrealmoney,c.vaz,d.vbzjs,e.rvaz,f.vaguerdon, b.srealmoney,b.osrealmoney,c.saz ,d.sbzjs,e.rsaz,f.saguerdon, b.irealmoney,b.oirealmoney,c.eiz,d.lbzjs,e.reiz,f.eiguerdon,b.erealmoney,b.oerealmoney,c.elz,d.ebzjs,e.relz,f.elguerdon from "basicinfo" a,"bili" b,"bzview" c,"Tpzjs" d,"Tbnsd" e,"Tbnjl" f,"correlation" gwhere a.enterpriseid=b.enterpriseid and a.enterpriseid=c.enterpriseid and a.enterpriseid=d.enterpriseid and a.enterpriseid=e.enterpriseid and a.enterpriseid=f.enterpriseid and a.enterpriseid=g.enterpriseid要不这里改一改:
str:=str+' from "basicinfo" a,"bili" b,"bzview" c,"Tpzjs" d,"Tbnsd" e,"Tbnjl" f,"correlation" g';
把所有的""去掉看一看!
你使用这种形式试一下:
将一个Str字符串拆成许多个字符串,最在分段向TQuery控件中添加
Query1.SQL.Add(Str);
Query1.SQL.Add(Str1);
......
看一下,看看表,子段的名字是不是都写对了。