Anonymous
09-10-2003, 01:31 PM
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
:)
-------------------------
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
:)