问题还是出现，前面两位兄弟没有注意到数据库本身的数据类型
这是我sql中的代码：
query1.ParamByName('begintime').asdatetime:=DateTimePicker3.Date;
query1.ParamByName('endtime').asdatetime:=DateTimePicker4.Date;
query1.sql.add(select * from view where shijian between :begintime and :endtime );
如果在access中怎么修改？(access中是日期时间型，sql中是datetime型)
问题点数：0、回复次数：4Top
1 楼pwzhu666（暴龙）回复于 2003-11-01 16:40:35 得分 0
query1.sql.add(select * from view where shijian between :begintime and :endtime );
query1.ParamByName('begintime').asdatetime:=DateTimePicker3.Date;
query1.ParamByName('endtime').asdatetime:=DateTimePicker4.Date;
open;Top
2 楼pwzhu666（暴龙）回复于 2003-11-01 16:42:08 得分 0
query1.sql.add(select * from view where shijian between :begintime and :endtime );
query1.ParamByName('begintime').asdatetime:=DateTimePicker3.Datetime;
query1.ParamByName('endtime').asdatetime:=DateTimePicker4.Datetime;
open;
Top
3 楼pwzhu666（暴龙）回复于 2003-11-01 16:42:51 得分 0
query1.sql.add(select * from view where shijian between :begintime and :endtime );
query1.ParamByName('begintime').asdatetime:=DateTimePicker3.Datetime;
query1.ParamByName('endtime').asdatetime:=DateTimePicker4.Datetime;
open;
将date 改为datetimeTop
4 楼konhon（优华）回复于 2003-11-01 19:45:18 得分 0
试试下面的:
query1.sql.add(select * from view where shijian between :begintime and :endtime );
query1.ParamByName('begintime').Value:=DateTimeTostr(DateTimePicker3.Datetime);
query1.ParamByName('endtime').Value:=DateTimeTostr(DateTimePicker4.Datetime);
open;
Top
