beas form design using Powerbuilder
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
-
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 -
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.
-
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
-
Hi Phil,
very nice. I know, it take time to find out how this is working first time and without help..
regards
Martin
Please sign in to leave a comment.
Comments
4 comments