试试这样
query1.Close;
query1.SQL.Clear;
query1.SQL.Add('select QY,THDW from xs');
query1.SQL.Add('where QY= 0001 ');
query1.Open
query1.Close;
query1.SQL.Clear;
query1.SQL.Add('select QY,THDW from xs');
query1.SQL.Add('where QY= 0001 ');
query1.Open
实在不行用参数试试!
query1.SQL.Add('select QY,THDW from xs ');
query1.SQL.Add('where QY = ''0001'' ');
注意空格,把,sql.text显示出来看看。