+ -
当前位置:首页 → 问答吧 → 数据库问题

数据库问题

时间:2011-11-30

来源:互联网

VB code

 Do While Not rs.EOF
                    rs.Fields() '----Property access must assign to the property or use its value. ERROR
                    '----Fields("cardno")
                    rs.MoveNext()
                    strSQL2 = "Select cardno, jine from daoruwenjian1 where cardno=rs(cardno)"
                    QueryData(strSQL2)
                    rs2.RecordCount()'----Property access must assign to the property or use its value. ERROR



我只截取一段代码,求达人解惑,本人对VB不熟悉

作者: ppgs8903   发布时间: 2011-11-30

2个注解就是ERROR处
Property access must assign to the property or use its value. ERROR
 '----Fields("cardno") 那个里面有值,我没写上去

作者: ppgs8903   发布时间: 2011-11-30

Do While Not rs.EOF
  msgbox rs.Fields("cardno")
  rs.MoveNext()
  strSQL2 = "Select cardno, jine from daoruwenjian1 where cardno='" & rs("cardno") & "'"
  QueryData(strSQL2)
  msgbox rs2.RecordCount



作者: CityBird   发布时间: 2011-11-30

引用 2 楼 citybird 的回复:
Do While Not rs.EOF
msgbox rs.Fields("cardno")
rs.MoveNext()
strSQL2 = "Select cardno, jine from daoruwenjian1 where cardno='" & rs("cardno") & "'"
QueryData(strSQL2)
msgbox rs2……

问题在于不过是个error

作者: ppgs8903   发布时间: 2011-11-30

热门下载

更多