Board index » cppbuilder » Is there a way to get my XML data in a database approuce so i can use SQL querys to retrive data from the XML file?
Jochanan
CBuilder Developer |
Is there a way to get my XML data in a database approuce so i can use SQL querys to retrive data from the XML file?2005-07-29 03:55:40 PM cppbuilder11 Hi , First of all thanks for the information I would like to use the ClientDataSet. I thikt it can solve a great deal of my problems. I ran into some problems using this road so maybe I should explain more of the point that i reached and the things I want to atchive. I'm using the Databynding tool to create a XML converter for me at on place in a application. The whole structure there is data in memory with objects. now i want to get the data in a database or use that XML File like a database. I dont use standard MSXML. I can get my XML into an TXMLDocument But to change that to a ClientDataSetFormat I need to have transformation file. To acheve that I have to use the XMLMapper.exe I load the xsd schemafile to get the job done. I want to use some queries on my data set. I have a list of salesman that is a repeating list of a single salesman one of his attributes is ratings but also a list of top 10 sales with the values attached to that data. to get this information like selelcting the best 5 top 10 sales for all my salesman. that are the things I want to retreave from my XML Doument. but i cant get more than i have a list of salesman. when i try to look into the list I get some information but some is missing (the first column is only filled for the firts salesman the rest are all empty. when i try to select * from salesman it gives me nothing different than when showing the data in the first place like keynr Salesman 68 [DATA SET][...] when I Klik on the [dataset] I get the list of sales man but only the first one has an Id. then all othere list are [DATA SET] again. on kliking i get the next data that works only to steps deep. and I want to get the data in a different way. I want to sum the items 4 layers deep in the XML but it is 4 layers deep for each item and i want to sum it over the items. like in the exemple of the salesman. Regards Jvdn "Damon Chandler (TeamB)" < XXXX@XXXXX.COM > schreef in bericht news:42e1d375$ XXXX@XXXXX.COM ... QuoteHi Jochanan, |