一个sql语句查询出错难题,不知怎么修改,请各位高手帮忙!!!!!

Question

我在adoquery1中
with adoquery1 do
begin
close;
sql.clear;
sql.Add('select factoryid,count(*) as rolls,');
sql.Add('number=dbo.f_get(factoryid,bagid),total=dbo.f_get2(factoryid,bagid),bagid');
sql.Add('into ## from T_checkclientdata where factoryid='''+trim(edit1.Text)+'''');
sql.Add('group by factoryid,bagid');
execsql;
open;
end;
执行出现'_'附近有语法错误

Answer 1

with adoquery1 do
begin
close;
sql.clear;
sql.Add('select factoryid,count(*) as rolls,');
sql.Add('number=dbo.f_get(factoryid,bagid),total=dbo.f_get2(factoryid,bagid),bagid');
sql.Add('into #t from T_checkclientdata where factoryid='chr(39)+trim(edit1.Text)+chr(39));
sql.Add(' group by factoryid,bagid');
execsql;
close;
sql.clear;
open;
end;

Answer 2

memo1.text := sql.text;把memo1.text拷贝到查询分析器里执行看看