🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.delphi.xml
Article #168

Re: XML query

#168
From: Bob Swart
Date: Thu, 24 Apr 2008 09:37
31 lines
2157 bytes
Hi RT,

> I have an xml with 400 records and its xsd file.  I have used the xml data 
> binding wizard and therefore have the interfaces.  

Why not use the XML Mapper to transform the XML document into a data 
packet that can be loaded into a TClientDataSet ??

> to filter by fields and then export the resulting dataset in various formats 
> selected fields, much like an sql statement through a visual mechanism.

You can use the filter property of a TClientDataSet to filter all you 
want ;-)

> As I am new to working with XML can anyone point me to a 
> dialog/component/unit that might implement a query mechanism like sql for an 
> xml file that contains a few hundred records?

See http://www.drbob42.com/examines/examin25.htm for an intro to the XML 
Mapper.

> RT

Groetjes,
           Bob Swart

-- 
Bob Swart Training & Consultancy (eBob42.com) Forever Loyal to Delphi
CodeGear Technology Partner -- CodeGear RAD Studio Reseller (BeNeLux)
Personal courseware + e-mail support http://www.ebob42.com/courseware
Blog: http://www.drbob42.com/blog - RSS: http://eBob42.com/weblog.xml
Technical Details
Message-ID: <481054EC.2070504@eBob42.com>
Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!feeder3.cambrium.nl!feeder1.cambrium.nl!feed.tweaknews.nl!193.141.40.68.MISMATCH!npeer.de.kpn-eurorings.net!npeer-ng2.kpn.DE!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail
References: <480faf4e@newsgroups.borland.com>

Show Full Headers
Complete Article Headers
X-Google-Thread: f5d9b,c8460eda612c293a
X-Google-Attributes: gidf5d9b,domainid0,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
Message-ID: <481054EC.2070504@eBob42.com>
Date: Thu, 24 Apr 2008 11:37:48 +0200
From: Bob Swart <Bob@eBob42.com>
Organization: Bob Swart Training & Consultancy (eBob42)
User-Agent: Thunderbird 2.0.0.12 (Windows/20080213)
MIME-Version: 1.0
Newsgroups: borland.public.delphi.xml
Subject: Re: XML query
References: <480faf4e@newsgroups.borland.com>
In-Reply-To: <480faf4e@newsgroups.borland.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 89.220.93.5
X-Trace: newsgroups.borland.com 1209029865 89.220.93.5 (24 Apr 2008 02:37:45 -0700)
Lines: 31
Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!feeder3.cambrium.nl!feeder1.cambrium.nl!feed.tweaknews.nl!193.141.40.68.MISMATCH!npeer.de.kpn-eurorings.net!npeer-ng2.kpn.DE!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail