Featured Questions

Q&A Forum Tip: Including Source Code in Your Question
  1. Advice
  1. Last updated 3 years ago
  2.  Tjafzfa Gsjsf replied 8 months ago
6 replies
22101 views
15 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
5341 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
PowerBuilder importpdf does not work for PDF documents with fillable fields
  1. How-to
  1. Last updated 5 months ago
  2.  Peter Pang @Appeon replied 4 months ago
3 replies
479 views
0 votes
Hi   We have a set of PDF files that need to be combined based on certain rules. Following is a sample code. PDFdocument lpdf_doc lpdf_doc = create PDFdocument //Import the PDF content lpdf_doc.importpdf("D:\import\masterdocument.pdf") lpdf_...
Raja RAMASAMY Raja RAMASAMY
  1. PowerBuilder
Slow performance of SaveAsAscii in PB 2022
  1. Advice
  1. Last updated 4 months ago
  2.  Chris Pollach @Appeon replied 4 months ago
2 replies
406 views
0 votes
Hi We have a problem with the performance of the SaveAsAscii function (DataWindows). In PB 8, the SaveAsAscii(ls_file, "~t", "") call took 5-10 seconds, in PB 2022 R3 the same call, for the same data and the same location of the output file, takes 5...
  1.  PowerBuilder (Appeon)
Jacek Karczewski Jacek Karczewski
  1. PowerBuilder
SQL Server SP is not executed properly through PB but working fine in SSMS
  1. Resolved
  2. Issue
  1. Last updated 5 months ago
  2.  Armeen Mazda @Appeon replied 5 months ago
5 replies
659 views
0 votes
We have a SQL Server procedure with 20K lines of code. We will execute the procedure 18 times and syntax is  created dynamically from PowerBuilder. Attached the dynamic query. If the query is executed from SSMS there is no issue, it is inserting int...
  1.  ASE
  2.  Migration
  3.  PowerBuilder (Appeon)
  4.  SQL Server
Venkatesh Guptha Venkatesh Guptha
  1. PowerBuilder
Column order issue in PowerBuilder 2019 R3
  1. Issue
  1. Last updated 5 months ago
  2.  Ronnie Po replied 5 months ago
4 replies
502 views
0 votes
Column order keeps changing in Datawindow every time we open the window. We cleared the registry entry of this window and logged in to the application and opened the screen, it displays the column in correct order. And soon close the screen and reope...
Gayathri Ravi Gayathri Ravi
  1. PowerBuilder
Capturing the Windows scroll event
  1. How-to
  1. Last updated 5 months ago
  2.  John Fauss replied 5 months ago
2 replies
397 views
0 votes
I have a window that contains some objects. When I scroll down, the objects on the window move up (of course). I don't want them to disappear off the top of the window when I get to a certain point. How can I capture the window scroll event so that t...
Robert Sawyer Robert Sawyer
  1. PowerBuilder
How To Manually Create the PB Extended Attribute System Tables?
  1. How-to
  1. Last updated 4 years ago
  2.  John Fauss replied 5 months ago
4 replies
1711 views
0 votes
I realize that the prescribed technique for creating the Extended Attribute system tables (pbcatcol, pbcatedt, pbcatfmt, pbcattbl pbcatvld) is to allow PB to do this auto-magically the first time a connection is made to the database via the Database...
John Fauss John Fauss
  1. PowerBuilder
PB 2022 R3 SQL connection string
  1. How-to
  1. Last updated 5 months ago
  2.  Miguel Leeuwe replied 5 months ago
3 replies
400 views
0 votes
Hi, we use PB 2022 to connect to MS SQL. We use the following connection info DBMS=ADO.NETServerName=atlasDBParm=Namespace='System.Data.OleDb',DataSource='atlas',DisableBind=1,DelimitIdentifier='NO',NCharBind=1,trimspaces=1,CommandTimeout=3600,Trus...
D Aggelis D Aggelis
  1. PowerBuilder
ADO.NET vs. MSOLEDBSQL
  1. Resolved
  2. How-to
  1. Last updated 5 months ago
  2.  Sverre Tvedt replied 5 months ago
4 replies
586 views
0 votes
Platforms: SQL Server 2022/PB 2022 32bit apps We are considering a new attempt to upgrade from PB 2022 to R3, having abandoned the previous attempt to upgrade to R2, due to the hassle with .NET Desktop Runtime 6.0 on  the client side. There are hund...
  1.  ADO.NET
  2.  Database Driver
  3.  PowerBuilder (Appeon)
  4.  MSOLEDBSQL
Sverre Tvedt Sverre Tvedt
  1. PowerBuilder
Generate RSA public/private keys
  1. How-to
  1. Last updated 5 months ago
  2.  Roland Smith replied 5 months ago
2 replies
431 views
0 votes
PB 2019 Build 2170 I'm trying to generate RSA public/private keys which are stored in the database. They are then used by our C# .Net web application. The C# developer I am working with tells me the public key from the below code is X.509 formatted...
Roland Smith Roland Smith
  1. PowerBuilder
Cannot connect to GIT repository
  1. Advice
  1. Last updated 10 months ago
  2.  Chris Pollach @Appeon replied 5 months ago
