title: multiple-step operation generated errors. check each status value
body: <p>I have two recordset which want to update one of them by value of the other. I did like this</p>
  
  <pre><code> stSql = "SELECT dbo.tblCableProperty.CatalogCode FROM  dbo.tblCable INNER JOIN " &amp; _
  "  dbo.tblCableProperty ON dbo.tblCable.CablePcode = dbo.tblCableProperty.CablePcode" &amp; _
  " WHERE dbo.tblCable.prjsubcode=" &amp; prjsubcode &amp; " AND dbo.tblCable.Active=1 " &amp; " And dbo.tblCable.Gtag='" &amp; Gtag &amp; "' And dbo.tblCable.TagNo=" &amp; tagno &amp; " And dbo.tblCable.NTag=" &amp; NTag &amp; " And dbo.tblCable.EndStr='" &amp; EndStr &amp; "'"
  rs.Open stSql, cn, adOpenStatic, adLockOptimistic
  catalogCode = rs!catalogCode
  rs.Close
  
  stSql = "SELECT *,'' as ShowNum FROM viwShowNum WHERE prjsubcode=" &amp; prjsubcode &amp; " AND Active=1 " &amp; " And Gtag='" &amp; Gtag &amp; "' And TagNo=" &amp; tagno &amp; " And NTag=" &amp; NTag &amp; " And EndStr='" &amp; EndStr &amp; "' ORDER BY 8"
  rs.Open stSql, cn, adOpenDynamic, adLockOptimistic
  rs.MoveFirst
  
  stSql = "Select * from tblCoreCode where CatalogCode=" &amp; catalogCode
  Set rsCoreCode = New ADODB.Recordset
  rsCoreCode.CursorLocation = adUseClient
  rsCoreCode.Open stSql, cn, adOpenStatic, adLockOptimistic
  
  While Not rs.EOF
  criteria = "RealNum='" &amp; rs!CoreNo &amp; "'"
  rsCoreCode.Filter = criteria
  
  rs!ShowNum = CStr(rsCoreCode!ShowNum)
  rsCoreCode.Filter = adFilterNone
  rs.MoveNext
  Wend
  </code></pre>
  
  <p>I get the following error on this part</p>
  
  <pre><code> rs!ShowNum = CStr(rsCoreCode!ShowNum)
  
   multiple-step operation generated errors. check each status value
  </code></pre>
  
  <p>rsCoreCode!ShowNum is varchar(5). I tried to set the value </p>
  
  <pre><code> rs!ShowNum = "1" 
  </code></pre>
  
  <p>but again I got the same error.
  where is the problem?</p>
  
  <p>Thank you</p>