Manipulate data section with a xml database
I Would like put in data section the code, name, price and the valueX (when it exists)
In my example with my XML attached it would like display this report:
Code? ? ? ? ? Name? ? ? ? ? ? ? ? ? ? ? Price? ? ? ? ? ? ValueX
? ? ? ?
? ? ? ?
? ? ? ? ?
2134? ? ? ? ? ? banana? ? ? ? ? ? ? ? 1.12? ? ? ? ? ? ? 0.10? ? ? ? ? <-? ValueX? are? in? ICM00? that? always? be? sub-child? of? tag? others? (when? exists)
1544? ? ? ? ? ? chocolate? ? ? ? ? 2.12? ? ? ? ? ? ? 0.20? ? ? ? ? <-? ValueX? are? in? ICM10? that? always? be? sub-child? of? tag? others? (when? exists)
34? ? ? ? ? ? ? ? ? cake? ? ? ? ? ? ? ? ? ? ? ? 3.12? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? <-? ValueX? not? exist? so? it? put? nothing
I always want to display Code, Name, Price, ValueX, but ValueX not belong to table product of XML, but it always appear in "/root/det[@nItem='x']/others//ValueX"
I'm Using this XML, my example are attached
How can i do This ????
In my example with my XML attached it would like display this report:
Code? ? ? ? ? Name? ? ? ? ? ? ? ? ? ? ? Price? ? ? ? ? ? ValueX
? ? ? ?
? ? ? ?
? ? ? ? ?
2134? ? ? ? ? ? banana? ? ? ? ? ? ? ? 1.12? ? ? ? ? ? ? 0.10? ? ? ? ? <-? ValueX? are? in? ICM00? that? always? be? sub-child? of? tag? others? (when? exists)
1544? ? ? ? ? ? chocolate? ? ? ? ? 2.12? ? ? ? ? ? ? 0.20? ? ? ? ? <-? ValueX? are? in? ICM10? that? always? be? sub-child? of? tag? others? (when? exists)
34? ? ? ? ? ? ? ? ? cake? ? ? ? ? ? ? ? ? ? ? ? 3.12? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? <-? ValueX? not? exist? so? it? put? nothing
I always want to display Code, Name, Price, ValueX, but ValueX not belong to table product of XML, but it always appear in "/root/det[@nItem='x']/others//ValueX"
I'm Using this XML, my example are attached
How can i do This ????