Featured Questions

Q&A Forum Tip: Including Source Code in Your Question
  1. Advice
  1. Last updated 2 years ago
  2.  Tjafzfa Gsjsf replied 4 months ago
6 replies
19319 views
14 votes
A recent post included some PowerScript code, and I thought I would pass along a tip for pasting code snippets that produces a slightly more readable result than simply pasting code into the website's text editor. The toolbar contains a button to as...
John Fauss John Fauss
  1. PowerBuilder
Please Update Your Queries With The Solution
  1. Resolved
  2. How-to
  1. Last updated 3 years ago
  2.  Olan Knight replied 3 years ago
3 replies
4996 views
12 votes
Saw this and thought it was perfect. Note the angry mob in the background on panel 4.   :)
Olan Knight Olan Knight
  1. PowerBuilder
RestClient caused application to hang
  1. Issue
  1. Last updated 5 months ago
  2.  Armeen Mazda @Appeon replied 4 months ago
1 reply
395 views
0 votes
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=rootDataActio...
  1.  PowerBuilder (Appeon)
  2.  REST
John Raghanti John Raghanti
  1. PowerBuilder
ORA-25412 - transaction replay disabled by call to OCIStmtPrepare occuring during live switch to standby database server
  1. Issue
  1. Last updated 4 months ago
  2.  Jeff Novak replied 4 months ago
2 replies
548 views
0 votes
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...
  1.  Oracle
  2.  PowerBuilder (Appeon)
Jeff Novak Jeff Novak
  1. PowerBuilder
SyntaxfromSQL migration issue
  1. Issue
  1. Last updated 6 months ago
  2.  Jean-Charles Fauchier replied 4 months ago
4 replies
556 views
0 votes
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 dw ...
Jean-Charles Fauchier Jean-Charles Fauchier
  1. PowerBuilder
How to handle nested SetRedraw() pairs, a modest proposal
  1. Misc
  1. Last updated 4 months ago
  2.  John Fauss replied 4 months ago
3 replies
432 views
0 votes
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...
  1.  POST
  2.  PowerBuilder
  3.  UI
Jim Reese Jim Reese
  1. PowerBuilder
Aggregate Functions or the GROUP BY clause :
  1. How-to
  1. Last updated 5 months ago
  2.  John Fauss replied 4 months ago
2 replies
436 views
0 votes
  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...
  1.  ASE
  2.  SQL Server
mahmudattar salah mahmudattar salah
  1. PowerBuilder
"HTTP Error!" message
  1. Issue
  1. Last updated 5 months ago
  2.  Chris Pollach @Appeon replied 5 months ago
2 replies
421 views
0 votes
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...
Miguel Alzate Miguel Alzate
  1. PowerServer
Which code certificates are people using to sign their PowerServer Installable Cloud Apps?
  1. How-to
  1. Last updated 5 months ago
  2.  mike S replied 5 months ago
3 replies
554 views
0 votes
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...
  1.  Certificate
  2.  Cloud
Monica Petersen Monica Petersen
  1. PowerServer
Copy CLIB windows to new powerbuilder instal
  1. How-to
  1. Last updated 5 months ago
  2.  René Ullrich replied 5 months ago
1 reply
360 views
0 votes
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
  1.  PowerBuilder (Appeon)
Systeembeheer SFR Systeembeheer SFR
  1. PowerBuilder
AccessToken return error -21
  1. Resolved
  2. How-to
  1. Last updated 5 months ago
  2.  Ong Chin Keat replied 5 months ago
1 reply
558 views
0 votes
hi everybody, My script below do not get required token as it return error -21. Even I have commented out the "secureprotocal" or set it to lower version, it's still not work. Please help   OAuthClient loac_Client TokenRequest ltr_Request Tok...
Ong Chin Keat Ong Chin Keat
  1. PowerBuilder
Powerserver remote deploy on Windows Server IIS
  1. Resolved
  2. How-to
  1. Last updated 1 year ago
  2.  Monica Petersen replied 5 months ago
