Hello, We are currently using third party solutions to use some of our PowerBuilder apps as a service in Windows. However, we are in the middle of a Windows Server 2012 to Windows Server 2022 migration and we struggle to get one them running ok. T...

Is it possible to develop PowerBuilder 12.6 with SQL Server 2019 database?...

Will we be able to have multiple lines of tabtext in PowerServer as we do with PowerBuilder on our TabPage objects?  Carriage Returns/Newlines are able to be added to the tabtext property. When running on Client-Server they show properly but when ru...

  Hello, do you have any information regarding the news below? This will probably be problematic for both the PowerBuilder IDE and 32-bit compiled applications. Frédéric Desupport of 32-Bit Oracle Database Clients 32-bit Oracle Database clients a...

Hi! We're deploying PB 2022 Build 1892. I came across a situation yesterday that confuses me. Here's the code: lrc_rest = create RESTClient lrc_rest.SecureProtocol = SECURE_PROTOCOL_TLS1_2 lrc_rest.Timeout = 10 ls_get = 'XMLData=<root>&...

Our DBA team tested Oracle’s Transparent Application Continuity (TAC) which allows a live switch of the database from one server to another without losing the Oracle connections to the database.  When the test was performed against our PowerBuilder a...

Hello,   I migrated an application from PB 2017 to PB 2022 and I observed a malfunction with the SyntaxfromSQL function. In PB 2017 the dw generated had updateable capability and the columns was in edit mode with tabsequence > 0 In PB 2022 the...

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...