Discussions tagged DataWindow
Unable to set 'XML' template for Data Export in a datawindow
- New
- Issue
- Last updated 5 hours ago
- John Fauss replied 4 minutes ago
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...
PB Crash while evaluating a computed expression which uses RichText Method
- Issue
- Last updated 2 weeks ago
- Miguel Leeuwe replied 2 weeks ago
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...
My Powerbuilder crashed after datawindow failed
- How-to
- Last updated 3 weeks ago
- René Ullrich replied 3 weeks ago
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...
Cell padding in grid datawindows
- How-to
- Last updated 1 month ago
- Konstantin Goldobin replied 3 weeks ago
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...
Themes: Changing the background color in a Datawindow header on a Tabpage
- How-to
- Last updated 1 month ago
- Andreas Mykonios replied 1 month ago
How can I change the background color of a data window header that is on a tab page in a theme?...
Datawindow update properties trashed when Select from view is modified
- Resolved
- Misc
- Last updated 1 month ago
- Jim Nesbitt replied 1 month ago
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...
Modify Datawindow to use Stored procedure for update using code
- Resolved
- How-to
- Last updated 1 month ago
- Jim Nesbitt replied 1 month ago
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...
Specify retrieval arguments
- Resolved
- Advice
- Last updated 2 months ago
- Tracy Lamb replied 1 month ago
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...
DW RichText edit stye doesn't display prior data
- Resolved
- Advice
- Last updated 2 months ago
- Tomáš Podzimek replied 2 months ago
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...
Report Column/Band Autosize Height sometimes too high!
- Issue
- Last updated 2 months ago
- Chris Pollach @Appeon replied 1 month ago
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...
Save datawindow as image
- How-to
- Last updated 2 months ago
- Chris Pollach @Appeon replied 2 months ago
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...
How can I disable the RichTextToolbar?
- Resolved
- How-to
- Last updated 2 months ago
- Tracy Lamb replied 1 month ago
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...
dw.Update is giving error, but db is still updated
- Resolved
- Advice
- Last updated 2 months ago
- Tracy Lamb replied 2 months ago
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...
Info on DataWindow Converter and nullable property
- How-to
- Last updated 2 months ago
- Francisco Martinez @Appeon replied 2 months ago
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...
ASP .NET Core Web API project: problem with datawindow computed fields
- How-to
- Last updated 2 months ago
- FIlippo Donà replied 2 months ago
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...
Re: DW with PostgreSQL - Crosstab with Retrieval argument
- Issue
- Last updated 2 months ago
- Olan Knight replied 2 months ago
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...
Column contents splits between pages in Detail section when too long. Pb12_5 and PB2019
- Issue
- Last updated 2 months ago
- Olan Knight replied 2 months ago
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...
Insert into Select statement in a datawindow
- Resolved
- How-to
- Last updated 2 months ago
- Chris Pollach @Appeon replied 2 months ago
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