beas form design using Powerbuilder

Phil Sparkes

• 28 de enero de 2022 15:55

Hi,

I'm designing a new form of type datagrid using Powerbuilder, as per the tutorial in the beas help (very useful). I've created a view and have used a select query to get the records. My problem is that in this form the column sizes extend into the header section of the form, and i want it to be different (like the F2 screen from the pool report). On my earlier attempts my columns didn't extend into the header - any idea what I'm doing wrong?

Thanks - Happy Friday

Vote

0

• 

  Martin Heigl

  • 28 de enero de 2022 16:49
  • Editado

  Hi Phil,

  thank you for the positive words. We do our best to make the documentation better.

  To the pool report: This is a very old report. As we created it, it was not possible to define additional Datawindow (dw_2...dw_7) in one window

  Please don't copy this concept
  Better concept:
  Create second psr file and initialize this with dw_2, dw_3 and so on.
  
  Example using dw_6:
  dw_6.init=mySecond.psr
  //  For List view
  //dw_6.setdynamicgridcols
  //dw_6.markierung=J
  dw_6.initcols
  //dw_6.design=liste
  dw_6.design=edit
  dw_6.retrieve=Parameter1=Parameter2...
  
  

  Note: in sub datawindows only string as arguments allowed.
  If no data, you can create external window and replace retrieve with
  dw_6.insertrow
  
  in 
  global function form_resize
  end global
  You can overwrite the resize and can define the position of the datawindows.
  with "max" you can define always: up to the end of the window x/y position.
  dw_6.width=max
  dw_6.height=max
  
  Please insert a print screen from you nice customizing. Always nice to see
• 

  Phil Sparkes

  • 3 de febrero de 2022 08:02

  Hi Martin,

  Thanks for the reply - but for me a lot is not clear. I'm working in the Appeon Powerbuilder designer - am I still only able to create a Grid type datawindow for input to beas? Am I correct that we cannot use any other Powerbuilder window type? In Appeon Powerbuilder, a datagrid window only allows me to define a single datasource. The screen I'm trying to replicate is the F2 screen fert_afo_anmelden - but every time I add a datasource to my grid the column sizes extend into the header of the form - I'm unable to get rid of them - I need to solve that problem. I don't need two datasources for now. Do you know how the fert_afo_anmelden screen has a datagrid with no column sizes in the header? Thanks for the information.
• 

  Phil Sparkes

  • 23 de febrero de 2022 10:26

  Hi Martin,

  Thanks - with your advice and a lot of work here is how I added another set of data to my form.

  In Powerbuilder I created a new datagrid and linked it to my new datasource (and query). I saved that as a report file (.psr). I was never able to pull in the report into my form in Powerbuilder so I did it with this code (added some comments if you want to use the code you'll need to take them out). The form it produces is shown below!

  
      dw_6.init=processreport-2.psr   --- Load the report file
      dw_6.Border=true   ---- give it a border
      dw_6.Bordertype=1   ---- of type 1
      dw_6.setdynamicgridcols
      dw_6.markierung=J
      dw_6.initcols
      dw_6.design=liste
      dw_6.vscrollbar=true    ---- I want a scroll 
      dw_6.verticalscroll=true
      dw_6.retrieve         ----- go get the data
      dw_6.setfilter=u_itemcode="<myitem>"   ----- change the filter to get only the records i want
      dw_6.filter       ---- apply the filter
  
      dw_6.width=6600     ----- get the position right - this is absolute and doesn't scale if the user resizes
      dw_6.height=400
      dw_6.x=200
      dw_6.y=1800
      dw_6.visible=true    ------ display the extra data

  
• 

  Martin Heigl

  • 23 de febrero de 2022 13:19

  Hi Phil,

  very nice. I know, it take time to find out how this is working first time and without help..

  regards 

  Martin

Iniciar sesión para dejar un comentario.