Updating recordset in VB6
<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>