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
22136 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
5375 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
Replacing Rows to Disk unsupported feature
  1. How-to
  1. Last updated 11 months ago
  2.  Chris Pollach @Appeon replied 11 months ago
1 reply
599 views
0 votes
Hi All, I have been trying to replace unsupported feature Rows to Disk for the reports in our code base. Each of these reports have numerous nested reports, with each report having a SP as a datasource. What I could think of is to check the number ...
Preetish Agarkhed Preetish Agarkhed
  1. PowerServer
parent menu of a menu?
  1. Resolved
  2. How-to
  1. Last updated 11 months ago
  2.  Yiannis Papadomichelakis replied 11 months ago
1 reply
678 views
0 votes
Hi PB community... Is there any way to obtain the parent menu of a menu? If for example I have the reference of a leaf menu, can I "travel" from that menu to it's root? I know I can use the item[] property to get the child menu items, I suppose I ...
  1.  Menu
  2.  PowerBuilder (Appeon)
Yiannis Papadomichelakis Yiannis Papadomichelakis
  1. PowerBuilder
NativePDF verses Ghostscript
  1. How-to
  1. Last updated 11 months ago
  2.  Roland Smith replied 11 months ago
1 reply
635 views
0 votes
PB 2022 Build 1892 We changed the application object setting to force use of NativePDF across the entire app. Now we are having trouble with a very large report with lots of images on every page. Is it possible to override this setting for a partic...
Roland Smith Roland Smith
  1. PowerBuilder
unable to assign values to SQLErrText
  1. Issue
  1. Last updated 11 months ago
  2.  Chris Pollach @Appeon replied 11 months ago
2 replies
700 views
0 votes
I am trying to assign values to transaction properties as below transaction l_tmp l_tmp = CREATE transaction l_tmp.DBParm = arg_trans.DBParm l_tmp.SQLErrText= arg_trans.SQLErrText l_tmp.SQLDBCode= arg_trans.SQLDBCode   I observe that l_tmp.SQL...
  1.  Transaction
Kirankumar Chavadi Kirankumar Chavadi
  1. PowerBuilder
ConnectToNewObject( "Word.Application" ) return -3
  1. Issue
  1. Last updated 2 years ago
  2.  Chris Pollach @Appeon replied 11 months ago
1 reply
1690 views
0 votes
Hi Guys, PB Version 2019 R3 build 2703.   Some days ago some of our users have started having issues with ConnectToNewObject( "Word.Application" ) command. It returns -3 that means "Object could not be created". This happens on both, MOffice 2019 a...
Mihai Apostol Mihai Apostol
  1. PowerBuilder
Appeon Server Locations
  1. Misc
  1. Last updated 11 months ago
  2.  Armeen Mazda @Appeon replied 11 months ago
1 reply
638 views
0 votes
I have a question in general, where are Appeon servers located where data and user account info is stored.  If in US which zone and city and if outside where? Our company's cyber security department requires that every vendor we use provide us with ...
  1.  User Center
Ravi Nath Ravi Nath
  1. PowerBuilder
DAST/SAST scans for PowerBuilder
  1. Resolved
  2. Advice
  1. Last updated 11 months ago
  2.  Armeen Mazda @Appeon replied 11 months ago
1 reply
686 views
0 votes
Could you recommend a product to perform DAST and SAST scans on PowerBuilder code?
AGA Support AGA Support
  1. PowerBuilder
NativePDF printing transparent text poorly
  1. Issue
  1. Last updated 11 months ago
  2.  Armeen Mazda @Appeon replied 11 months ago
2 replies
685 views
0 votes
PowerBuilder 2022-R3 I created a text control with font Tahoma 72, Color Red, Transparency 66, Escapement 450. This is what I get when doing a SaveAs (NativePDF). Is there a way to have it not be cross-hatched? It isn't like that in the DataWindow. ...
Roland Smith Roland Smith
  1. PowerBuilder
Events in a transaction object (n_tr) like retrievestart/-end for logging purposes.
  1. How-to
  1. Last updated 12 months ago
  2.  mike S replied 11 months ago
5 replies
986 views
0 votes
I like to log the begin and the end of an SQL statement because i like to measure the time the SELECT needed. In datawindows i have the retrievestart and retrieveend events where i can exactly do what i wish to do. In embedded SQL i use SQLCA which...
  1.  Embedded SQL
  2.  Logging
  3.  PowerBuilder
  4.  Retrieve
  5.  SQL
  6.  Transaction
Olaf Bönning Olaf Bönning
  1. PowerBuilder
what is the difference between runtime.msi file and powerbuilder runtime exe file
  1. Advice
  1. Last updated 1 year ago
  2.  Kevin Ridley replied 11 months ago
1 reply
845 views
0 votes
Hi Team, When I used the pb2022 runtime msi (MSM) file my, application was not running. But when I run the PowerBuilder runtime.exe the application is running. When I checked both are installed on different locations. I need to add the PowerBuilder ...
Subrat patra Subrat patra
  1. PowerBuilder
.NET Desktop Runtime 6.0 Distribution
  1. How-to
  1. Last updated 12 months ago
  2.  Mora Wang @Appeon replied 11 months ago
3 replies
842 views
0 votes
We're looking to upgrade our application from PB2022 (R1) to PB2022R3. The application is 32-bit pcode distributed using PowerClient. We have the problem that: The app's db connection uses ADO.NET, which for PB2022R3 appears to have a prerequisit...
David Sowray David Sowray
  1. PowerBuilder
Is there any specific issue with "OAuthClient" and "TokenRequest" object and the grant_type as "Autherization_code" for access token request? Is there any security concern or disadvantage of using "HttpClient" object for requesting the access token instead of "OAuthClient" and "TokenRequest" object?
  1. Issue
  1. Last updated 12 months ago
  2.  Logan Liu @Appeon replied 11 months ago
2 replies
1025 views
0 votes
We are trying to implement the OAuth flow in PowerBuilder windows application using Azure AD. When the access token is requested using the "OAuthClient" and "TokenRequest" object with the grant_type as "Autherization_code" then we are always getting...
  1.  Bug
  2.  OAuth
  3.  PowerBuilder (Appeon)
  4.  PowerScript (PS)
  5.  PowerBuilder Runtime
Namdev Gopalghare Namdev Gopalghare
  1. PowerBuilder
Where does PB2022 get printer information?
  1. How-to
  1. Last updated 11 months ago
  2.  John Fauss replied 11 months ago
2 replies
793 views
0 votes
I'm working on migrating our application to PB2022 from PB2017 R3 and found that our print settings dialog no longer sets the printer for our application. I double checked the registry location we are using for it (HKEY_CURRENT_USER\SOFTWARE\Microsof...
  1.  Print
Joseph Neville Joseph Neville
  1. PowerBuilder
PDF Writer's
  1. Issue
  1. Last updated 11 months ago
  2.  Chris Pollach @Appeon replied 11 months ago
1 reply
601 views
0 votes
At the university that I work at, I have an issue with using CutePDF writer inside of Infomaker. I wanted to confirm that CutePDF writer is among the listed combability PDF writers that can be used inside of Infomaker. 
Connor Schmitt Connor Schmitt
  1. InfoMaker
ORA-00942: Table or view does not exist
  1. How-to
  1. Last updated 12 months ago
  2.  Armeen Mazda @Appeon replied 11 months ago
1 reply
680 views
0 votes
Getting below messageORA-00942: Table or view does not exist.Do you want to correct errors?
Akhtar Abbas Akhtar Abbas
  1. InfoMaker
PB 2022 R3 Themes and window borders
  1. Resolved
  2. Issue
  1. Last updated 12 months ago
  2.  Chris Pollach @Appeon replied 11 months ago
6 replies
1011 views
0 votes
Hi all, I am trying the new version PB 2022 R3 (RT 3289). When using the themes, I've noticed that the response windows have enlarged right and bottom borders.When I switch to RT 2828 (R2), everything looks fine. When I turn off the themes, it's als...
Tomáš Podzimek Tomáš Podzimek
  1. PowerBuilder
How to show PageAbs() on first NUP row only ?
  1. How-to
  1. Last updated 12 months ago
  2.  Markus Eckert replied 11 months ago
2 replies
659 views
0 votes
I have a 8 NUP datawindow which returns hundreds of rows The way the data represents onscreen is 8 results per row and the datawindow is sized so that 3 rows per screen is shown. I have a VCR like button to navigate between the 'pages' and this tex...
Frank Zettanucci Frank Zettanucci
  1. PowerBuilder
DW editing functionality different behavior if Title is on.
  1. Issue
  1. Last updated 2 years ago
  2.  Chris Pollach @Appeon replied 12 months ago
6 replies
1228 views
1 vote
I was doing some changes in one of our applications and I decided to turn on the title of a dw so it looks cool. Actually it did looks supper cool. I compile the application without testing the editing functionality of the columns. I push the applica...
  1.  PowerBuilder (Appeon)
Clarence Chamorro Clarence Chamorro
  1. PowerServer 2020 or older (Obsolete)
How do I know if user clicked MaxBox or MinBox or X in a Titlebar Datawindow
  1. Resolved
  2. How-to
  1. Last updated 2 years ago
  2.  Chris Pollach @Appeon replied 12 months ago
3 replies
995 views
1 vote
I recently discover the MaxBox, MinBox and X in a Datawindow TitleBar but when I click in the X or the Maxbox or MinBox everything reacts at the datawindow level. I want to Minimize or Maximize or Close the Window. So I will like to find which event ...
Clarence Chamorro Clarence Chamorro
  1. PowerBuilder
How to find out what is the update status of datawindow Before Update() is executed.
  1. Resolved
  2. How-to
  1. Last updated 12 months ago
  2.  Clarence Chamorro replied 12 months ago
1 reply
661 views
0 votes
According to the 2022 PB documentation GetUpdateStatus is obsolete and will be discontinued in a future release. Then how do I get the update status of a datawindow before updating it? Documentation of PB 2022 says to use DBError and SQLPreview eve...
  1.  PowerBuilder (Appeon)
Clarence Chamorro Clarence Chamorro
  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