Adding data to table fiield one by one

[nval005]

XML I'm reading, (I can read it now, and store the value to a string variables)

I need a way to insert the data 1 by 1 to a row of a table.

ReferenceID: NXX-001
FirstName: Nelson
LastName: Smith
ReferenceID: NXX-002
FirstName: Johnny
LastName: Cash
ReferenceID: NXX-003
FirstName: James
LastName: Bond


above is whats in the memory, I will have a variable called strPointer, which will hold the value of each fields (ReferenceID/FirstName/LastName) , will read it from top to bottom order

so I grab hold of NXX-001 value, how do I then keep collecting the FIrstName and LastName values and INSERT UPDATE to a table .... is there a way to add the first as my pointer traverse thru this XML data above?

Thanks in advane guys!

 

[nval005]

got it! simple iterate the xml, collect the "insert into"

less complicated