VB and XML Update issue

[gmarrufo]

Greetings,

Here is my situation:

I have a VB app that reads a SQL DB table. Inside this table there is a field "bat_yes" which is a text field. The field in question contains an XML file (with all the nodes, tags and values).

The VB app reads the field and is able to load the XML element using:

Set oXMLInput = New DOMDocument30 'CreateObject "Msxml2.DOMDocument&quot
oXMLInput.async = False
oXMLInput.validateOnParse = False
oXMLInput.preserveWhiteSpace = True
oXMLInput.resolveExternals = False

If rsset.EOF = True Then
lblTitle.Caption = "There are no records in table"
Else
While Not rsset.EOF
oXMLInput.loadXML (rsset.Fields("Bat_Yes&quot)

at this point I can see the elements of the XML, my problem is that I need to update not only the value displayed in some of the XML tags but the field in the table as well as I iterate thru the records.

I hope I was clear enough with this problem.

Any help would be greatly appreciated.

thanks,

G