Discussions tagged DataWindow

I am preparing for a Powerbuilder upgrade from 8.0 to 2019. I will be moving embedded sql to stored procedures and db functions. Is the sql in datawindows considered embedded sql and is it a good practice to move it to stored procedures and have the ...
I have a data window which I am saving as html.  In making some revisions to the application I have noticed a difference in the output html file.  The pre change version of the html has the title tag as <title>Order Inspections<title> T...
Hello,I have column "period", i set an editmask like ### to prevent enter a non-digits characters.When I clear this column (i expected null value in table) - there is always zero.What I want to achieve: column with numbers only and null - when null t...
Morning I hope you can help, I am trying to search / lookup records in a name field on a database. But i am having a problem with special letters  for example below - i want to be able to search 'Caus' and have the below show up ? so the special ch...
Hi All,Boolean operators AND, OR, and NOT have different precedence in DataWindow expressions than in PowerScript.Also, DataWindow expressions have SQL like operators that don't exist in PowerScript. I advise you always use parenthesis to avoid unde...
I am using datawindow control titles for the first time and I notice that I get a pale blue background and a fain almost unreadable text for the title.   Is there a way to change the color and or fond characteristics of a datawindow control's title?...
Ive been building a application that compares snapshots of tables, and have the code down to isolate the changes - now I need to highlight the background of the changed cells in a grid datawindow. I am flagging the changed columns by setting the ite...
I have a DataWindow Object on a Window that switches between two DataWindows via DataObject = "d_...".  Each DataWindow has at least one column with a Validation Expression.  I have no issues running the application in executable/desktop form.  Once...
I need to be able to set an attribute into a cell (row+column) in a grid datawindow which can be used to highlight or otherwise change the appearance of that cell by means of a datawindow expressions - and which can be read out by a program exporting...
I have an PB app that I am using metadata and modify to move columns and text around.  I am having two issues that I think I can work around if I can figure out one of two approaches.     1 - when I use the font.escapement property to rotate a colu...
I have a base window object w_parent that includes datawindow control dw_1.  I create a new window w_child that inherits from w_parent.  On w_child I assign datawindow object d_customer to datawindow control dw_1.  Also on w_child I insert a new data...
I have PB 2019 R2, I am trying to do as instructed https://docs.appeon.com/pb2019r2/pbug/ch20s03.html#Saving_as_PDF_using_xslfo and I get following error: ---------------------------Preview - dw_test---------------------------Save Rows As failed.jav...
Hello, In PB2017R3 when you do dw.SaveAs XLSX! an there is a cell with more than 32767 characters (character size limit of Ecel's cell) - resulting .xlsx file will consider this cell unreadable in MicroSoft Excel. At the same time Open Office just t...
Hi, hopefully someone can help I am getting an error in my application which is 32 bit pb2019 when i run it on windows 2016 RDS Error =  datawindow error Select Error: Decimal conversion error. Powerbuilder supports only 18 digits. Also on some ...
Hello,  I've built an infomaker page in an effort to display elements in the front end of gui system. Using a query and updating all fields to be no edit.  Code pulls a handful of elements from a series of joined tables with the where clause ..  s...
We have some code in our report-viewing window to determine whether VCR-like paging controls (for First, Previous, Next or Last Page) are enabled based on whether there are multiple pages. However, one of our reports has grouping, with Group 1 havin...
Hello everybody, I have a mobile application for Android and I have a problem displaying images in a datawindow object with a tableblob object, when I'm designing the datawindow object in the preview, the images show fine, but when I deploy the app a...
Good afternoon, I am showing images from a table with a DB Blob object in a Datawindows and in Client-Server mode it works without problems, but when deploying web the datawindows does not show the images, do you know what it could be? ?  ...
We have some reports in an application that were designed for landscape mode. However, we realized that in some circumstances (program options) they can be changed to portrait mode, which we think most people prefer. So we added a bunch of DW expres...
Hello, support I need to know how to set up a page size for DW, which is being printed on a continuous sheet.  We are talking about a cash register app, which is printing long receipts. I need to avoid page breaks even if there are 200 rows in the ...
  • Page :
  • 1