title: Recordset in VB6.0
body: <p>I'm retrieving Data from a Database in a <em>record set</em> using VB6... so while retrieving data using Select in SQL I added a column called <strong>Comments</strong> along wit it so that in the recordset, all the columns of the table+'Comments' column would be present... I don't want to(and also <em>I cannot</em>) update any contents in the database as i'm only 'fetching' data frm the database now...</p>
  
  <p>Now when i pass the fetched data for validation, I want to fill the 'comments' Column with the respective errors if the particular row in the recordSet is erroneous).... When i do that i get an error saying "I'm not authorized to do that!!(to update the 'Comments' Column"....</p>
  
  <p>Now My Question is "In what way i can solve this problem???".. I tried to replicate this recordset and there by now filling the 'comments'column (in the replicated one) which in turn showed the same error... It seems this could be because the duplicate one(recordSet) just retains the properties of the original one...</p>
  
  <p>Can u any1 help how to solve this???? Any ways to replicate the recordset(without inheriting its properties something)?????? </p>