Discussions tagged DataWindow
No "Invalid DW row/column specified" error for row 0
- New
- Issue
- Last updated 20 hours ago
- Chris Pollach @Appeon replied 17 hours ago
Hello,
I started noticing quite some time ago (maybe in PB 12.5, maybe earlier) that PB stopped throwing an error when GetItemX datawindow method is called with row 0. Now, when it happened again in PB2019 R3, I decided to isolate the issue. I creat...
Find columns in my app that are set to enable autocomplete
- Resolved
- New
- Advice
- Last updated 4 days ago
- Tracy Lamb replied 2 days ago
Hi all,
I changed a lot of my drop-down lists to autocomplete style before I realized the implications of setting the column to allow edits. Is there a way in PB to find all columns set for autocomplete (autocomplete not equal to 0)? Or maybe all ...
Change background.transparency in nested report object - PB2022 R3
- How-to
- Last updated 1 week ago
- Mark Goldsmith replied 1 week ago
I have been tasked with adding a watermark to printed documents.
Before printing, I copy the dataobject into a local datastore, copy the data (RowsCopy), add the watermark to the background (Modify("CREATE...")), and then make the background for ea...
PB PFC column header sort and issues with Grid presentation datawindow.
- Resolved
- How-to
- Last updated 1 week ago
- Ronnie Po replied 1 week ago
Issue: After PFC sorting on clicking the header of the results set (datawindow) the suppress repeating values does not work and displays the suppressed values again giving an appearance of duplicate values.
PowerBuilder Version 2022 R3 → Build 3289
...
Themes not working on client, is there a runtime file missing?
- Issue
- Last updated 1 week ago
- John Fauss replied 1 week ago
Using Powerbuilder 2019 R2 Build 2353. When deploying the application to the clients server the Theme process is incomplete, most of the colors are not set in the clients folder. On the right is the compiled version running in the our own server....
I have a radiobutton style column in a DW (PB 2021) that normally has 3 options. However, depending on some situations I need to change it to only 2 or only 1 option, with varying text. To set it to only 1, I use code like:
dw.object.columnName.valu...
Nested Report issue in Powerbuilder 2019 R2
- Issue
- Last updated 2 weeks ago
- John Fauss replied 2 weeks ago
Powerbuilder 2019 R2 Build 2353
Issue with summary height adjusting when there is a nested report in a trailer.
The nested report reduces the summary band height and there is no way to override this. This happens in the datawindow painter
T...
How to disable the theme for datawindow when the theme is applied
- How-to
- Last updated 3 weeks ago
- kitty he @Appeon replied 2 weeks ago
Hi All,
I have applied the theme for the application using PowerBuilder 2022 R3 Build 3305.
I have two user objects. In one object, I am able to disable the theme for the data window (tp_grid), but in the other, I am not able to disable the theme(t...
Adding alias to column gives ORA- 00920 when using query mode with Oracle
- Issue
- Last updated 3 weeks ago
- Chris Pollach @Appeon replied 3 weeks ago
When querying using query mode when connected to Oracle 19c, and the column being queried has an alias, the oracle statement looks like this.
(AND table.column aliase = 'Input data' )
Example:
In the select part:
COMPANY.STATUS COMPANY_STATUS
P...
QUESTION: With the recent PowerBuilder 2022 R2 update of ADO.NET, is PowerBuilder now enforcing rules that were not previously enforced?
What is described below WAS NOT a problem with PowerBuilder 2022 R1...but with the release of PowerBuilder 2...
DW to C# and Swagger
- How-to
- Last updated 2 months ago
- Francisco Martinez @Appeon replied 2 months ago
Good morning, I have deployed a Webservice for data access using datawindows exported to C#.
I have a question about how to dynamically generate the "documentation" from Snapdevelop with Swagger to deliver to our clients. I have seen how to do...
How to export master-detail datawindow data to UBL-Invoice-2.0 template's XML file?
- Resolved
- How-to
- Last updated 2 months ago
- Chris Pollach @Appeon replied 2 months ago
hi GURUs,
Would like to get your advise how PB datawindow XML template can be build according to UBL-Invoice-2.0.XSD and ultimately the datawindow can export to XML format accordingly (see example output xml file einvoice.xml as attached). Please f...
What is the best way to resize datawindows in PB2022 R2?
- How-to
- Last updated 2 months ago
- Kevin Ridley replied 2 months ago
Good morning,
I want to resize my datawindows depending on the dimension of the screen.
all this in Powerbuilder 2022R2.
Regards,
Edi
...
pb2022 r3 datawindow insert and update
- Resolved
- How-to
- Last updated 2 months ago
- Andrew Davis replied 2 months ago
Hi
I hope someone can help, I am having a weird error - with the simplest of datawindows and programmes
I have just installed pb2022 R3 - on windows 10
I have it connected to SQLexpress database - v14.
I have a very very simple 2 column table...
Hi
This is an enhancement request
Please allow referencing nested reports through GetChild. I think this is just an old Sybase limitation which has no reason anymore.
This limitation can be cheated with a nasty trick:
dw_1.Modify("processing=5") ...
DW.GetItemString returning ANSI encoded string?
- Resolved
- Issue
- Last updated 2 months ago
- Phil Jorgensen replied 2 months ago
Hello,
I have a question on string encoding behavior when sending an HTML SMTP message. Here is a description of the workflow:
First, we are reading in an HTML file as a message template. We are also reading a customizable message from a DataWindow...
Hello Community,a happy and healthy new year to all of you!We found that supporting visually impaired or blind users in PowerBuilder DataWindows is a particular challenge. DataWindows can be read to some extent by screen reader software as long as th...
DataWindow is not displaying Stored procedures from database
- Issue
- Last updated 3 months ago
- venumadhav p replied 1 month ago
Hi,
I am using PowerBuilder 19 and try to connect the Snowflake using ODBC Driver. I am able to connect and execute the queries in DataWindow. When I try to create a DataWindow using Stored Procedure as Data source. PowerBuilder is not displaying th...
Datawindow Modify() returns "Line X column Y: incorrect syntax" when trying to modify Values
- Resolved
- Issue
- Last updated 3 months ago
- Konstantin Goldobin replied 3 months ago
Hello,
I don't think I've ever tried this, so I'm not sure if I'm doing something wrong or this is a known issue. I'm trying to modify a list of values of a datawindow column that has the DropDownListBox edit style but does not have an initial list ...
Does anyone know of any way to capture events from a nested datawindow?
We are attempting to provide a new feature that would allow our users greater flexibility in customizing the layout of "freeform" (non-tabular) reports. We already provide our u...
- Page :
- 1