C
cameroanthony
Unregistered / Unconfirmed
GUEST, unregistred user!
with form4.ADOQuery1 do
begin
close;
sql.clear;
SQL.ADD('create table #temp(name char(10),age int)');
sql.add('select * from main where 1=1');
if edit2.text<>'' then
begin
sql.add('and (¹¤ºÅ=:wid)');
parameters.parambyname('wid').value:=edit2.text;
end;
if edit4.text<>'' then
begin
sql.add('and (°à´Î=:banci)');
parameters.parambyname('banci').value:=edit4.text;
end;
///老是报错,麻烦诸位指点一下..
begin
close;
sql.clear;
SQL.ADD('create table #temp(name char(10),age int)');
sql.add('select * from main where 1=1');
if edit2.text<>'' then
begin
sql.add('and (¹¤ºÅ=:wid)');
parameters.parambyname('wid').value:=edit2.text;
end;
if edit4.text<>'' then
begin
sql.add('and (°à´Î=:banci)');
parameters.parambyname('banci').value:=edit4.text;
end;
///老是报错,麻烦诸位指点一下..