Reading XML, updating tables in SQL Server
Posted on 2004-09-21
I want urgent help with VB6 code.
Heres the scenario:
I have an application. From application API I can define an interface to my VB DLL (for example: myDLL.myClass.myfunction)
From my application, I can select table and its columns to be used by myDLL
The data is exchanged in XML format.
I want to read this XML file/data into my function - Public Function myFunction(sXML As String) As Variant
- reads XML file for tablename, column ID and corresponding column data - i.e
- connect to SQL Server7.0
- deletes the existing data in table in SQL Server using column ID info from XML
- then updates same table with new data read from XML file
I have installed MSXML4.0
I need your help to create DLL, register and compile it
I am willing to start a new thread as and when required so that expert who is helping me gets as many point as possible!