Discussions tagged DataWindow

We have some autocomplete code in our base DW and a service object, for use in editable DDLB style columns in DWs, that works quite well, except for a few edge cases. I'm just wondering whether anyone has some bullet-proof proven code for that, that ...
Hi I was just working on a datawindow in my pb2019 on win7 -it crashed and now i am unable to open any datawindows - it was working up until a few seconds ago, a restart of pc and reopening the programme hasnt fixed it ,  i think its possibly do wi...
Hi Friends, I've got a datawindow that I use for query... in my code, I stop after every 250 rows and ask user if they want to retrieve more. I was editing the datawindow, and it automatically retrieves EVERYTHING... over 200,000 rows.  The message...
Hi friends, How do add days to a datawindow smalldatetime field in script?  I'm trying to compute an invoice due date based on the invoice date and the selected terms (30, 60, 90, etc). TIA, Tracy  ...
I have a crosstab datawindow, and i want to change the Totals column to the left because the results of the datawindow are many and the totals columns are shown on a different page. I want to show my totals column next to the first column....
I thought this would be easy, but I'm stuck trying to find code to scroll a given row to become the top row of a DataWindow. I can get the desired row into the display with ScrollToRow(row) but nothing I have tried (including some proposed solutions ...
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...
  • Page :
  • 1