View Single Post

  #1 (permalink)  
Old 09-10-2003
Anonymous Anonymous is offline
Senior Member
Black Belt
 
Join Date: Jul 2002
Posts: 5,138
DataSet Modifications ?

How do I modify the value of a dataset ?

-------------------------
Set objRS = g_oDS.QueryAllRecords

objRS.MoveFirst

col = 1
row = 2

'Write the column contents
Do Until objRS.EOF
For Each objField In objRS.Fields
If xsheet.Cells(row, col).Value <> CStr(objField.Value) Then
=====>BOMBS HERE======>
Set objField = xsheet.Cells(row, col).Value
=====================>
End If
col = col + 1
Next objField
row = row + 1
col = 1
objRS.MoveNext
Loop

I realized that its a read only property. Is there any other way, we can modify the dataset ???

Thanks
Reply With Quote