MapForums

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

I think that there is no way to modify a dataset. You'll have to import oder link the data with the functions. The dataset will be created with the fields you choose. Perhaps if you made a text file or excel file and import that one.

I'd like to modify a dataset like you want. It would make my problems with mappoint easier too