查询条件是caryjk.dbf数据库的字段carnum(字符型)和testdate(日期型) with query1 do begin close; sql.clear; sql.add('select * from caryjk'); sql.add('where carnum like''+'%'+edit1.text+''); sql.add('and where (testdate>=:Fdate) and (testdate<=:Sdate)'); params[0].AsDate:=DateTimePicker1.Date; params[1].AsDate:=DateTimePicker2.date; open; end; 为什么出错?是不是因为第六行有两个and,该怎么办?
----------------------------------------------
李平