部分代码如下:
DataModule2.Query1.SQL.Add('select * from emailtable where 入库时间 between '''+DateTimePicker1.Date+''' and '''+DateTimePicker2.Date+ '''')
怎么就通不过呢?
DataModule2.Query1.SQL.Add('select * from emailtable where 入库时间 between '''+DateTimePicker1.Date+''' and '''+DateTimePicker2.Date+ '''')
怎么就通不过呢?
access应这样DataModule2.Query1.SQL.Add('select * from emailtable where 入库时间 between #'+datetostr(DateTimePicker1.Date)+'# and #'+datetostr(DateTimePicker2.Date)+ '#')
你要不用参数吧,