請問各位先進 我想要從TABLE元件中多篩選值出來就會發生錯誤,請問是這一個元件不允許這樣做嗎,還是有別的些法,請各位先進賜教. PS:我用SQL語法測試卻可以達成我要的目的(資料庫為 SQL SERVER) {select em_name,em_dn_sub_id from employee e where em_dn_id=18 and em_dn_sub_id not in (25,87,88,89)} //--------------------------------------------------------------------------------- DataModule_Employee.query_subid.active:=false; DataModule_Employee.query_subid.sql.clear; DataModule_Employee.query_subid.sql.text:='select ds.dn_sub_id from division d,division_sub ds where d.dn_id=ds.dn_id and d.dn_id=' strDeptID ''; DataModule_Employee.query_subid.active:=true; //--------------------------------------------------------------------------------- strEmpFilter := strEmpFilter format(' AND (EM_DN_ID = %s) ', [strDeptID]); strEmpFilter := strEmpFilter ' and (em_dn_sub_id not in (25,87,88,89))';<========加入這一行就會發生錯誤 =============================================================================================== DataModule_Employee.Table_Employee.Filter := strEmpFilter; 發表人 - cd109 於 2004/09/09 13:15:36

建議你用TDataSet.OnFilterRecord來解決,用filter的話,有許多的限制,會因為後端資料庫的不同而有差異,不是所有的指令都能用 至於TDataSet.OnFilterRecord用法,可以參考這裡: http://delphi.ktop.com.tw/topic.php?topic_id=55505 http://delphi.ktop.com.tw/topic.php?topic_id=37639