var date1,date2:TDateTime;……Date1 := EncodeDate(year, month, 1);Date2 := EncodeDate(year, month, 31);query.SQL.Add('select * from sxdj where sxsj between date1 and date2');這樣為什么不可以？然后我試了一下這種query.SQL.Add('select * from sxdj where sxsj between :date1 and :date2);parameters.parambyname('date1).value:=EncodeDate(year, month, 1);parameters.parambyname('date2').value:=EncodeDate(year, month, 31);error ：object or class type requiredmissing operator or semicolon
sql 語句中between and 查詢， 時間參數(shù)如何傳遞？
jeck貓
2019-05-25 15:15:02