# Re: Rdo access local machine database,errors:The resultset type is read_only,who help me?

Posted by AndyLin on September 15, 1998 at 13:45:35:

In Reply to: Rdo access local machine database,errors:The resultset type is read_only,who help me? posted by yuan on September 15, 1998 at 13:18:20:

: I use vb6 enterprise edition on system win95
: on control panel,32bitodbc:
: system dsn:yuan1
: advanced:read_only=0
: but always errors:run-time errors "40058"
: the resulttype is read_only
: I use DAo ways can sucess.

: program code as follows:
: Private Sub Form_Load()
: Dim db As rdoconnection
: Dim rs As rdoresultset
: Dim ssql As String
: Set db = rdoengine.rdoenvironments(0).OpenConnection("yuan1")
: ssql = "select * from branch"
: Set rs = db.openresultset(ssql, rdopenkeyset)
: rs.movefirst
: rs.edit
: rs![branch_address] = "6"
: rs.Update
: While Not rs.EOF
: Debug.Print rs.rdocolumns(0)
: rs.movenext
: Wend
: rs.Close
: db.Close
: End Sub

: i don't know why? who can help me?

when you open resultset,you must to set the locktype,beacuse the default locktype is "rdconcurreadonly",to try following:
: Set rs = db.openresultset(ssql, rdopenkeyset,rdConcurRowVer )

Follow Ups:

- Sir,thank you very much,I have debug sucess yuan 14:02:15 9/15/98 (0)