4 replies
872 views
0 votes
Hi i have two powerserver project, one for debuging (in local development machine W10 Powerbuilder 2022 Build 1892) and other for remote IIS server (Windows Server 2019) both project works ok in local develpoment machine, but when publish (with Snapd...
damian jimenez damian jimenez
  1. PowerServer
Interesting PowerScript behaviour
  1. Misc
  1. Last updated 5 months ago
  2.  Arnd Schmidt replied 5 months ago
4 replies
455 views
1 vote
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...
  1.  PowerScript (PS)
Konstantin Goldobin Konstantin Goldobin
  1. PowerBuilder
Error "DBMS MSOLEDBSQL SQL SERVER is not supported in your current installation"
  1. How-to
  1. Last updated 5 months ago
  2.  Chris Pollach @Appeon replied 5 months ago
2 replies
687 views
0 votes
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 ...
  1.  Database Driver
  2.  Error
  3.  OLEDB
  4.  PowerBuilder
  5.  SQL Server
Jacob Osborne Jacob Osborne
  1. PowerBuilder
AccessibleName is not accessible in PB22 R3 but PB21
  1. Resolved
  2. Issue
  1. Last updated 5 months ago
  2.  Chris Pollach @Appeon replied 5 months ago
2 replies
410 views
0 votes
Hello, We have a solution developed with PB21 where it uses AccessibleName property (by singlelineedit, commandbottom objects.. not in Dw) Available in MSAA and UI Automation Mode. Using the "Narrator" (an external app) our application in PB21 descri...
Salvador Rodriguez Salvador Rodriguez
  1. PowerBuilder
Powerserver JSON Export error
  1. Issue
  1. Last updated 5 months ago
  2.  Chris Pollach @Appeon replied 5 months ago
4 replies
375 views
0 votes
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...
Preetish Agarkhed Preetish Agarkhed
  1. PowerServer
PowerBuilder IDE and runtime use
  1. How-to
  1. Last updated 5 months ago
  2.  Andreas Mykonios replied 5 months ago
1 reply
415 views
0 votes
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...
  1.  IDE
Carol Bornschlegl Carol Bornschlegl
  1. PowerBuilder
Any techniques get application name and the DB connection password from environment variables?
  1. How-to
  1. Last updated 5 months ago
  2.  Gururaja Udupa replied 5 months ago
4 replies
488 views
0 votes
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...
Gururaja Udupa Gururaja Udupa
  1. PowerServer
Powerserver with JWT authentication
  1. Issue
  1. Last updated 5 months ago
  2.  Logan Liu @Appeon replied 5 months ago
6 replies
615 views
1 vote
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...
Vijay Kumar Vijay Kumar
  1. PowerServer
DW with Group (get the number of selected row)
  1. How-to
  1. Last updated 5 months ago
  2.  gili galili replied 5 months ago
1 reply
410 views
0 votes
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...
gili galili gili galili
  1. PowerBuilder
Powerbuilder Database Profile Not Displaying
  1. Resolved
  2. Issue
  1. Last updated 3 years ago
  2.  Oswin Edward replied 5 months ago
3 replies
1353 views
0 votes
In Powerbuilder 2019 R3, I open my Database Profile and do not see ODBC. It was there a couple of days ago, but now it's gone. What's strange is I have a default profile set up within ODBC and that default connection still connects when I open a data...
Steve Sargent Steve Sargent
  1. PowerBuilder
Replicating SyntaxFromSQL in SnapDevelop
  1. How-to
  1. Last updated 5 months ago
0 replies
469 views
0 votes
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 ...
  1.  SnapDevelop
James Beck James Beck
  1. SnapDevelop

Find Questions by Tag

.EXE .NET 6.0 .NET Assembly .NET Core 3.1 .NET Core Framework .NET DataStore .NET Std Framework 32-bit 64-bit ADO.NET AEM AI Algorithm Amazon AWS Android Apache API APK App Store App Store (Apple) Appeon Workspace Appeon Xcelerator Plug-in Architecture Array ASE Asynchronous Methods Authentication AutoBuild AutoCompiler Automated Testing Automation AutoScript Azure Barcode Base64 Batch BigData BLOB Branch & Merge Browser Bug Build Button C# C# Class Importer C# Editor C# Model generator Calendar Camera Certificate Chrome Citrix Class Client Client/Server Cloud Cluster Collection COM Command Line Compiler Compression Computed Field Configuration Controls Cookies Cordova Crash Cross-Platform Crosstab CSharpAssembly CSharpObject CSS CSV Cursor Data Database Database Driver Database Painter Database Profile Database Provider DataObject DataSource DataStore DataStore (C#) DataStore (PS) DataType DataWindow DATE DATETIME DB2 Debug Debugger Debugging Deployment Design DLL DO-WHILE Dockable Docker Documentation DOUBLE Download DragDrop Edge Edit Style Editor Elevate Conference Email Embedded SQL Emulator Encoding Encryption Enhancement Request Entity Entity Framework ERP Error Event Event Handler Event Handling Excel Exception Export Expression External Functions F# Field File File Access Filter Firefox Firewall Font FOR-NEXT Foreground Format Function Garbage Collection GeoLocation Git Graph HANA Hash Header HTML/5 HTTP/S HTTPClient Icon IDE Identity IIS IMAPI Import InfoMaker Inheritance Installation Integer IntelliSense Interface Internet Internet Explorer iOS IPA iPad iPhone IWA J# Java JavaScript JBoss JDBC JOIN JSON JSONGenerator JSONParser Kestrel Label Lambda Large File LDAP Library License LINQ Linux OS Load Balancing Localization Localized PBVM Log In Log Out Logging LONG LONGLONG macOS MAPI Maps MDI Memory Memory Leak Menu Merge MessageBox Messagging Method Migration MIME TYPE Mobile Model ModelStore ModelStore (C#) MSOLEDBSQL Multi Threading MVC MySQL n-Tier Namespace NativePDF NVO OAuth ODATA ODBC Office Offline OLE OLEDB Online Open Source OpenAPI OpenSSL Oracle OrcaScript Other Outlook Output Package Parameter Patch PayPal PB Classic PB Native PB.NET PBC PBD PBDOM PBG PBJVM PBL PBNI PBORCA PBVM PBX PDF Performance Permission PFC Picture Pipeline Play Store (Google) Plugin Popup Port POST PostgreSQL PowerBuilder PowerBuilder (Appeon) PowerBuilder (SAP) PowerBuilder Compiler PowerBuilder Runtime PowerClient PowerScript (PS) PowerScript IDE PowerScript Migrator PowerServer PowerServer Mobile PowerServer Toolkit PowerServer Web PowerServerLabel Print Properties Proxy Publish PULL PUSH Query Regression Release Renew Resize Response REST Retrieve RibbonBar RibbonBar Builder Rich Text Roadmap RPC Runtime Packager SaaS Scaffolding Script SDI SDK Security Server Service Session Single Sign-on Size SMTP SMTPClient SnapDevelop SOAP Sort Source Code Speech Recognition SQL SQL Anywhere SQL Server SqlBuilder SqlExecutor SQLite SqlModelMapper Storage Stored Procedure Subscription SVN Swagger Syntax TabbedBar TabbedView Tablet TabPage Target TE Control Testing Text TFS Theme TIME Timer TLS/SSL Tomcat TortoiseGit TortoiseSVN Transaction Transparency Trial Trigger TRY-CATCH TX Control Type UI ULONG UltraLite Uninstall Unit Test Unit Testing UNIX OS Update Upgrade Upload URL User Center User Object UWP Validation VARCHAR Variable Versioning Visual Studio Visual Studio Code VM Voice Warning WCF Web API Web Extensions Web Service WebBrowser WebForms WebLogic WebSphere WildFly WinAPI Window Windows OS WinForms Wizard Workgroup Workspace WPF XCODE XHTML XML Zoom