請問大家：     我的資料庫查詢時使用到in，在sql builder內 查詢時可以正常使用，但出了sql builder，要將tquery active時就會出現capability not supported， 資料庫：Access2000 程式：bcb5.0 系統：Winxp pro 請問我哪裡錯了嗎？還是bcb5不支援使用in？

s = "SELECT CWM_CD, CWM_TEL, CWM_SDATE, CWM_EDATE, CEP_CD, CBU_CD, CWM_FIN, CWM_totalPT, CPM_CD, CCS_CD, CCS_CD1, CCS_CD2, CCS_CD3, CCS_CD4, CCS_CD5 FROM BWORKS_M ";    s1 = " where BWORKS_M.CWM_SDATE between " IntToStr(int(dtp4->Date)) " and " IntToStr(int(dtp3->Date));    s1 = s1 " and BWORKS_M.CBU_CD IN ('221','2271','236','270','222','223','243','2239','227','239','220','2344')";    Query1->Close();
Query1->SQL->Clear();
Query1->SQL->Add(s s1);
if(!Query1->Prepared)Query1->Prepare();
Query1->Open();