qmoney.Close; qmoney.SQL.Clear; qmoney.SQL.Add('select * from money1 where a004 between' #39 edit1.text #39 'and' #39 edit1.text #39); qmoney.Open; 以上是錯誤的語法 請教該如何改? 「堅持」從洗馬桶做起 Aric

What is the field type of a004? string? datetime? For string: qmoney.SQL.Add('select * from money1 where a004 between ' QuotedStr(edit1.text) ' and ' QuotedStr(edit1.text)); Remember the "space".... For datetime, MS Access needs # instead of ' in quoting the text.

引言: qmoney.SQL.Add('select * from money1 where a004 between #' QuotedStr(edit2.text) '# and #' QuotedStr(edit3.text) '#'); A004是用PARADOX 中的DATE型態 以上的語法不知那裏錯了?

「堅持」從洗馬桶做起 Aric

'#' is for Access only (no need for ').. Anyway using parameter is more general solution:    

qmoney.SQL.Add('select * from money1 where a004 between :D1 and :D2');
qmoney.ParamByName('D1').AsDateTime := StrToDateTime(trim(Edit1.Text));
qmoney.ParamByName('D2').AsDateTime := StrToDateTime(trim(Edit1.Text));

引言: 謝謝

「堅持」從洗馬桶做起 Aric