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

Resolved Fixed DATA in a DW how to Describe and Modify ?

  1. How-to
0
Votes
Undo
  1. Miguel Leeuwe
    Miguel Leeuwe
  2. PowerBuilder
  3. Tuesday, 10 March 2020 12:02 PM UTC

Hi,

I have this datawindow

with 4 "fixed data rows".

Does anyone know if there's a way to manipulate these fixed rows with Modiy() or Describe()?

I want to allow a user to create a sort of a template and drag field-names on columns in a datawindow and after that save that "normal" row as a "fixed" row. That way, if I export the syntax of the dw and store it in a DB, I don't need to store also the fieldnames seperately in some table.

I know I can just do a describe of the datawindow syntax and then search for any existing "Data( ...." and add my rows to it (values separated by commas !) but modify and describe would make much more sense.

 

Cheers

MiguelL

Postgres and asynchronous retrieve
Debug with Visual Studio and PowerBuilder for C# c...
Responses (3)
Miguel Leeuwe
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Tuesday, 10 March 2020 15:45 PM UTC
  2. PowerBuilder
  3. # 1

I'll use GEt- and SetFullstate(), that way I also avoid having to store the fieldnames in column separately.

Thanks for your suggestions.

Comment
There are no comments made yet.
mike S
mike S Accepted Answer Pending Moderation
  1. Tuesday, 10 March 2020 12:40 PM UTC
  2. PowerBuilder
  3. # 2

just grab the entire datawindow definition and edit that.  

Comment
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Tuesday, 10 March 2020 12:47 PM UTC
Hi Mike,

Yes like I said "I know I can just do a describe of the datawindow syntax and then search for any existing "Data( ...." and add my rows to it (values separated by commas !) but modify and describe would make much more sense.", but I was wondering if there was a better way and thus avoinding having to use the Match() function to find "Data(....,....,....,..,)"

Thanks
  1. Helpful
There are no comments made yet.
René Ullrich
René Ullrich Accepted Answer Pending Moderation
  1. Tuesday, 10 March 2020 12:25 PM UTC
  2. PowerBuilder
  3. # 3

Hi Miguel,

I don't know a Describe syntax for that.

There is a Describe for "DataWindow.Syntax.Data". But it returns the current datawindow  data (not the data stored in syntax!) as a string that you may use to change the syntax.

Regards,

René

Comment
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Tuesday, 10 March 2020 12:30 PM UTC
Yes, I know, but not what I'm looking for as you already know.

thank you anyway.
  1. Helpful
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.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.