Paradox Community

Items in pnews.paradox-programming

Subject:Re: Importing XML files using ODBC
Date:Mon, 7 Aug 2017 12:00:42 -0700
From:Jim Hargan <jim@harganonline.com>
Newsgroups:pnews.paradox-programming
On 8/5/2017 5:54 AM, Ian Espie wrote:
> I do not understand why data from any source is exported to XML - what 
> is the advantage of this?

1. XML is human readable, and can be opened in Notepad. An XML file is 
plain text, with each datum surrounded by markup that looks like html 
markup.

2. If you can't find an existing XML standard that meets your needs, you 
can create your own.

3. XML allows 1:M relationships.

4. You can mix several standards into one XML file. In fact, you can 
nest data from one standard inside data from another standard.

5. You can use *any standard at all* (at least in theory). Every 
standard is (supposed to be) published to a publicly accessible web 
directory, and your xml parser will go to that directory and read its 
standard.

Example (pseudo-code):
Where dc and rdf are shorthands for two different sets of standards, one 
from w3.org and the other from purl.org:
<dc:subject>
    <rdf:bag>Keywords
       <rdf:li>Pioneer</rdf:li>
       <rdf:li>19th Century History</rdf:li>
    </rdf:bag>
    <rdf:bag>Location
       <rdf:li>Powell County</rdf:li>
       <rdf:li>Montana</rdf:li>
    </rdf:bag>
</dc.subject>
Examine this and you can see that it's 1:M:M, with rdf:li inside rdf:bag 
inside dc:subject. (This is based on Adobe's xml standard.)

---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus


Copyright © 2004 thedbcommunity.com