Discussions tagged DataWindow

Just posting some advice in case someone else stumbles onto an issue like this. The SQLSTATE = 42000 a catch all basin for everything under the sun from Microsoft can lead you in circles. Here's another gotcha. When using a PB 2019 R3 application w...
We are currently on IDE 2019 R3 2703 and using Runtime 2703 in production. We would like to get bug fix 6504 out into our production. It is listed as DataWindow category. Can we update our IDE to 2728, but use Runtime 2703, and recreate the executa...
Good Day - I am guessing the property name, itself, is the answer to my question, but I am hoping there's a way to use a native image, such as DataWindow5! as a Tree Node Icon in a Tree View styled DataWindow. I am not trying to compare Apples to O...
I have a small test project in SnapDevelop/R3 to test WebApi using SAP ASE database,  I have simple datawindow in my target. While converting this datawindow in SnapDevelop I am getting this error. Parsing 'd_all_tickets_contract (c:\dev\e-ticket\ti...
DB: AWS(MariaDB) PowerBuilder: PB 2019 R3 When I add new datawindow. Choose Data Source for Grid DataWindow I use SQL Select. But, It always show error message.  SQLSTATE = S0002 [ma-3.1.12][10.3.23-MariaDB-log]Table 'ttla.TABLES' doesn't exist ...
Hi friends, I have several datawindows that use a computed field to display wingding characters based on the value of a field. (Blue check mark for 'T', red x for 'F', or small bullet for null).  Is there a way to turn this into a customized edit st...
How can I make a vertical line in powerbuilder that occupies the entire size of the page from the header to the footer. Thank you. Como puedo hacer una lineal vertical en powerbuilder que ocupe todo el tamaño de la pagina desde el encabezado hasta ...
Hello, I'm using PowerBuilder 2019 R2 and trying to display a MS-Word document inside a DWO, more than 12 pages, without having to type all text using TEXT controls or COMPUTED FIELD controls within the DWO. I've tried to create a Pipeline definitio...
Hi, Good morning. Is there a way to create a Datawindow with this statement. It really doesn't care if it's embebbed or not. DB: Sql Server IDE: PB 2019 R3   I'm doing this because the crosstab which do this, doesn't work and I'm looking for way...
We are currently working to upgrade from PowerBuilder 12.5.1 Build 4015 to Appeon 2019 R3 Build 2703 We have a datawindow that does a straight update to a specific table using the datawindow's update properties.  We also have columns that are NOT pa...
Hi all, I'm writing a new event to be called from the RMB Menu.  I noticed that I can't seem to override the ancestor scripts.  This is true for older event too... I recently upgraded from PB12 to PB19... now all my rbuttonup events are showing the ...
I have a universal datawindow userobject... u_dw. Inherited a new object u_dw_attachments Added a user function of_setworkorder( al_workorder ) In script, when I try to call that function, I get a compiler error. Here's my script: idw_attachments...
Any search window in our system gets a search criteria with the DW query mode. But when a DW is in query mode I cannot specify any string value starting with 'IN-' in any field on the DW. Can anyone point out what is going on and how to solve the is...
In PB 2017 we have an SQL statement that can potentially retrieve too many rows to be manageable.   We would like to limit the retrieve to a specified number of rows and use the SQL START AT syntax to say where to start based on the order by The da...
Hello, For our database driver we are switching to MS OLE DB. During testing it came to my attention that datawindows containing table blobs are causing dwruntimeerrors. I get the message "Select Error: Blob Column doesn't exist". Now I checked th...
I have an application that I upgraded from Powerbuilder 8.0 to 2019 R3. We also upgraded from Sql Server 2008 to Sql Server 2019. I have noticed that when a datawindow has a db column with a checkbox style top and the column is type Bit, the value d...
I upgraded an application from PB 8.0 to 2019 R3. There are two dw's in the scenario. The first dw does the retrieve and the second dw uses an Importstring to pull in the data from the first one: dw_second.importString(dw_first.describe("datawindow....
Good morning, I got a problem with some of my crosstabs datawindows, when i do a retrieve my crosstab starts blinking and after that the application automatically close. If somebody can help me with this issue.    Do you know what is happening ? ...
Dear Experts, using PowerBuilder 2019 R2 Build 2353, I tried to save the content of a DataWindow in a PDF file. Page 1 is generated fine.But from page 2 on it seems that all columns except the last one from pages 1,..., n-1 are printed on page n...
Hi, I'm having some difficulty finding the correct syntax to change the transparency property of the entire datawindow's band (detail band). DW has no groups, just a standard grid datawindow listing excel-like rows. If I do dw_import.Modify("trade...
  • Page :
  • 1