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)

[CobyKako]

Hello Erik,

Please find below an example from old Sybase CodeXchange web site that we are being migrated to the SAP wiki page sooner or later:

SAP Mobile Documents

HTH,

Jacob

[Former Member]

Thanks Jacob! I came across the mention of such example earlier, but could not find the "new CodeXchange".

With this, and the reply from Chris, I think I can manage.

Thanks a lot guys!

[Former Member]

Maybe since SAP has placed PowerBuilder under Mobile in it's management structure, it should consider bringing back PocketBuilder and give it the ability to deploy to Android, iOS and Windows Mobile devices. Also, it should not be restricted to use only SQL Anywhere. It should be able to use whatever DBMS is most common on the platform.

[Former Member]

Wow - An XML question that gives us a PocketBuilder flashback ... interesting (but off topic) <bg>!