您的位置：程序门 -> vb -> 数据库（包含打印，安装，报表)

为什么总出现 method "open" of object"_recordset" failed的问题啊，请指教！

[收藏此页] [打印本页]选择字色：背景色：字体：[大][中][小]

为什么总出现 method 'open' of object'_recordset' failed的问题啊，请指教！[已结贴,结贴人:zyz1942]

发表于：2007-03-09 11:23:34 楼主

private sub ado_openrecordsets（)
'++ open the two recordsets
on error goto errorhandler
dim tmp_rs as adodb.recordset
set tmp_rs = new adodb.recordset
tmp_rs.open "select * from " & text2.text, padocon, adopenforwardonly, adlockreadonly

attsqlstr = getattrflds（tmp_rs)
tmp_rs.close
set tmp_rs = nothing
set padors_att = new adodb.recordset
set padors_geom = new adodb.recordset

'++ open a new geometry-only recordset
padors_geom.open "select " & sspatialgeomcolnameparam & " from " & text2.text, padocon, adopenforwardonly, adlockreadonly
'++ open a new attribute-only recordset
padors_att.open "select " & attsqlstr & " from " & text2.text, padocon, adopenforwardonly, adlockoptimistic
exit sub

发表于：2007-03-09 14:07:211楼得分:20

发现你是这样写的,
tmp_rs.open "select * from " & text2.text, padocon, adopenforwardonly, adlockreadonly
不知道是你失误写错,还是......
试一下这样
tmp_rs.open "select * from " & text2.text & " ", padocon, adopenforwardonly, adlockreadonly

下一篇：vb+winsock访问远程数据库问题
上一篇：有哪位用vb做过测温系统，关于温度的保存

其他资讯