Assume you have 6 different methods acting on a datawindow or multiple datawindows on a userobject, and these methods can be called in multiple combinations, singly or in combination.They involve sorting/filtering or some other visual change that you...

  I'm using SQL SERVER 2014 I nead Ignore this error . GROUP BY with Aggregate Functions SLQSTAT = 42000 My problem is while executing this query select empId, empName, empstate, sum(empsalary)from emp group by empId, empName ; Result : COLUMN em...

Hello everyone! When performing a retrieve on a datawindow with a rather complex SELECT in my Cloud application, the system throws the message “HTTP Error!” and, in the end, it does not bring any data. If the SELECT is run in Microsoft's SQL Server...

Hi All, With regards to signing a PowerServer Installable Cloud App, is there a consensus on where to buy the certificate, and what type of certificate to buy?  I'm overwhelmed by the choices, and worried I'll buy one that won't work properly with P...

Hi   Just installes PB on a new mashine.  How can I copy my scripts in the 'CLIB' window in PB from one maschine to an other, without copying every single script...

Hello, I've stumbled upon this phenomenon while writing tests with PBUnit. For illustration purposes, I isolated it as follows. Create two global functions: global function integer f_set_string (integer ai_in, ref string as_out); if ai_in = 1 the...

We are attempting to transition from ODBC to MSOLEDBSQL Version 19.3.3, but when we try to connect our Transaction, we get the error in the title of this post: "DBMS MSOLEDBSQL SQL SERVER is not supported in your current installation" This is from ...

Hi,   We are getting an error while exporting the Powerserver JSON file.  It says -  Json Format Error! Error Row :27. Error Offset 938. I have attached a screen shot of the error message.   Can anybody please shed some light on this because w...

We recently went to PowerBuilder 2022 runtimes 1900,  created and deployed our application. For our next release of the application we upgraded to PowerBuilder 2022 R3 Build 3356. Can we look at the application created with PowerBuilder 2022 runtim...

In PowerServer, the Application.JSON file contains values such as the application name and the DB connection password. We need to use these values from the environment variables within the container. Are there any techniques available to accomplish t...

Hi Team,   I enabled buil-in jwt authentication for powerserver application with database user list, I am able to get the access token, however i am unable to start application i mean beginsession is failing , i enabled the application object addit...

Hello, I have a DW with GROUP . There is 4 rows in trailer group section of DW (originally there is 5 rows). GetRow() - always returns 1 row parameter in click() or DoubleClick() event - returns 1 1. How do I get the number of the specific row th...

We are converting our Client / Server Application and trying to implement our Custom Data Query Tool that allows our clients to Generate a dataset from a SQL query and display the results in a dynamic datawindow with the SyntaxFromSQL method.   This ...

I have been tasked with adding a watermark to printed documents.  Before printing, I copy the dataobject into a local datastore, copy the data (RowsCopy), add the watermark to the background (Modify("CREATE...")), and then make the background for ea...

 Hi guys,   using pb 2019 R3 , we suddenly don't receive any "powerbuilder application errors" anymore when we are running our exe from within the IDE. instead our exe just sits there and does nothing. i guess i have adjusted unintentionally a se...

We have a customer running our PB 2017 app in a Citrix Environment. They experience random crashes when generating a document for preview. By adding writes into the code to a log table on their system, we have been able to determine exactly where the...

Hello, Using PowerBuilder 2021 build 1288 against the PBDemoDB2021 SQLAnywhere 17 (32-bit) database, (examples table) we can demonstrate that a datawindow with just 2 columns (example_id integer and technique long varchar) where we have set the Upda...

Hi Team,   In order for Infor to comply with the European Union NIS2 directive, we have been asked to request Software Bill of Materials (SBOM) for all of our 3rd Party Products and Appeon’s PowerBuilder is one of those products.  Would you provide...

I have done migration from 2019 R3 to 2022 R3.In our application we have used certain RTE controls which has been inherited from pfc windows like w_rte_detail and w_rte_detail_text,when i try to  launch the application and navigated to windows which ...

Does powerbuilder2022 support exporting PDF to TXT file, or is there an improvement plan in the future?...