vb+ms sql+crystal reports4.6怎样刷新sql语句数据呢query = "select * from dip where a=1 and b=5"
Report1.ReportFileName = "D:\222\图片\dip.rpt"
Report1.Connect = "DSN = tdqd;UID = sa;PWD =;DSQ = Administration"Report1.SQLQuery = query
Report1.Formulas(0) = "mm='" & Format(Date, "yyyy-MM-dd ") & Format(Time, "hh:mm") & "'"
With Report1
.WindowState = crptNormal
.WindowLeft = 0
.WindowTop = 50
.WindowWidth = 1500
.WindowHeight = 500
.Action = 5
End With写了以上数据结果还是什么也没有,只页眉!请大家指教,写出代码!
Report1.ReportFileName = "D:\222\图片\dip.rpt"
Report1.Connect = "DSN = tdqd;UID = sa;PWD =;DSQ = Administration"Report1.SQLQuery = query
Report1.Formulas(0) = "mm='" & Format(Date, "yyyy-MM-dd ") & Format(Time, "hh:mm") & "'"
With Report1
.WindowState = crptNormal
.WindowLeft = 0
.WindowTop = 50
.WindowWidth = 1500
.WindowHeight = 500
.Action = 5
End With写了以上数据结果还是什么也没有,只页眉!请大家指教,写出代码!
解决方案 »
- 为什么这句GetValue = Left$(resString, length - 1)总是提示错误"无效的过程调用或参数"
- 修改文件属性的问题
- 请教几个vb的问题,在线等,谢谢啦!
- VB最新排名
- 关于CommandDialog1打开文件目录的问题
- 如何合并两个dbf库中的记录到一个文件中?
- 请教使用SetupFactory的问题,问题祥见里面,在线等,非常感谢
- 打包讨论!欢迎vb高手发言!
- 请问在Vb中如何查看已经添加了那些引用?
- win2000下能屏蔽alt+ctrl+del吗?
- 如何获取文本文件中某一列的值,如下格式的txt文件,
- ChooseFont问题 怎么设定打开字体对话框默认的字体大小,默认选中-小五
DSQ = Administration代表什么
2、在with块中增加.DiscardSavedData = True
3、DSQ = Administration我没用过(这句可以去除)
4、先试一下select * from dip where a=1 and b=5 是否肯定有数据查到