Perform query on TClientDataset

[marflo500]

Hello All,

I was wondering if it would be possible to perform a query on one or more TClientDatasets. For example, if I have two ClientDatasets: one loads the customers.xml file and the other loads data from the sales.xml file - how do I go about making a query to give me all the customers and their respective sales from the two ClientDatasets. Normally if I was programming a two-tier app I would just drop a TADOQuery component on the form, connect it and write the necessary SQL but I am not quite sure how this is accomplished with a three tier model and ClientDataSets.

Any help would be appreciated.

Thanks
Liam

 

[lespaul]

I think you might be better off using components for the xml documents and xPath to query the xml (xPath is to XML what SQL is to database tables).

Here's an article that I found, I'm sure there's a part one that will explain the basics.

http://www.skch.net/columns/xml_delphi2.html

I've just recently been introduced to xPath and XML and will be implementing it in Java and webpages, but I assumed there had to be dephi components that would process it as well, so I can't be any more specific on what you need to do.

Good Luck!

Leslie

Have you met Hardy Heron?

 

[roo0047]

Simply put, set the relationship for table3 to table2, just like you did for table2 to table1.

Roo
Delphi Rules!

 

[marflo500]

Thanks for the responses guys but Roo what you proposed is very unclear - care to explain yourself a bit further?

Liam

 

[roo0047]

Normally if I was programming a two-tier app...

My reply assumed you already had this part working

Roo
Delphi Rules!

 

[DjangMan]

You can try tracking down txQuery. It is a query component that will allow you to query different TDataset decendants. Very cool. I bought it last year so you should be able to still get it even though it isn't being developed anymore (AFAIK).

 

[JES1904]

Try this wwebsite:

http://delphi.about.com/od/usedbvcl/a/tclientdataset.htm

It links a group of articles by Cary Jensen that cover a great deal of ClientDataSets including exaple source code.

 

[marflo500]

Thank you for the help guys.

Liam