Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (3)

Resolved Datawindow syntax serializer / deserializer

  1. How-to
0
Votes
Undo
  1. Tomas Beran
    Tomas Beran
  2. PowerBuilder
  3. Friday, 8 September 2023 16:17 PM UTC

Hi

Is there a library which allows working with Datawindow syntax directly in more pleasant way than just concatenating strings? I'm wondering develop Currently DW Syntax JSON serializer / deserializer but first I'm looking for already done and tested solution.

Initially what I wanted to do was to change grouping inside a datawindow which is (according to my knowledge) impossible in standard way. So the idea was: Extract the syntax, modify the syntax, create new datawindow from the modified syntax, and then share data between the original and the new datawindow.

Code signing certificate on PB compilation
How to identify wath type of JSON
Responses (3)
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Friday, 8 September 2023 16:41 PM UTC
  2. PowerBuilder
  3. # 1

Hi Tomaz;

  Yes, this is entirely possible (with some scripting on your part of course). After that, the "sharing" can then be done as long as the new DWO and the original DWO have the exact same columns and order within each DWO. Then a RowsCopy or ShareData command should do the trick.  HTH

Regards ... Chris

Comment
There are no comments made yet.
Tomas Beran
Tomas Beran Accepted Answer Pending Moderation
  1. Friday, 8 September 2023 16:37 PM UTC
  2. PowerBuilder
  3. # 2

What version of PB are you using? 

- PB2022

Are you aware PB already has some built-in JSON functionality, such as JSON parser, generator

- Yes but currently I see unimportant what library, what language etc. Another option in my mind is parsing DW syntax through XSLT but having fully serialized DW would be nicer and more universal way.

DW import/export

- I don't see any way how to export DW syntax through DW import or export functions. Do you know it? I thought only data entries can be exported or imported.

 

Comment
There are no comments made yet.
Armeen Mazda @Appeon
Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Friday, 8 September 2023 16:26 PM UTC
  2. PowerBuilder
  3. # 3

What version of PB are you using?  Are you aware PB already has some built-in JSON functionality, such as JSON parser, generator, DW import/export JSON, etc.?

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.