請問大大 以下該如何改 (Q_1為數字,Q_2為文字) 在Edit1.Text輸入數字查詢時有錯 Query1.Close; Query1.SQL.Clear; Query1.SQL.Add('SELECT Distinct Q_2 FROM Q3.dbf'); Query1.SQL.ADD('WHERE Q_1 IS NOT NULL '); Query1.SQL.ADD('AND Q_1=Edit1.Text');//這一段有錯 Query1.OPEN;

------
Xax

不好意思亂碼 在post一次 請問大大以下有錯幫我看看 (Q_1為數字欄位,Q_2為文字欄位) 當Edit1.Text輸入數字時無法查詢 Query1.Close; Query1.SQL.Clear; Query1.SQL.Add('SELECT Distinct Q_2 FROM Q3.dbf'); Query1.SQL.ADD('WHERE Q_1 IS NOT NULL '); Query1.SQL.ADD('AND Q_1=Edit1.Text');//錯誤點 Query1.OPEN;

------
Xax

Query1.Close;
Query1.SQL.Clear;
Query1.SQL.Add('SELECT Distinct Q_2 FROM Q3.dbf');
Query1.SQL.ADD('WHERE Q_1 IS NOT NULL ');
Query1.SQL.ADD('AND Q_1='   Edit1.Text);
Query1.OPEN;

Ian

您好﹗    改成如下試試﹕

begin
  Query1.Close;
  Query1.SQL.Clear;
  Query1.SQL.Add('SELECT Distinct Q_2 FROM Q3.dbf ');
  Query1.SQL.ADD('WHERE Q_1 IS NOT NULL ');
  Query1.SQL.ADD('AND Q_1 = '''+Edit1.Text+'''');//錯誤點
  Query1.OPEN;
end;

================================= 有空來瞅瞅我﹗因為我是您的朋友﹐有您真好﹗ ================================

------
忻晟