I'm trying to mimic the .NET Adapter, please see the response I did to Craig. I was wondering how to pass I work with the Diffgram (or Updategram) to create the proper INSERT, UPDATE and DELETE statements to send it out with SPT.
>Don't use an updategram?
>Sounds like you need to throw in your own adapter, for the different backends. You can make this into a .Net component if that is your preference, as long as you keep using XML or something that you can pass around. (just not updategrams)
>>I've using XML to transport Visual FoxPro data between tiers in a COM+ DLL, it's pretty straigfull when you are using it to read the data.
>>
>>The new problem I've found is about how to send the update from the business tier to the data tier, with Visual FoxPro I can produce an XML Diffgram (trough XMLUpdategram() function or CursorAdapter class), but I'm finding problems to send this kind of XML when I prettend to not use MS SQLServer.
>>
>>It will be cool if I could create a .NET Adapter (SQLAdapter, OLEDBAdapter, etc) we could update any kind of datasource, obviously the mayor work will be in How to move between the Diffgram elements (the before/after elements).
>>
>>My question is: How can I move between Items in a XMLDiffgram?