3.2w+
社区成员
- 主页
- 基础类
- 应用实例
- 新技术前沿
求助:不执行查询的问题
我在按钮的CLICK事件中加入如下代码.
dim str as string
str = "{table1.time}='" & DTPicker1.Value & "'"
and {table1.time}<'" & DTPicker2.Value & "'"
CrystalReport1.ReportFileName = "d:\table1.rpt"
CrystalReport1.SelectionFormula = str
CrystalReport1.Action = 1
结果报表中什么都不显示(也就是未执行查询)
数据库中time字段为DATATIME类型
不知道是什么原因,望解答
谢谢!
dim str as string
str = "{table1.time}='" & DTPicker1.Value & "'"
and {table1.time}<'" & DTPicker2.Value & "'"
CrystalReport1.ReportFileName = "d:\table1.rpt"
CrystalReport1.SelectionFormula = str
CrystalReport1.Action = 1
结果报表中什么都不显示(也就是未执行查询)
数据库中time字段为DATATIME类型
不知道是什么原因,望解答
谢谢!
...全文
请发表友善的回复…
发表回复
bluesky1980 2003-12-15
zjcxc(邹建) :
运行程序后报错 error in formula <record_selection>
str = "datediff(day,{table1.time},'2003-12-1')<0
and datediff(day,{table1.time},'2003-12-4'>0"
the remaining text does not appear to be part of the formula
tiger201(你是风儿我是沙，编程不如种地瓜。) :即使同为DATATIME类型也会因为显示格式不同而无法查询到数据。如果出现你说的这种情况该如何解决
运行程序后报错 error in formula <record_selection>
str = "datediff(day,{table1.time},'2003-12-1')<0
and datediff(day,{table1.time},'2003-12-4'>0"
the remaining text does not appear to be part of the formula
tiger201(你是风儿我是沙，编程不如种地瓜。) :即使同为DATATIME类型也会因为显示格式不同而无法查询到数据。如果出现你说的这种情况该如何解决
tiger201 2003-12-15
将DTPicker1.Value,DTPicker2.Value转换成table1.time一致的数据格式。
即使同为DATATIME类型也会因为显示格式不同而无法查询到数据。
即使同为DATATIME类型也会因为显示格式不同而无法查询到数据。
zjcxc--个人微信公共号同名 2003-12-15
试试：
dim str as string
str = "datediff(day,{table1.time},'" & DTPicker1.Value & "')=0"
and datediff(day,{table1.time},'" & DTPicker2.Value & "')>0"
CrystalReport1.ReportFileName = "d:\table1.rpt"
CrystalReport1.SelectionFormula = str
CrystalReport1.Action = 1
dim str as string
str = "datediff(day,{table1.time},'" & DTPicker1.Value & "')=0"
and datediff(day,{table1.time},'" & DTPicker2.Value & "')>0"
CrystalReport1.ReportFileName = "d:\table1.rpt"
CrystalReport1.SelectionFormula = str
CrystalReport1.Action = 1
bluesky1980 2003-12-15
tonnyhe(快乐编程) : 我的贴子笔误：）应该是”大于号“
但程序还是不执行报表数据项显示为空
但程序还是不执行报表数据项显示为空
tonnyhe 2003-12-15
str = "{table1.time}='" & DTPicker1.Value & "'"
and {table1.time}<'" & DTPicker2.Value & "'"
此句有错，应该是
str = "{table1.time}>'" & DTPicker1.Value & "'
and {table1.time}<'" & DTPicker2.Value & "'"
and {table1.time}<'" & DTPicker2.Value & "'"
此句有错，应该是
str = "{table1.time}>'" & DTPicker1.Value & "'
and {table1.time}<'" & DTPicker2.Value & "'"
bluesky1980 2003-12-15
问题已解决
我用的是这个
"'" & Year(DTPicker1.Value) & " /" & Month(DTPicker1.Value) & " / " & Day(DTPicker1.Value) & "'"
谢谢大家
我用的是这个
"'" & Year(DTPicker1.Value) & " /" & Month(DTPicker1.Value) & " / " & Day(DTPicker1.Value) & "'"
谢谢大家