Hello,

I have been trying to write a front end for an SQL Server (Ver. 6)
database using Visual Basic 4 Enterprise edition.  I first create a
Result Set with a Dynamic Cursor (I have also tried a Keyset Cursor).
I am able to scroll through the rows of the Result Set but when I
attempt to up date the rows I get an error stating that the cursor is
read only.  The attributes property for all columns is 33 or greater,
the value of the resultsetype property is 3, and I have full
permissions on the database table.  The code that I am using to update
the table is as follows:

myRs.Edit
myRs(:dorasite") = Text1.text
myRs.Update

The error occurs on the myRS.Update command.
The ResuyltSet is created with the command:

Set myRs = MyPs.OpenResultSet(rdOpenDynamic, rdConcurValues)

The SQL statement being passed is:

"select * from test"

Everything that I can find indicates that this should work.  Any
suggestions?

Thanks in advance,
Jezzer