Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to work with XML and n-tiers
Message
From
01/11/2005 16:51:24
 
 
General information
Forum:
Visual FoxPro
Category:
XML, XSD
Environment versions
Visual FoxPro:
VFP 9
Miscellaneous
Thread ID:
01064133
Message ID:
01064230
Views:
24
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.
David Stevenson, MCSD, 2-time VFP MVP / St. Petersburg, FL USA / david@topstrategies.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform