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
22098 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
5337 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
Chinese characters issue in PowerBuilder
  1. Issue
  1. Last updated 5 months ago
  2.  Peter Pang @Appeon replied 5 months ago
2 replies
590 views
0 votes
Chinese characters couldn't be displayed when querying a DB2 table in PowerBuilder. Could someone help on this? Thanks.  It could be displayed when querying in DB2 command windows.
  1.  DB2
  2.  Encoding
  3.  ODBC
  4.  PowerBuilder
Gilbert L Gilbert L
  1. PowerBuilder
Changing the location PowerServer installs the build.
  1. How-to
  1. Last updated 5 months ago
  2.  Chris Pollach @Appeon replied 5 months ago
1 reply
498 views
0 votes
We are looking to have our PS app install in a specific directory, however, I do not see a setting on the application object in order to achieve this. Currently, it goes in a directory structure like this, C:\Users\USERID\AppData\Roaming\PBApps\Appli...
Kevin Bell Kevin Bell
  1. PowerServer
Could not connect PowerBuilder windows app to SQL Server 2014 After tls upgrade to 1.2
  1. Issue
  1. Last updated 5 months ago
  2.  John Fauss replied 5 months ago
3 replies
913 views
0 votes
Hi Team, Thank you in advance for your help on this. We have migrated PowerBuilder Windows application from PB 2017 to PB 2022 R3. We made this migration to enable application to use tls 1.2. We are connecting windows application to Microsoft SQL Se...
  1.  OLEDB
  2.  PowerBuilder (Appeon)
  3.  SQL Server
  4.  TLS/SSL
Minogue Susan Minogue Susan
  1. PowerBuilder
Eliminate Queries against SYS.ALL_SYNONYMS with PowerBuilder 12.5 / Oracle applications
  1. How-to
  1. Last updated 5 months ago
  2.  John Fauss replied 5 months ago
1 reply
501 views
0 votes
We have a PowerBuilder 12.5 application that runs against Oracle 12 and Oracle 19c. DBA's have noticed excessive queries against SYS.ALL_SYNONYMS.  I understand that these queries have been a part of PowerBuilder for some time, and it seems they occ...
  1.  Oracle
  2.  PowerBuilder
Richard Bianco Richard Bianco
  1. PowerBuilder
Local PB copy connected to server DB
  1. How-to
  1. Last updated 5 months ago
  2.  Chris Pollach @Appeon replied 5 months ago
1 reply
523 views
0 votes
I have a local copy of PB and a local copy of the DB. Of course, I can connect just fine by specifying the local connection string in my ini file. To connect to the server and DB on our network, I have to go to a remote desktop connection - then I c...
Robert Sawyer Robert Sawyer
  1. PowerBuilder
PDFDocument object and GHOSTSCRIPT
  1. How-to
  1. Last updated 5 months ago
  2.  René Ullrich replied 5 months ago
3 replies
450 views
0 votes
Is ghostscript install still required when using PDFDocument object in PB2022?
Dale Burts Dale Burts
  1. PowerBuilder
Re: PBMaxTextSize equivalent for PostgreSQL
  1. Issue
  1. Last updated 1 year ago
  2.  Sivaprakash BKR replied 5 months ago
1 reply
770 views
0 votes
Hello, Using PB 2022 R2 Build 2819, PostGRESql 15 Need to retrieve string values into a datawindow, whose length varies from 50000 to 100000 characters.  Currently it retrieves only 10000 characters with the following settings. Using DSN-Less conn...
  1.  PostgreSQL
  2.  PowerBuilder (Appeon)
Sivaprakash BKR Sivaprakash BKR
  1. PowerBuilder
What values are set for PBESCAPEMENTMODE???
  1. How-to
  1. Last updated 5 months ago
  2.  Kai Zhao @Appeon replied 5 months ago
3 replies
560 views
0 votes
Hi,I am facing vertical text getting shifted from their place issue due to PBESCAPEMENTMODE in the psr files.Can anyone help on 1) How I can check what values are set for PBESCAPEMENTMODE for any PSRs files. 2) How to set value of PBESCAPEMENTMODE ...
  1.  InfoMaker
  2.  PowerBuilder
Dhruv Jain Dhruv Jain
  1. PowerBuilder
PowerBuilder : Exposing API's
  1. How-to
  1. Last updated 5 months ago
  2.  Armeen Mazda @Appeon replied 5 months ago
5 replies
719 views
0 votes
Hi, We are going to migrate from PowerBuilder 12.5 to PowerBuilder 2022.The (urgent) question I have (and sorry if it's already discussed but couldn't find it), is if PowerBuilder 2022 can expose API's?Calling it, yes... but exposing? If not possib...
Marc Schmidtmayer Marc Schmidtmayer
  1. PowerBuilder
Trouble with Yield()?
  1. Resolved
  2. Advice
  1. Last updated 5 months ago
  2.  Tracy Lamb replied 5 months ago
2 replies
525 views
0 votes
Hi all, I'm trying to add a STOP button on the screen for a merge process so the user can stop the loop if the number of certificates on the selected salesorder is high. I added a yield() statement to the loop and a check for the value of the instan...
  1.  PowerBuilder (Appeon)
