用Adodc控件绑定MSHFLexGRID控件.在ADODC控件属性里---------记录源的SQL文本里 写一个以日期为查询条件的语句
但是总是提示日期格式错误.语句:select * from tb_out where [shijian]=#"& (DTP1.value) &"#
请大家帮我看看应该怎么写,最好可以给我解释下!
但是总是提示日期格式错误.语句:select * from tb_out where [shijian]=#"& (DTP1.value) &"#
请大家帮我看看应该怎么写,最好可以给我解释下!
"select * from tb_out where [shijian]='"& DTP1.value &"'"
'数据库为ACCESS:
"select * from tb_out where [shijian]=#"& DTP1.value &"#"
查询运算式'[shijian]=#"& dtp1.value &"#'中的日期语法错误
'数据库为SQL:
"select * from tb_out where [shijian]='"& format(DTP1.value,"yyyy-mm-dd") &"'"
'数据库为ACCESS:
"select * from tb_out where [shijian]=#"& format(DTP1.value,"yyyy-mm-dd") &"#"
'数据库为SQL:
"select * from tb_out where [shijian]='"& format(DTP1.value,"yyyy-mm-dd") &"'"
'数据库为ACCESS:
"select * from tb_out where [shijian]=#"& format(DTP1.value,"yyyy-mm-dd") &"#"
Adodc1.Refresh
Adodc1.RecordSource = "select * from tb_out where [shijian]=#" & DTP1.Value & "#"
建议楼主还是在代码中设置控件属性吧,不要直接在控件的属性窗体中设置值。
DTP1.value的当前值是多少呀?
在DPT1.CloseUp里面写最好
'在代码里写,不是它的右键属性里
Adodc1.Refresh
Adodc1.RecordSource = "select * from tb_out where [shijian]=#" & DTP1.Value & "#"