title: Updating recordset in VB6
body: <p>Quick question, new to this site, new to programming especially. </p>
  
  <p>I'm trying to Select data from SqlServer and then update it while it's still a recordset. I don't want to update the actual table with the data....
  So if I have a field called RS!("FirstName") and I want to add a string to it, for example "MR"</p>
  
  <p>This is how I go about it</p>
  
  <pre><code>str = "Select FirstName from tblClient"
  rs.Open SQL, g_cn, adOpenStatic
  
  rs.movefirst
  do while not rs.eof 
      rs("FirstName") = "MR" &amp; rs("FirstName") &lt;--- this is what i'm trying to do but it tells me I cannot update it. 
      rs.movenext
  loop
  </code></pre>
  
  <p>How to fix this</p>