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 19:20:20
 
 
To
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:
01064303
Views:
30
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.
Apoya a Visual FoxPro usandolo legalmente
--
¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º
Espartaco Palma Martínez
SysOp PortalFox
http://www.portalfox.com
esparta@portalfox.com
Previous
Reply
Map
View

Click here to load this message in the networking platform