Discussions tagged DataWindow

Hi, We have a process that generate a dynamic report for a customer. It is dynamic because every customer has different information that is printed on the same report. For that we manually build the syntax for the dw and then create it and print it....
Hi Is there a way possibly using the datawindow Modify function that I can change the WSDL URL that i use as the basis for a web service datawindow. I am developing an application off site where I have a WSDL file on one of our local servers here. W...
Hello, I have a problem with a column in a datawindow. The column is a string column and is supposed to contain a subject of a text. If I type a long text without spaces in the column (like a filepath) and the column does not have focus part of the ...
We have a powerbuilder application where we use forms which display text fields which have autosize height. These fields are stacked on the form vertically one above the other. An average sized height is provided in the form, but if more text or da...
We have a problem that two users are experiencing, but we cannot replicate. A window showing a date entry datawindow of transactions calls ScrollToRow(dw.RowCount()) to put the cursor on the last row. That always works for us (and we believe most use...
  Hello, We have a  funcionality that creates dynamically DW the PB function SyntaxFromSQL, in this way dwsyntax_str = sqlca0.SyntaxFromSQL(sqlsyntax, "style(type=grid)", s_err) messagebox('table',dwsyntax_str) The messagebox is showed below for ...
Hi, I have the below simple code that executes when I click on a button.This is on Appeon Mobile App (PB 2017 R3 1858). ls_new_sql gets the sql from DW and adds extra parameters to WHERE clause. The proble I'm have:When I click the button for the ...
We have been testing the NativePDF method (using PDFlib) in PB 2019. It does a nice job of rendering datawindow visual content, but performance is relatively slow as well as CPU-intensive.  Are either of the other rendering methods (Distill using Gh...
Hi, I've got a DW defined with a single column text field visible with a max length of 3k.  Only a single row is retrieved.  The text field is sized to have only about two dozen lines visible at a time.  Vertical Scroll Bar and Auto Vert. Scroll che...
Hi, (this is version 2017 R3) I have data from 4 or 5 different database tables that I need to display as a single unit in the user interface (and allow for datawindow updating). It's a bit painful and messy, but I would like it to feel seemless as...
Hello, I was wondering if anyone knows how to stop PowerBuilder from qualifying an Oracle procedure with its owner in DataWindow Stored Procedure Update properties. We are using a native Oracle driver, not ODBC. Best regards,Konstantin...
Hi Everyone, Just wanted to ask, if there are any possible way to accomplish border on top and double border on datawindow's object? Any dll or script that will do the trick? I am using PB 2019. Thank you!...
I have to modify exisiting data import function which works IN LOOP like:get data from text>  put into datastore  (via INSERT ROW(0) > update ( which causing insert into table....).my goal is to modify it to work like:add, new column - operationif op...
I have a very wide DW, where I want the user to be able to continually see the first two columns, while scrolling horizontally to see the rest of the columns. That is exactly what Excel's Freeze Panes feature allows. What I have come up with so far ...
Hello, is there a tool to check the sql in all Datawindows in a workspace against the database? We are migrating a huge project from Oracle to Postgres (sql join syntax has changed from (+) to "left outer join"). In some of the existing Datawindows...
Hi,I have 2 columns in DW, both of them are DDDWmethod and symbol Method DDDW is like:id(data_col)  method(disp_col)  symbol 1                  met_1                 X 2                  met_2                 X 3                  met_3           ...
Hello all, I am trying to build a report through composite data window and my child data windows have different retrieval arguments (one is bounded by date whereas the other one is a list of all items). What I need to do is display the pieces of the...
Hello  I have several datawindows coming from an old application with graphic SQL written win Powerbuilder outer Join syntax (*= or =*). For example: select student.name, student_email.email from student, student_email where student.id *= student_e...
Is there possibilty to f.e. on clicked button: - to block row changing/mouse selection and leave only focus on current row,- mayby grey out rest of rows?I want to higlight as much as possible which row is now editing, since every row on start is blo...
I have a DW, and right now I am able to edit every row and column.I would like to block all rows when DW opens, and be able to edit row only, if I choose it first and press f.e. button EDIT.Is there a property which i have to set on open event?...
  • Page :
  • 1