7,763
社区成员
发帖
与我相关
我的任务
分享datareport问题
http://www.tytec.com.cn/web/ldrd/bbs/dispbbs.asp?boardID=3&ID=62
...全文
请发表友善的回复…
发表回复
wintergoes 2003-11-05
- 打赏
- 举报
我用的是access
海牛 2003-11-03
- 打赏
- 举报
rsResult.Open "Select * From Search where 图象名称 like '临西县%", connResult
wintergoes 2003-11-03
- 打赏
- 举报
Set connResult = New ADODB.Connection
connResult.Open "Provider=Microsoft.Jet.OLEDB.3.51;Persist Security Info=False;Data Source=" & App.Path & "\Data\Searches.mdb"
Set rsResult = New ADODB.Recordset
rsResult.Open "Select * From Search where 图象名称 like '临西县*", connResult
'rsResult.Open "Select * From Search", connResult
Set DRResult.DataSource = rsResult
Set rsResult = Nothing
Set connResult = Nothing
DRResult.Orientation = rptOrientLandscape
DRResult.Show
为什么里面有一个临西县表一的记录，用上面那个方法找不到那条记录啊！
connResult.Open "Provider=Microsoft.Jet.OLEDB.3.51;Persist Security Info=False;Data Source=" & App.Path & "\Data\Searches.mdb"
Set rsResult = New ADODB.Recordset
rsResult.Open "Select * From Search where 图象名称 like '临西县*", connResult
'rsResult.Open "Select * From Search", connResult
Set DRResult.DataSource = rsResult
Set rsResult = Nothing
Set connResult = Nothing
DRResult.Orientation = rptOrientLandscape
DRResult.Show
为什么里面有一个临西县表一的记录，用上面那个方法找不到那条记录啊！
