Featured Questions

Q&A Forum Tip: Including Source Code in Your Question
  1. Advice
  1. Last updated 3 years ago
  2.  Tjafzfa Gsjsf replied 7 months ago
6 replies
22067 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
5304 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
PB2025 Beta DataWindow Detail band color when theme applied
  1. Issue
  1. Last updated 1 week ago
  2.  kitty he @Appeon replied 1 week ago
6 replies
171 views
0 votes
Hi, in PB2025 Beta2,  we cannot modify the background color of the DataWindow Detail band via script or with the expression in the properties dialog when theme applied. The modify command has no effect. We can change the color in the json theme file ...
Stefanos Evangelopoulos Stefanos Evangelopoulos
  1. PowerBuilder
Converting to MFA (Radius Authentication) causes issues with connecting to PB 2021
  1. Issue
  1. Last updated 1 week ago
  2.  Miguel Leeuwe replied 1 week ago
3 replies
154 views
0 votes
Good morning,We are using: Oracle SQL Developer Version 23.1.1.345 Build 345.2114, PowerBuilder 2021 Build 1509Database: Oracle 19c (soon to be 21c)Will be migrating to PowerBuilder 2022 soon as wellOur agency has decided to convert to Multi-Factor A...
Steven Turner Steven Turner
  1. PowerBuilder
Assistance with Synchronizing New Objects in WizSource
  1. Resolved
  2. How-to
  1. Last updated 1 week ago
  2.  Miguel Leeuwe replied 1 week ago
1 reply
149 views
0 votes
Hi Experts, I am currently using WizSource as my source control system. When one user adds new objects, such as windows or data windows, to WizSource, how can another user be notified of these additions? Additionally, how can the second user import ...
Deva Shanmuga Deva Shanmuga
  1. PowerBuilder
Syntax to modify dw document name
  1. Resolved
  2. How-to
  1. Last updated 1 week ago
  2.  Chris Pollach @Appeon replied 1 week ago
2 replies
150 views
0 votes
Hi all, I keep getting an error message when trying to modify the document name on a datawindow.  Here's the code: dw_1.Retrieve(il_workorder) is_CertName = "Cert" + string(il_workorder) ls_modify = "Print.DocumentName=" + is_CertName ls_return ...
Tracy Lamb Tracy Lamb
  1. PowerBuilder
PDFDocument seems to print image with grey background
  1. How-to
  1. Last updated 1 week ago
  2.  Tracy Lamb replied 1 week ago
1 reply
169 views
0 votes
Hi all, My customer complained that when they merge documents to pdf, the logo on the pdf cert has a grey background color, it should be white.  My merge algorithm uses PDFDocument object. Attached are images of the logo file that's in the document...
  1.  PDF
  2.  PowerBuilder (Appeon)
Tracy Lamb Tracy Lamb
  1. PowerBuilder
PB 2022 R3 3397 Upgrade .pbr PBAutoBuild220.exe issue.
  1. Resolved
  2. Issue
  1. Last updated 1 week ago
  2.  Mary Jane Foster replied 1 week ago
1 reply
143 views
0 votes
Hello:We are in the process of upgrading from PB 2022 R3 3289 to 3397, and I've encountered something strange.  Our custom objects used on buttons and things are not showing in the executable when built from PBAutoBuild220.exe.  But do if a manual bu...
Mary Jane Foster Mary Jane Foster
  1. PowerBuilder
How can I find the data length of a string in PowerScript, considering characters like dash (–) vs minus (-) that appear as one character but require more storage?
  1. Resolved
  2. How-to
  1. Last updated 1 week ago
  2.  Sathishkumar S replied 1 week ago
2 replies
174 views
0 votes
Hi All, I am using PowerBuilder 2022 R3 Build 3356 and MS SQL Server 2019 with the collation set to Latin1_General_100_CI_AI_SC_UTF8. In a DataWindow, I have a column of type string with a length of 375. I have limited the users to type up to 375 c...
  1.  64-bit
  2.  Database
  3.  DataWindow
  4.  PowerBuilder
  5.  PowerScript (PS)
  6.  SQL Server
Sathishkumar S Sathishkumar S
  1. PowerBuilder
Unable to get ADO connection working using Access Token, please help.
  1. How-to
  1. Last updated 2 weeks ago
  2.  Jostein Ullestad replied 1 week ago
5 replies
235 views
0 votes
Hi We face an issue related to ADO database connection and are seeking help resolving it. PowerBuilder: 2022 R3 Build 3391 Visual Studio: 2022 DBMS: Microsoft Azure   In short, the issue is that any SQL command fails with SQLCode -1 and no SQL ...
  1.  ADO.NET
  2.  Database
  3.  PowerBuilder
  4.  MSOLEDBSQL
Jostein Ullestad Jostein Ullestad
  1. PowerBuilder
Anyone have experience with PB App changing SQLAnywhere CHAR's to UTF8
  1. How-to
  1. Last updated 1 week ago
  2.  Andreas Mykonios replied 1 week ago
1 reply
162 views
0 votes
We have a PB 2017 app accessing a SQLANywhere Database which has the character set for CHAR types as windows-1252 (its an old app) but NCHARS are UTF8.  The issue is the SQL ANywhere SQL processor automatically converts the SQL syntax to the CHAR for...
  1.  SQL Anywhere
Glenn Barber Glenn Barber
  1. PowerBuilder
