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ù)如何傳遞?
紅糖糍粑
2019-05-16 11:10:06