Discussions tagged DataWindow
Need to detect triple click with events in Powerbuilder Objects
- How-to
- Last updated 1 week ago
- John Fauss replied 1 week ago
*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 ...
Datawindow with multiple rows & DDDW Issue
- Resolved
- How-to
- Last updated 2 weeks ago
- John Fauss replied 1 week ago
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"
- Issue
- Last updated 1 month ago
- David Peace (Powersoft) replied 1 month ago
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....
Report is printing the wrong value from the database
- Resolved
- Advice
- Last updated 1 month ago
- Sivaprakash BKR replied 1 month ago
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...
Datawindow - Scroll Last Page
- Resolved
- How-to
- Last updated 1 month ago
- Benjamin Gaesslein replied 1 month ago
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...
DataWindow ButtonClicked crash
- Issue
- Last updated 1 month ago
- Chris Pollach @Appeon replied 1 month ago
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...
Undesired vertical scrolling in grid dws when switching windows in Tabbed View
- Issue
- Last updated 1 month ago
- Glenn Scamman replied 3 days ago
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...
Programmatically Add tableblob Object to a DataWindow?
- Resolved
- How-to
- Last updated 2 months ago
- Chris Pollach @Appeon replied 2 months ago
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...
No "Invalid DW row/column specified" error for row 0
- Issue
- Last updated 3 months ago
- Chris Pollach @Appeon replied 2 months 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
- Advice
- Last updated 3 months ago
- Tracy Lamb replied 3 months 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 3 months ago
- Mark Goldsmith replied 3 months 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 3 months ago
- Ronnie Po replied 3 months 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 3 months ago
- John Fauss replied 3 months 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 3 months ago
- John Fauss replied 3 months 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 months ago
- kitty he @Appeon replied 3 months 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 months ago
- Chris Pollach @Appeon replied 3 months 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...
- Page :
- 1