Enhancement suggestions for PB IDE 2025
  1. Misc
  1. Last updated 4 weeks ago
  2.  Julie Jiang @Appeon replied 1 week ago
1 reply
333 views
2 votes
Dear Appeon support I've already sent you the most critical points that we noticed in PB 2025.There are also some less important suggestions regarding the IDE, I'd like to share with you. Ctrl+Click instead of Rightclick-JumpIn other IDEs, you can ...
Simon Jutzi Simon Jutzi
  1. Beta Testing
Drag & Drop DLL for PB 32 Bit and Outlook 32 & 64 Bit available
  1. How-to
  1. Last updated 1 week ago
  2.  Arthur Hefti replied 1 week ago
2 replies
989 views
3 votes
Hi we managed to create a DLL (or better a set of DLLs) for 32 bit PowerBuilder applications that can interact with Outlook 32 bit and Outlook 64 bit as well. The DLL called from a 32 bit application tries to initialize 32 bit MAPI. If it doesn't su...
  1.  DragDrop
  2.  Outlook
Arthur Hefti Arthur Hefti
  1. PowerBuilder
Integrating FedEx Shipping with REST, JSON, and OAuth - source code
  1. Resolved
  2. How-to
  1. Last updated 2 weeks ago
  2.  Paweł Kasperek replied 1 week ago
1 reply
605 views
0 votes
Hi,   I watched the great presentation of John Stano: https://www.appeon.com/conference/elevate-2024/live?id=418. Is it possible to download the sample code presented on this webinar?   Regards, Pawel
Paweł Kasperek Paweł Kasperek
  1. Elevate Discussion
Error getting OAuth access token using RESTClient
  1. Issue
  1. Last updated 1 week ago
0 replies
151 views
0 votes
Hi, I hope you can help us with a perplexing issue we are seeing. No known cause has been found yet. We are experiencing intermittent errors when getting OAuth access token in RESTClient - it works most of the time but fails for a few users dailye.g...
  1.  PowerBuilder
Dave Contessi Dave Contessi
  1. PowerBuilder
A query about the SQLPreview Event
  1. Resolved
  2. How-to
  1. Last updated 5 months ago
  2.  Armeen Mazda @Appeon replied 1 week ago
6 replies
632 views
0 votes
I have a question about the SQLPreview Event of DataWindow When you want to skip your current query based on a specific condition, for example, if I want to skip a DELETE query from being sent to the database, I can return 2 from this event, and it ...
Krishna Mohan Gullap Krishna Mohan Gullap
  1. PowerBuilder
PB22 R3 - save credentials
  1. Resolved
  2. How-to
  1. Last updated 2 weeks ago
  2.  Armeen Mazda @Appeon replied 1 week ago
1 reply
176 views
0 votes
Hello, We have a windows11 station with PB2022 R3.The station is an image that resets every log off.The user profile is roaming profile saved remotely in the network(not local).Every new log in we need to activate the PB manual time after time and t...
gili galili gili galili
  1. PowerBuilder
View PDFs and TIFF files from a PB application
  1. Advice
  1. Last updated 1 week ago
  2.  Armeen Mazda @Appeon replied 1 week ago
2 replies
181 views
0 votes
We currently use different old Active X controls to view different items (Word Docs, TIFF images, PDFs and XML). Unfortunately, these are old 32-bit components and are starting to throw errors randomly or freezing for 2 minutes and then coming back. ...
Ed Van Haren Ed Van Haren
  1. PowerBuilder
PowerBuilder Graph Question
  1. How-to
  1. Last updated 1 week ago
  2.  David Peace (Powersoft) replied 1 week ago
1 reply
142 views
0 votes
Hi Guys I would like to create a graph that is a stacked bar that has this year last year separate stacks for comparison. I have created the graph for This Year and it has the bar stacks based upon the series. How can I tell PB to then include anoth...
  1.  Graph
  2.  PowerBuilder
David Peace (Powersoft) David Peace (Powersoft)
  1. PowerBuilder
DataWindow Background - Theme change
  1. Issue
  1. Last updated 3 weeks ago
  2.  David Peace (Powersoft) replied 1 week ago
3 replies
306 views
0 votes
Hi I am currently using PowerBuilder 2022 R2 where we are adding themes to our application.  Unable to change the background to the Datawindow. We want to add a background color to the window.  Inside that window we have a data window, we are cha...
Priyanka Yerramsetti Priyanka Yerramsetti
  1. PowerBuilder
problems installing 2022
  1. Issue
  1. Last updated 1 week ago
  2.  Tom Jiang @Appeon replied 1 week ago
1 reply
162 views
0 votes
Hi,   I tried to migrate my software to 2022 R3, but after installation and migration of a small aplication without errors, at time of opening any object, the IDE closes, no messages at all.  I was able to connect to a database, but not to edit or ...
  1.  PowerBuilder (Appeon)
Alfredo Santibanez Alfredo Santibanez
  1. PowerBuilder
Unable to Install PowerBuilder MR2170 2019 - "Failed to Install the Application" Error
  1. Issue
  1. Last updated 2 weeks ago
  2.  Chris Pollach @Appeon replied 2 weeks ago
3 replies
157 views
0 votes
Hi Everyone , I am experiencing an issue while trying to install PowerBuilder MR2170 2019 on my machine. During the installation process, I encounter an error message stating, "Failed to install the application." I have tried several troubleshootin...
Charitha G Charitha G
  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