Discussions tagged DataWindow
Hello,
With Powerbuilder 2022, we are unable to save any datawindow object with 'XML' as template in 'Data Export' tab of datawindow object properties. Once saved, closed and opened again, the 'Format to Configure' property is changed to 'PDF'.
In...
I have a datawindow with one group. The database column that the group is based on can have either letters or a blank. I need to get the group total of the rows that have a blank and make that total available to add to the other group totals that hav...
We've got resizing working for our mdi windows with datawindows on them, but the drop-down datawindows within the datawindows do not resize (the font is still quite small). Is there any way to get these to resize? Please see the screenshot uploaded b...
We’re using Desta’s PB2XLS Utility with Powerbuilder 2021 for Excel Save of Reports. We came across an issue where we are finding when a DW is having a Computed Expression with RichText Method, it is not getting evaluated and PB is just crashing. Co...
Thanks your support always. My Powerbuilder crashed after one datawindow failed to open, as it impacts all the datawindows in the IDE, and all the datawindow cannot open in the IDE since one failed, Can help me on that, as it happend many times in th...
Hello,
How do you guys make your grid datawindows more readable? I am not aware of any ways to define cell padding for datawindows, and cell content is placed very close to grid lines. As a result, if a right-aligned column is followed by a left-ali...
How can I change the background color of a data window header that is on a tab page in a theme?...
Hi
Our standard practice is to use views in datawindows for retrieval. This avoids putting complex SQL in datawindows. It also allows to change the view behind the scenes if we decide to use different tables in the view.
We have to specify the u...
Hi
I'm converting a Powerbuilder project to Powerserver. Some of the windows use SQLPreview to call stored procedures to update the database.
SQLPreview isn't supported by Powerserver, so I want to modify the datawindow dynamically to use the stor...
Me again!
Today when testing my app, I keep getting a popup asking for a retrieval argument for edit_user. That's not a field I would ever do a retrieval argument on. Not sure why PB is asking for a retrieval argument.
The window I'm opening has...
Hi all,
I was so excited about changing quite a few fields from EDIT style to RICHTEXT style. But I noticed today that the RICHTEXT edit style doesn't retrieve or display data entered into the database prior to changing the dw edit style to RICHTEX...
I'm changing the length of some database columns that are on a lot of reports to allow 40 instead of 20 characters. To avoid changing the portrait-mode tabular reports to landscape, I'm leaving the width of the report field the same, and changing bot...
Hello everyone,
I was wondering if it is possible to save a datawindow as an image? The SaveAsType-constant offers EMF!, but then we have to rely on another tool to create an image from the vector file.
We have created a datawindow with some busine...
Hi all,
I thought I'd play around with the RichText edit style on one of the fields in a datawindow. I don't want the toolbar to show up every time I click in that field. Rather, I'd like something like the CTRL+ALT+D (or some other shortcut) to po...
Hi all,
Another strange one. I've got a window with a dw on it, inherited from PFC u_dw. I've got code for the dw that has 3 user events. ue_cut_rows, ue_copy_rows, ue_paste_rows.
I can cut/copy rows, then paste rows, works fine. But, when I sav...
Hello, I need information about converting datawindows to C# Model.
In SnapDevelop starting from a datawindow created with PowerBuilder I am able to create the relative C# Model using the "Convert DataWindow to C# Model" function however I find what...
Hello, I have implemented an ASP .NET Core Web API project that uses datawindows created in PowerBuilder to read data.Following the tutorial I was able to easily create an API which, after converting the datawindow into a C# Model, reads the data fro...
Hello,
PB 2019R3 - PostgreSQL 11
Sample Query to construct a datawindow. Actual query is bit length and does more
SELECT *
FROM crosstab(
$$SELECT *
FROM example
Where field1 = '100'
And field2 = '200'
ORDER BY...
Hi,
I have a problem with a datawindow field when its length exceeds the height of the page. The field can be up to 4000 characters long. When exposed in the datawindow, it happens that the text is truncated and carried over to the next page. The fi...
I want to use an Insert into Select statement in a datawindow but I get the following message:
Is there any way to do this?...
- Page :
- 1