請問如何在TQuery中用sql的語法重複的截取資料,並在dbgrid中顯示出來. edit_day 是一個tedit的元件,我在這做判讀來截取tquery的資料,首次執行時沒問題,當我把focus移到上一tedit時(即edit_num),重新給一個值時,則出現錯誤訊,請各位大大給予指教. procedure TFormOINVP.EDIT_DAYEnter(Sender: TObject); begin Query1.SQL.Add('select * from oitem where oit_num = "' edit_num.Text '"'); Query1.Close; Query1.Open; end; procedure TFormOINVP.EDIT_NUMEnter(Sender: TObject); begin Query1.Close; end; 錯誤訊息為:EDBEngineError with message'Invalid use of keyword Token:select Line Number :2

Query1.SQL.Add('select * from oitem where oit_num = "' edit_num.Text '"'); 改成 : Query1.SQL.text := 'select * from oitem where oit_num = "' edit_num.Text '"'; 因為你的 Add 每次執行加多一句進 Query1.SQL 裡