Dynamically create datawindow/datastore from xml

[#1]

Is it possible to dynamically create a datawindow or datastore from a xml string, much like the .SyntaxFromSQL /.Create combination?

For example, I would like a "fleet"-datastore, where the "cars" are the rows, and "id", "color" and "make" are the columns.

<fleet>
  <car>
  <id>1234</id>
  <color>red</color>
  <make>Toyota</make>
  </car>
  <car>
  <id>5678</id>
  <color>blue</color>
  <make>Opel</make>
  </car>
</fleet>

I'm using PB12.5.2.5703. (Classic)

[Former Member · Accepted solution]

Hi Erik;

1) No.   FWIW: I think that being able to create a DWO from XML feature would be awesome.

2) You can create a DWO of course from not only SQL but also an ANSI result set (have a look at the CreateFrom method).

Option#1

So, what you could do (in a round about way) in the case of #2.

a) Pass a 1 row ANSI Result Set

b) Build a DWO from  (a) using the CreateFrom ( ) method

c) Pass the XML

d) Import the XML into the DWO as build in step (b)

Option#2 - same as #1 but pass in an SQL statement.

Option#3 - Build your own XML => SQL generator.

Regards ... Chris

[Former Member · Accepted solution]

Thank you Chris, much appreciated. I will take the given options into consideration.