Discussions tagged DataWindow

Hello, PB 2017 R3, build 1880, Posgresql 11.1 Calling a function from itemchanged event, which retrieves value from db through a query,  Select a.nameInto   :ls_nameFrom  table_aWhere field1 = :ls_where; Messagebox('return1', sqlca.sqlcode)Messag...
We have a DW report with a Summary section with height 0 but autosize height, which can be varying heights depending on the data. We have found that PB tries to always keep the Summary section together on one page, but will never put it alone on the...
With the new theming UI in beta, do we have the capability to make a checkbox and/or radiobutton look disabled in a datawindow like we can on a regular object? I have a screenshot below of what I mean outside of a datawindow.     I don't want to...
I'm using Powerbuilder 12.5. In design mode I have expression on protected which is working how is intend. When i run application is not working at all. Any help please....
Hello, Using PB 2017 SP3 Build 1880 [in a computed column in a datawindow] I need to display a computed column with amount in Indian Format [ ##,##,##,##0.00 ]   (See the comma).  When I create the expression as  namecolumn + ' (' + String(groupb...
Hi Guru I have a problem with an application that crashes. Ecosystem: Windows server 2012r2 Oracle 10 Powerbuilder 2017r3 When I retrieve a datawindows the system goes into error. The retrieve should recover 3,137,457 records. Thi...
Hi All,   I'm using PB12.1. I create a datawindow using syntaxfromsql and then add some controls dynamically into it. All is working except that when I want to modify the width expression of one the controls I added, I could not get any success. Ca...
I built a composite datawindow to allow a user to print two dw's on a single page. I am using sharedata on the dwc's to populate the dw's.  When I call sharedata on one of the dw's it pops the "specify retrieval arguments" window.  Any ideas what is ...
Looking for some troubleshooting suggestions.   I'm receiving a datawindow error trying to import a SRD source file.   The reported row and column do not match the actual SRD source file.   Not even an off by a couple rows close.   The reported appar...
Hello Chris... I have a problem with the datawindow, the detail is that I made a list of products with their image, but when I scroll vertically, the datawindow is locked, and in many cases it takes me out of the application by memory saturation , a...
Hi PowerSphere.   Scenario. I have a moveable datawindow. I really miss a "move" event analouge to the Resize Event   I should like to avoid the "Other" event if possible  Any suggestions (for this missing behaviour :) ) ? Regards Georgios 2...
We are all familiar with drop-down selection lists automatically adjusting their contents as we type.  We can then select the perfect list item at any time as the drop-down list resolves, even by arrowing down and hitting .  A perfect example is the ...
I need the ODBC Driver for SQL Server so I can use encryption TLS 1.2.  I've encountered two problems with inserting and updating datawindows.  I have tables and columns where there is a column on a table that cannot be null but has a database defau...
Here's a weird one we just found.  If you have a datawindow and are using Rowsdiscard to remove rows there seems to be an issue. Scenario. Any datawindow will do, retrieve at least 10 rows.  Update record on row 8 and then using rowsdiscard remove ...
Hello all, Just wondering if there is a solution for this issue on the web:'Autosize Height' does not work on the WEB for the Group Header Band. It's working perfectly in Powerrbuilder client-server environment, but does nothing in the Appeon WEB, th...
I am running PowerBuilder 2017 R3, I have a data window that executes an Oracle procedure with an output parameter as a cursor. If I execute the datawindow from within the powerbuilder IDE the results are returned and I can see the correct data. Wh...
  Hi, We are working in a migration web project with PowerBuilder 2017 R3, the following commands work perfectly fine in classic version but not in the web: ssetting = this.Describe("DataWindow.Selected=''") // Return ! ssetting = this.Modify("Da...
A PowerBuilder datawindow has some parameters and those parameters are obviously matched with columns in query of the datawindow. The query is too complex. In my script i get the query syntax in a string variable. Also i get parameters list defined i...
How to create a XML template for datawindow with conditional child element? I am trying to integrate PBUnit with an integration tool and I need failure element to appear in result only when test failed. Please advise. Thanks,Yuri      ...
Hi Guys, I have datawindow which fetches the data from a single table and the table is a TEMP table. In order to add a new column to datawindow I use edit source and adds a column is select statement and add a column as well. The new column is not r...
  • Page :
  • 1