我在ADOQuery1中执行sql是如果参数出现多次，那么赋值给它时往往只对第一次出现时起作用，如执行下面的sql select * from customer where fac:=fac union select * from vendor where fac:=fac union select * from customer_and_vendor where fac:=fac ADOQuery1.close; ADOQuery1.Parameters.ParamByName('fac').Value:=edit1.text; ADOQuery1.open; 这时只抓出了table:customer的资料，请问各位大大，有没有好的解决方法。 我又不想用ClientDataSet.

請問妳是否下錯了,應該是如此吧 select * from customer where fac=:fac union select * from vendor where fac=:fac union select * from customer_and_vendor where fac=:fac 其它的請妳參考Union的限制. 另外請問妳所用的SQL為何? MS SQL? 希望能對你有所幫助.

您好﹗    不使用Parameters﹐而改用StringReplace（取代字串）函數試試﹕

begin
  With ADOQuery1 do
  begin
    Close;
    SQL.Clear;
    SQL.Add('select * from customer where fac = factemp union ')
    SQL.Add('select * from vendor where fac = factemp union ')
    SQL.Add('select * from customer_and_vendor where fac = factemp');
    SQL.Text := StringReplace(SQL.Text, 'fcatemp', Edit1.Text, 
      [rfReplaceAll, rfIgnoreCase]);
    Open;
  end;
end;

========================= 大病初愈﹐休養調整中... =========================

------
忻晟