3 replies
743 views
0 votes
Hi Appeon Team, We are on PowerBuilder 2022 R3 Build 3305, We use GIT source control, my credentials were working fine when I login into bitbucket but when I try to connect to GIT repository from PowerBuilder, I am receiving an error, "Cannot connec...
Subbiya Vasumoorthy Subbiya Vasumoorthy
  1. PowerBuilder
PowerBuilder 2025 release date
  1. Misc
  1. Last updated 6 months ago
  2.  Armeen Mazda @Appeon replied 5 months ago
1 reply
1212 views
0 votes
I may missed that, but what will be the release date for PB2025? THX
  1.  PB Classic
Ludek Nesnidal Ludek Nesnidal
  1. PowerBuilder
PowerBuilder 11 Compatibility with Windows 365 Cloud PC
  1. Misc
  1. Last updated 5 months ago
  2.  Armeen Mazda @Appeon replied 5 months ago
2 replies
509 views
0 votes
Hi Team, Hope you are doing well. I have a query regarding PowerBuilder 11 compatibility with Windows 365 Cloud PC. Does PowerBuilder 11 license works on (or Support ) Windows 365 Cloud PC? One of my teammate is facing issue. Thanks
Karthika NS Karthika NS
  1. PowerBuilder
Need to detect triple click with events in Powerbuilder Objects
  1. How-to
  1. Last updated 5 months ago
  2.  Chris Pollach @Appeon replied 5 months ago
3 replies
627 views
0 votes
*Phenomenon: Need to detect Triple Click similar to DoubleClicked and Clicked Events in Powerbuilder. Is there any way to detect the triple click in powerbuilder. Some of our clients needs functionality with Triple Clicks in Editable Fields in Dat...
  1.  DataWindow
  2.  Event Handling
  3.  PowerBuilder (Appeon)
  4.  User Object
  5.  Window
Bhavesh Vyas Bhavesh Vyas
  1. PowerBuilder
Displaying HTML using PB2022R3 Web Browser control
  1. How-to
  1. Last updated 5 months ago
  2.  Kai Zhao @Appeon replied 5 months ago
4 replies
577 views
0 votes
Hello All,I am trying to use the new Web Browser control to display HTML information in PB2022R3.I have attached a zip file for the sample application to just open a response window to display HTMLI have tried the scripts below in both the Open event...
Toan Nguyen Toan Nguyen
  1. PowerBuilder
Programmatically Setting Autoscale properties in Graph DW
  1. How-to
  1. Last updated 5 months ago
  2.  John Fauss replied 5 months ago
2 replies
402 views
0 votes
hi, In grahp datawindow there is AutoScale property in Axis tab that can be set in design time, once it is offthen further properties like MaximumValue  and MinimumValue can be set. But I want to set it at runtime in scrip in and unable to find corr...
  1.  DataWindow
  2.  Graph
shoaib siddiqui shoaib siddiqui
  1. PowerBuilder
Monitoring PowerServer User Sessions
  1. How-to
  1. Last updated 5 months ago
  2.  Armeen Mazda @Appeon replied 5 months ago
5 replies
524 views
1 vote
We have deployed 100+ applications in 30+ containers in AKS. All our API calls go through the Application Gateway load balancer (e.g., https://mydomain.com/app1api, https://mydomain.com/app2api, etc.). We want to monitor the PowerServer user sessions...
Jeyakumar Chinnapillai Jeyakumar Chinnapillai
  1. PowerServer
Possible issue with Datawindow creation?
  1. Resolved
  2. Issue
  1. Last updated 5 months ago
  2.  Chris Pollach @Appeon replied 5 months ago
1 reply
397 views
0 votes
PB 2021 build 1509 Windows 10 Enterprise I think I may have found a defect in Powerbuilder's grid datawindow creation wizard.  It seems to insert non-ascii characters into the resulting source code when you manually create the Select statement and ...
Troy Cowan Troy Cowan
  1. PowerBuilder
PowerServer problem running sql against SQL Server database
  1. Resolved
  2. Issue
  1. Last updated 5 months ago
  2.  John Raghanti replied 5 months ago
1 reply
462 views
0 votes
Hi! I'm working on a PowerServer proof of concept, and I know that the answer to this question is probably right in front of me, but I can't see it. Running PB 2022 R3 build 3356 and the database is Microsoft SQL Server. I am seeing errors in the c...
John Raghanti John Raghanti
  1. PowerServer
PowerServer with Azure App Service
  1. How-to
  1. Last updated 5 months ago
  2.  Francisco Martinez @Appeon replied 5 months ago
2 replies
502 views
0 votes
Hi Team, I created the PowerServer Project with our current development oracle database and deployed the project to Azure App Service using Visual Studio 2022 (Direct Deployment).  PowerServer Project: Publish to Azure App Service: When We ru...
Shenbagam Balakumar Shenbagam Balakumar
  1. PowerServer
Window changing focus
  1. Resolved
  2. Issue
  1. Last updated 5 months ago
  2.  Roland Smith replied 5 months ago
3 replies
414 views
0 votes
I have a situation where I have two windows open; Window A and Window B. Window A has the focus. I click a button on Window A, and in the click event handler it calls GetFileSaveName(). Even if nothing else happens after that (I commented out all th...
Troy Cowan Troy Cowan
  1. PowerBuilder

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