Yes David, I was trying with the Cursor Adapter, but I was not able to get it complete, Do you think that with CA + XMLAdapter can be done? Do you have any sample?
The XMLTable.ApplyDiffgram could be a good approach, but I didn't found a easy way to work it out, considering that I will recibe only the Diffgram from my Biz tier (the tableschema, keyfields, Update*, Insert*, Delete* can be provided by the data tier) .
>Esparta,
>>In my data layer I was trying to get the elements of the Diffgram to create the proper SQL sentence (UPDATE, DELETE, INSERT), these Diffgram/Updategram will be send it by my Business Object:
>I have not been following this discussion closely, so I may not understand what you're trying to do, but have you considered this approach?: Use CursorAdapter to handle the creation and updating of an updatable cursor, which can then be updated from a diffgram by XMLAdapter's ApplyDiffgram method, followed by a tableupdate to send the changes through CursorAdapter to whatever backend you have set it up to handle.
>Because CursorAdapter can update just about any backend and XMLAdapter can apply a diffgram to any cursor, the combination of the two might meet your need. Of course, you could bypass CA and do the same thing with a SQL Passthrough cursor or Remote View, updating the cursor in either case by XMLAdapter.ApplyDiffgram, followed by a tableupdate call to send the changes through to the backend.