# Sir,thank you very much,I have debug sucess

Posted by yuan on September 15, 1998 at 14:02:15:

In Reply to: 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:

: : 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: