Discussions tagged DataWindow

I have a .NET Webservice that when called, generates a DataWindow from DataWindow Syntax passed in as a parameter. The service then creates a PDF file from the generated DataWindow using SaveAS. It then takes that PDF and saves it to a row in a datab...
Hellol PB 2017R3 Suddenly I could not create / open datawindow in PB IDE for one particular windows user [Windows 10].  When I double click the datawindow, the PB IDE just goes into loop [ cursor changes to circle as if long operation is going on]....
I have a datawindow (Powerbuilder 2019 R3) that returns -1 on Update() and the following message appears : Datawindow does not have update capability. I checked the update properties and they looked correct. Suggestions?...
Some years ago I saw the value in having an object that implements dictionary / associative array / map type functionality, mapping string names to arbitrary values, including strings, numbers, dates, and objects. That could be use for passing sets ...
Okay, so I have the following JSON: { "PATIENT_CASE": [ { "CaseDate": "03/05/2021", "NatureofCase": "Abdomen Injury", "CaseClosed": "No", "CaseID": 1261106365, "CenterID": 4716, "SortDate": "2021/03/05", "PatientID": 1261070650, "Hipaa": "No", "Desc...
Dear Team, Is there any way to export Json data from Datawindow Original values from Modified rows? PB 2019. Datawindow   Col 1               Col2                      Buffer                   RowStatus -----------------------------------------...
Hi, We have PowerBuilder desktop applications (windows 10/win32) that are having accessibility issues and we are investigating on what can be done in the area. We currently are in the process of upgrading from PowerBuilder 2017 R3 to PowerBuilder 20...
hi. Here is a datawindow with two column A and B. I want to get the result of the standard deviation of column A when B =  2. What's the script?   Describe("StDevP(if(B=2, A, 0))") ?  or  Set Filter(B=2) Filter() Describe("StDevP(A)") ?    t...
Hi Guys, I am using PB 2017 R3 I have a grid DataWindow with a DropDownDataWindow. Depending on the selection, I should hide or display a couple columns. The issue is: When I try to show them back again, the columns lost the original position and t...
I'm using PB2019R3 including echarts. The Demo App is very helpful but for the Case I'm interested in I couldn't find an example: I want to create an Chart with One or more Series with a datetime x-axis based either on a datawindow or a given SQL sel...
Env: PB 2017 R3, postgres v13 64 bit server, ODBC driver 32bit v13 Hello Experts - We are exploring postgresql as our option as we are trying to move away from sql anywhere. Would like to get your thoughts on what i am missing or how to go about fi...
I had an external datawindow displaying rows of information and a couple of command buttons on each row. The datawindow had no update capacities and all columns had taborder 0. After some trial and error I discovered that by adding one row at design...
Using PB 2017 R3 build 1915 I have a datawindow that has a row of data unintentionally embedded in it in. Using 'edit text' on the datawindow I see a data entry immediately after the stored procedure reference. It prevents the normal retrieval behav...
Has anyone else experienced programs crashing in the DW DLL PBDWE190.DLL (with messages like "progname.exe has stopped working") when you put a DW into PrintPreview mode, or if not then, when go to actually print it? I'm guessing this can be related...
I want to display the company logo and the report title only in the first page, So far in searching the web I found and tested the following -- In the Print Page event datawindow A.) IF Pagenumber > 1 THENdw_report.object.p_header.Visible=fals...
Hello; I am working on a PB app that has existed peacefully for some time, but now needs some new info added to a report. I created an Oracle function to get this value. The function is working fine, kicked off by a button clicked event of a window ...
I migrated a Powerbuilder application from 8.0 to 2019 R2. I have a Getchild call that is returning -1 but it works in 8.0. There have been no modifications. Is there something I should consider about the datawindowchild after a migrationmigra?...
Hi, Is it possible to adjust the scrolling behavior of the mouse for data windows independently of the Windows setting? Page by page or number of lines.Regards...
Hi PB Experts, Hope Everyone is doing well in this pandemic times.  I have bumped into an issue and can't find any suitable solution so I decided to ask for your help. Let me explain the situation here. I have a dw_1, inherited from uo_dw, and it ...
Hello, We have discovered the following: using SNC (SQL Native Client, provider SQLNCLI11 of course), so when a table has datetime column in primary key and database compatibility level is set to, for example, 130 (SQL Server 2016), datawindow based...
  • Page :
  • 1