Cart
|
[XML-DEV Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] RE: Re: What Does SOAP/WS Do that A REST System Can't?
 Is there some legal requirement to keep a full fidelity copy of the document? If not, I can't see why you don't just generate the XML as needed from the database when export is needed. Most major database products have had SQL<->XML mapping functionality for years. -- PITHY WORDS OF WISDOM Experience is something you don't get until just after you need it. ________________________________ From: David Lyon [mailto:david.lyon@c...] Sent: Mon 4/4/2005 2:56 PM To: xml-dev@l... Subject: Re: Re: What Does SOAP/WS Do that A REST System Can't? On Mon, 4 Apr 2005 12:46 am, Ronald Bourret wrote: > Can you query the XML documents? From an accounting perspective you can, as the important fields from within the document are broken out to the sql database to enable such queries. ie: aged debtor analysis : select name, a_c, a_30, a_60, a_90 from trader where trading_relationship = "Customer" list of invoices : select document_type,document_reference, document_date,document_amount from trader_documents where document_type = "Invoice" etc... etc.... It makes it very simple to do the normal sort of accounting queries. Also makes it possible to use traditional rdms report writers to build reports. > If not -- for example, if they're > stored as BLOBs -- it seems this would make sense only if the only thing > you wanted to do with your accounting data is to ship it somewhere else. A copy of the entire document is stored in a text-memo field. It is designed so that the xml document can be shipped off as created to the Customer (xml Invoices) or Supplier (xml Purchase Orders). > Doesn't strike me as very likely... Sending xml purchase orders and invoices is becoming much more common.... it certainly does happen in the real world in increasing amounts... Best Regards David -- Computergrid : The ones with the most connections win. ----------------------------------------------------------------- The xml-dev list is sponsored by XML.org <http://www.xml.org>, an initiative of OASIS <http://www.oasis-open.org> The list archives are at http://lists.xml.org/archives/xml-dev/ To subscribe or unsubscribe from this list use the subscription manager: <http://www.oasis-open.org/mlmanage/index.php> 
|
PURCHASE STYLUS STUDIO ONLINE TODAY!Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced! 
Download The World's Best XML IDE!Accelerate XML development with our award-winning XML IDE - Download a free trial today! Subscribe in XML format
|
|||||||||