Tracy Lamb Tracy Lamb
  1. PowerBuilder
ISQL/RESULTS tabs not displaying
  1. Resolved
  2. Issue
  1. Last updated 6 months ago
  2.  Chris Pollach @Appeon replied 5 months ago
2 replies
442 views
0 votes
Using v2022 R3 Build 3356. When I open the Database Painter, the ISQL/Results tabs do not display. Connected to Informix v10.x|12.x|v14.x interface
Stan Zihlman Stan Zihlman
  1. PowerBuilder
PB2019 R3 Migration Issue
  1. Issue
  1. Last updated 5 months ago
  2.  Chris Pollach @Appeon replied 5 months ago
2 replies
430 views
0 votes
Hi All, Currently I'm migrating one of our application from PB12 to Appeon PB2019 R3 version. In our current live version which was build in PB12, I don't see any issues while closing the application But after migrating to PowerBuilder 2019 R3 a par...
Devi Rajalakshmi Devi Rajalakshmi
  1. PowerBuilder
Could not read pdf file ( generated using native PDF ) in Phone
  1. Resolved
  2. Issue
  1. Last updated 5 months ago
  2.  Chris Pollach @Appeon replied 5 months ago
2 replies
509 views
0 votes
Hello, Using PB 2019 R3, PB 2022 R3 build 3356 Generated a report using native pdf and send that to a w.app number.  If the recipient got Android device, then with no issues, he could open that pdf file and read.   If the recipient got iPhone, then...
  1.  NativePDF
  2.  PowerBuilder (Appeon)
Sivaprakash BKR Sivaprakash BKR
  1. PowerBuilder
Stored procedure parameter by reference returns 0 instead of null
  1. Issue
  1. Last updated 5 months ago
  2.  Chris Pollach @Appeon replied 5 months ago
2 replies
530 views
0 votes
Hi all, While upgrading a legacy application from PB17R3 to PB2022R3 I run into a reproducible issue with calling an MSSQL stored procedure which has an integer output parameter.The issue is that when the proc's output parameter is null, PB17R3 corr...
  1.  ADO.NET
  2.  Parameter
  3.  PowerBuilder
  4.  Stored Procedure
Erwin Anema Erwin Anema
  1. PowerBuilder
Retrieving Auto-Incremented column value after saving a row in a Datastore
  1. Resolved
  2. How-to
  1. Last updated 5 months ago
  2.  René Ullrich replied 5 months ago
3 replies
507 views
0 votes
Hello Experts, In a datastore, I am inserting a row and placing values for all columns except for the Roll_no column, which is an auto-increment field. I saved the datastore. Now I need to retrieve the value for the column Roll_no. How can I achieve...
Deva Shanmuga Deva Shanmuga
  1. PowerBuilder
Ensuring Case Sensitivity for Passwords in PowerBuilder Login Screen
  1. How-to
  1. Last updated 5 months ago
  2.  Deva Shanmuga replied 5 months ago
2 replies
456 views
0 votes
Hello Experts, In my application's login screen, the user inputs their login ID and password through text fields. However, PowerBuilder is not validating the case sensitivity of the password. For instance, if the original password is "Abcd1234" and ...
Deva Shanmuga Deva Shanmuga
  1. PowerBuilder
Translate C# to PowerBuilder
  1. Resolved
  2. How-to
  1. Last updated 5 months ago
  2.  Nasir Ahmad replied 5 months ago
3 replies
684 views
0 votes
I generally don't like to display my ignorance, but I'm going to bite the bullet and ask a stupid question. Following is sample C# code off of Microsoft's website.  If I wanted to make this call from PowerBuilder 2022 R3 instead of C#: Is it poss...
Larry Pettit Larry Pettit
  1. PowerBuilder
Syntax conversion will result in partial loss of columns alias
  1. Issue
  1. Last updated 5 months ago
  2.  Chris Pollach @Appeon replied 5 months ago
1 reply
405 views
0 votes
Hello I am using Infomaker 2019 R3.When I click on Data, then Design Menu and Convert to GraphicsI get this alert,  I am trying to add another table to link my data.  IF I click yes, I can link my data but I believe I have lost other data in doing to...
  1.  Syntax
Allison Dunn Allison Dunn
  1. InfoMaker
Powerbuilder, SQL Server, and Dates
  1. Issue
  1. Last updated 5 months ago
0 replies
491 views
0 votes
Not a question...  If you are converting from SQL Anywhere to SQL Server, be aware that Powerbuilder and SQL Server don't communicate dates well. If you have a date parameter you are passing in SQL, embedded or in a datawindow/datastore like so:  ...
  1.  PowerBuilder
  2.  SQL Server
Richard Donagrandi Richard Donagrandi
  1. PowerBuilder
How to set the retrieval argument case sensitive for datawindows.
  1. How-to
  1. Last updated 5 months ago
  2.  Chris Pollach @Appeon replied 5 months ago
1 reply
498 views
0 votes
Hello Experts How to set the retrieval argument case sensitive for datawindows. Thanks  Deva S
Deva Shanmuga Deva Shanmuga
  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