5652.html
来自「VB技巧问答10000例 VB技巧问答10000例」· HTML 代码 · 共 30 行
HTML
30 行
<html>
<head>
<title>Rdo access local machine database,errors:The resultset type is read_only,who help me?</title>
</head>
<body bgcolor="#FFFFFF" vlink="#808080">
<center>
<h1>Rdo access local machine database,errors:The resultset type is read_only,who help me?</h1>
</center>
<hr size=7 width=75%>
<hr size=7 width=75%><p>
Posted by <a href="mailto:ylj@zhuhaiinfo.net">yuan</a> on September 15, 1998 at 13:18:20:<p>
I use vb6 enterprise edition on system win95<br>on control panel,32bitodbc:<br>system dsn:yuan1<br>advanced:read_only=0<br>but always errors:run-time errors "40058"<br>the resulttype is read_only<br>I use DAo ways can sucess.<p>program code as follows:<br>Private Sub Form_Load()<br>Dim db As rdoconnection<br>Dim rs As rdoresultset<br>Dim ssql As String<br>Set db = rdoengine.rdoenvironments(0).OpenConnection("yuan1")<br>ssql = "select * from branch"<br>Set rs = db.openresultset(ssql, rdopenkeyset)<br>rs.movefirst<br>rs.edit<br>rs![branch_address] = "6"<br>rs.Update<br>While Not rs.EOF<br>Debug.Print rs.rdocolumns(0)<br> rs.movenext<br> Wend<br> rs.Close<br> db.Close<br>End Sub<p>i don't know why? who can help me?
<br>
<br><hr size=7 width=75%><p>
<a name="followups">Follow Ups:</a><br>
<ul><!--insert: 5652-->
<!--top: 5654--><li><a href="5654.html">Re: Rdo access local machine database,errors:The resultset type is read_only,who help me?</a> <b>AndyLin</b> <i>13:45:35 9/15/98</i>
(<!--responses: 5654-->1)
<ul><!--insert: 5654-->
<!--top: 5657--><li><a href="5657.html">Sir,thank you very much,I have debug sucess</a> <b>yuan</b> <i>14:02:15 9/15/98</i>
(<!--responses: 5657-->0)
<ul><!--insert: 5657-->
</ul><!--end: 5657-->
</ul><!--end: 5654-->
</ul><!--end: 5652-->
<br><hr size=7 width=75%><p>
</body></html>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?