Discussions tagged DataWindow

I use the DW Query mode in all of the master lists and search screens in my app... it works like a charm.  But, I have a new requirement in one of my master windows to show the number of linked documents, which is stored in a different table.  So my ...
I am creating a new datawindow using a SQL Select. Because of some limitations in SQLServer, I need start with a WITH  (Common Table Expression) I can't seem to get PowerBuilder to understand the result set and get no columns (Or PB Crash)   PB12.6...
So for the first time in 28 years of PowerBuilder, I have need of the First() method in a DWo expression.   You know where I'm going with this right?   Maybe I don't expect an answer; maybe I'm just in denial, but...   I...
Hi, We are challenging problem with high consumption of windows user objects by datawindow.  Windows are limiting processes to 10.000 user objects, it is quite simple to reach this limit in big MDI applications which are using many datawindows. On...
I appears that i can access an array argument value using a computed field.  The values are quoted, and there appears to be a space between them? Does anyone know the format?  Also, if i am just running the dw in preview mode, it appears that i...
Hi.   We have to expand a column in the database from varchar(50) to varchar(100). That column is referenced in a LOT of datawindows.   Is there a way to update all of the datawindows at once so that the datatype is set to char(100) in...
We would like to create a PDF from a DataWindow that contains a hyperlink Is this possible? ...
All, I have an odd scenario happening with 1 datawindow.  We're running PB 2017 Build 1681 32 bit on virtual machines. When I view the datawindow, it seems to be resized, see images below.  It even appears to be a different font and the label...
Hi all I have a app on power builder 2017R2, i have a column date when i test on desktop it works but when i deployed to poderserver the column date give me error No Pass Validation, Any suggest? ...
After migrating my source to PB2017, the exports for the datawindows still say "Release 8" (Migrating from PB8). The only way I see to change that line is to open EVERY datawindow and save them...even without making any actual changes. Does thi...
Hi Is there any way to have an expression in a Datawindow refer to itself by name (or column number)? For example if I want to have editable columns be underlined, I could use this code in its border expression. if( long( describe( '.TabSe...
I am using PB 17 R2 and have the PowerServer installed. I'm running into issues with retrieving data when using a datawindow.  I can connect to the database, issue embedded sql and get data back, and can use a dynamically created datawindow and r...
After migrating my application from Powerbuilder 9.0 to Powerbuilder 2017 (build 1681) I’ve got problems - the application fails to retrieve data if the datawindow has an outer join statement with left or right outer join. Errorcode -131 / SQLSTATE 3...
Hi Since at least Version 12.5, if a DW control had the Autosize Height property enabled, ligatures (for some fonts like for example Calibri) were turned off, while if Autosize Height is disabled, ligatures were turned on. See example: Sinc...
My application connects to SQL 2012 via ODBC.  When I configure the ODBC source to use a SQL Server Native Client driver (either 10 or 11), I get errors with the smalldatetime fields in the database.  It works fine with just the SQL Server driver, al...
DropDown Datawindow event (Event ID: pbm_dwndropdown) is very convenient when you need to modify the child datawindow drop down list just before the opening. I have to change the list back to its original state when the list is collapsing. Is there ...
It am using Powerbuilder 2017 R2.  I have a button on my datawindow.  When I click the button the ItemFocusChanged event on the datawindow is triggering.  Per the PB help "In the ItemFocusChanged event, dwo is always a column control. Therefore, y...
I have a datawindow select data from a table from SQL DB. Whenerer I try to simply select an additional column in datawindow data source (TSQL select) or even just edit the SQL where clause that change nothing on columns.  "The action just take...
I would like for my dw footer to only appear on the last page of each group.  The reason I'm not using the group's trailer is because the trailer doesn't position at the bottom of the page, which is want I need. Although the trailer accom...
Is there a straightforward way to position a group summary so it appears on the bottom of the page like a footer?  Alternately we could have the visibility of the footer set by some variable - but no straightforward way I can think of to coordinat...
  • Page :
  • 1