Discussions tagged DataWindow

*Phenomenon: Need to detect Triple Click similar to DoubleClicked and Clicked Events in Powerbuilder. Is there any way to detect the triple click in powerbuilder. Some of our clients needs functionality with Triple Clicks in Editable Fields in Dat...
Hi,   I added below script in DW's sqlpreview event. but getting following error message. Using PB2022 R3 version. "Unsupported(PowerServer) C0237: previewfunctionupdate as the request argument of SQL Preview (Suggestion: Do not use)" If request ...
Okay, hopefully I can explain this correct enough that it makes sense.   TL/DR: Datawindow with multiple rows doesn't always show the DisplayColumn because of the where clause in the DDDW query. We have a datawindow that returns multiple rows. I...
Datawindow update() show "Row Changed between retrieve and update" in PB 2022 R3, this happened after migrate de application from pb 12.5 to PB 2022 R3....
Hi all, I have a report with a nested report.  On my computer in the development environment, when I run the report, I get the correct information.  But when my customer runs the report (compiled in a pbd), he gets the wrong value for one of the fie...
Hi guys, I need some help. I am building a print preview window and I added buttons to navegate to first page (dw_1.scrollToRow(dw_1.Find("page() = 1", 1, dw_1.RowCount())) because dw_1.ScrollFirstPage() was marked as obsolete), next page (dw_1.scr...
A new datawindow in our PB2022 application (22.2.0.3289) has a button on it. I have never used a datawindow button before. For several of my users clicking the same button on the same row twice in a row crashes the program. The crash usually occurs i...
We have noticed that sometime recently, some of our grid datawindows are scrolling to the top automatically when we switch to a different sheet and then come back to it.  We are using PB 2022R3 build 3356, and we have a MDI application that utilizes ...
I have some Rich Text fields on a few datawindow objects.  The issue I'm having is that the user cannot tab out of the RichText field.  When the user types TAB, it inserts a tab character (not really a big deal).  More importantly, when the cursor is...
Hi all, I'm setting the visible property on column True/False in a datawindow object.  I have two other fields that I base the decision on... uncert_included and accredited_requested.   Here's the logic behind the visible property: if ( (IsNull(un...
Hi all, I'm working on a program that allows the user to build/customize a DataWindow, and I'd like the user to be able to add an image to their format. I'm storing images in the database, so I'd like to be able to use the tableblob object, since it...
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...
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 ...
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...
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 ...
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...
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...
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...
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...
  • Page :
  • 1