1. Shaila Panwar
  2. PowerBuilder
  3. Monday, 16 April 2018 05:48 AM

Can we create Data window dynamically from XML in PB17.

The XML can vary hence each time it could have deferent number of elements.

Please share any example if it can be done.

 

 

 

Alexander Strelkov Accepted Answer Pending Moderation
  1. Monday, 16 April 2018 07:37 AM
  2. PowerBuilder
  3. # 1
0
Votes
Undo

In our project we create all DataWindow objects dynamically. DW syntax is generated on the basis of data that stored in the meta database or in XML. You can see some example here.

Comment
SyntaxFromSQL is very slow and not productive for such task/s. You must generate dw syntax on your own. Extract syntax from some example datawindow, analyze it and write similarly. This process is time consumed, but result is worth it.

  1. Alexander Strelkov
  2. Monday, 16 April 2018 11:26 AM
Here is bare minimum External DW syntax:



release 12.5;

datawindow(color=1073741824 processing=1 )

header(height=80 color="536870912" )

summary(height=0 color="536870912" )

footer(height=0 color="536870912" )

detail(height=92 color="536870912" )

table(column=(type=char(10) name=column1 dbname="column1" )

 column=(type=char(10) name=column2 dbname="column2" )

 )

  1. Roland Smith
  2. Monday, 16 April 2018 13:17 PM
Thanks for the Syntax that can be taken from the Edit Source.



What I am looking for is how I would run through the XML to get the elements which can be added as columns in the datawindow dynamicaly.



 

  1. Shaila Panwar
  2. Tuesday, 17 April 2018 04:25 AM
There are no comments made yet.
René Ullrich Accepted Answer Pending Moderation
  1. Monday, 16 April 2018 07:09 AM
  2. PowerBuilder
  3. # 2
0
Votes
Undo

I don't know a direct way to do this in Powerbuilder.

You may try to use an ODBC XML driver to access the XML data like a database. So you can use the SyntaxFromSQL function to create a datawindow.

More difficult is to build the datawindow syntax yourself.

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.