开始只有一个变量的时候差的没问题,改成下面的代码就查不出来了,请大家指教!!!
begin
query1.close;
query1.sql.Clear;
query1.sql.Add('select * from 人事档案 where :a = :b');
query1.Params[0].AsString:=combobox1.text;
query1.Params[1].AsString:=edit1.text;
query1.prepare;
query1.open;
end;
begin
query1.close;
query1.sql.Clear;
query1.sql.Add('select * from 人事档案 where :a = :b');
query1.Params[0].AsString:=combobox1.text;
query1.Params[1].AsString:=edit1.text;
query1.prepare;
query1.open;
end;
query1.close;
query1.sql.Clear;
query1.sql.Add('select * from 人事档案 where '+combobox1.text+' = :b');
//query1.Params[0].AsString:=combobox1.text;
query1.Params[1].AsString:=edit1.text;
query1.prepare;
query1.open;
end;