title: Edit records in ADODB recordset
body: <p>What I am trying to do is to get some data from an online server through an SQL Query and then loop through the recordset modifying the records.</p>
  
  <p>I get an error when trying to modify the recordset:</p>
  
  <p>"Multiple-Step operation generated errors. Check each status value."</p>
  
  <p>My question is: <strong>Is there a way of modifying a record from a recordset that I got from a Query?</strong></p>
  
  <p>In this case I am modifying field 2 if field 1 meets a certain criteria. (In this case Field 2 is a string)</p>
  
  <p>Here is the simplified code:</p>
  
  <pre><code>Dim adoConn As ADODB.Connection
  Dim locRS As New ADODB.Recordset, proRS As ADODB.Recordset
  Dim strConnection As String
  
  Set getSQL = New ADODB.Recordset
  
  
  'Set Objects
  Set adoConn = New ADODB.Connection
  
  'Specify connection string
  strConnection = "User ID=xxx; Password=xxx;Data Source=xxx;Provider=OraOLEDB.Oracle"
  
  'Open the connection
  adoConn.Open (strConnection)
  
  'Set up recordset properties
  getSQL.CursorType = adOpenStatic
  getSQL.CursorLocation = adUseClient
  getSQL.LockType = adLockBatchOptimistic
  
  'Import the data
  getSQL.Open "SELECT FIELD1, FIELD2 FROM TABLE", adoConn, adOpenStatic, adLockOptimistic
  Set getSQL.ActiveConnection = Nothing
  getSql.Update
  
  
  'Loop through data
  getSQL.MoveFirst
  Do While Not stockRS.EOF
  'If cetrain condition is met then modify the null column
  if getSQL!FIELD1=CRITERIA then
  'Error here
  getSQL!FIELD2="SOME STRING"
  End If
  getSQL.MoveNext
  Loop
  
  'Close
  adoConn.Close
  Set adoConn = Nothing
  </code></pre>