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
19327 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
5001 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
PDF Builder with forms?
  1. Advice
  1. Last updated 7 months ago
  2.  Armeen Mazda @Appeon replied 7 months ago
1 reply
774 views
0 votes
PB 2022 Build 1892. Probably moving to R3 in a couple months. I haven't tried the new PDFBuilder object. I'm wondering if it is possible to use it to populate PDF form fields. My hope is that I can download the W-2 PDF from the IRS, loop through r...
Roland Smith Roland Smith
  1. PowerBuilder
Cannot get raiseerror from procedure called using RPC
  1. Resolved
  2. How-to
  1. Last updated 7 months ago
  2.  Arnd Schmidt replied 7 months ago
1 reply
516 views
0 votes
Hi all, I'm using RPC to call MSSQL stored procedures. local externa function on transaction object  function long PORADI_DNE(datetime DATUM,ref int SEKVENCE) RPCFUNC ALIAS FOR "dbo.PORADI_DNE" If there is  raiserror ('Error from procedure',3,1)...
  1.  RPC
  2.  MSOLEDBSQL
Aleš Vojáček Aleš Vojáček
  1. PowerBuilder
DBMS OLE DB is not supported in your current installation
  1. Advice
  1. Last updated 7 months ago
  2.  Chris Pollach @Appeon replied 7 months ago
2 replies
701 views
0 votes
PB2022 R2 2828 - Oracle 19c 64 bit. After moving our PB app across to 64 bit when our app tries to connect to db get the following message: DBMS OLE DB is not supported in your current installation 32- Bit version runs fine.
rehees rafiq rehees rafiq
  1. PowerBuilder
Trim zero in EditMask
  1. Resolved
  2. How-to
  1. Last updated 7 months ago
  2.  Chris Pollach @Appeon replied 7 months ago
2 replies
447 views
0 votes
Hi,   I've DataWindow with EditMask fields. I know how to set numerical masks with # chars. But the '####' mask ignores multiple 0 chars on lead. I can trim 0 chars on lead ex. 000754 to 754. Is possible to set a mask to block entry 0 char before t...
Paweł Kasperek Paweł Kasperek
  1. PowerBuilder
Webrowser2 runtime vs development
  1. Resolved
  2. How-to
  1. Last updated 7 months ago
  2.  Chris Pollach @Appeon replied 7 months ago
2 replies
500 views
0 votes
When I open (navigate) to a PDF in runtime I get a menu with save icon its looks nice. During runtime no save icon and only download icon and it does nothing. Looks like a chrome download screen   What is is missing ? I dont receive any errors.   ...
Richard Carrier Richard Carrier
  1. PowerBuilder
PSA: Trying to name a function "throw" crashes PB immediately
  1. Issue
  1. Last updated 7 months ago
  2.  Andreas Mykonios replied 7 months ago
2 replies
345 views
0 votes
To reproduce: Open any object painter Add new function Type "throw" into Function name field tab out/click anywhere PB closes immediately without any warning Happens in 2019R3, can't check other versions. The same thing happens with "throws...
Benjamin Gaesslein Benjamin Gaesslein
  1. PowerBuilder
Self-Contained DLL is not loading, getting .net framework error
  1. How-to
  1. Last updated 8 months ago
  2.  Anoop Chaurasia replied 7 months ago
2 replies
478 views
0 votes
Hi, I am facing issue with self-contained .net DLL. in the documents it is mentioned that using self contained DLLs will not require .net runtime to be installed on the target system, but when i am running the application, it is expecting the runtim...
Anoop Chaurasia Anoop Chaurasia
  1. PowerBuilder
Error Opening DLL Library
  1. Issue
  1. Last updated 7 months ago
  2.  John Fauss replied 7 months ago
3 replies
586 views
0 votes
While running PowerBuilder through code i.e right click on Run button then getting below issue. Can you please help me to resolve this . PB version : Version 2019 R3
himanshi tayal himanshi tayal
  1. PowerBuilder
EncodingANSI in PowerBuilder 2022! error
  1. How-to
  1. Last updated 8 months ago
  2.  Benjamin Gaesslein replied 7 months ago
5 replies
553 views
0 votes
I'm migrating to PowerBuilder 2022.This is a phrase I used previously. blob ab_data FileOpen(as_filename,StreamMode!,Write!,LockWrite!,Replace!,EncodingANSI!) ls_body = 'aaaa' ab_data = blob(ls_body,EncodingANSI!) IF FileWriteEX(li_FileNum, ab_d...
Jeong Dae Ryong Jeong Dae Ryong
  1. PowerBuilder
Custom menu item in PowerBar
  1. Issue
  1. Last updated 8 months ago
  2.  Chris Pollach @Appeon replied 7 months ago
7 replies
449 views
0 votes
Hello, I have a custom menu item in the PowerBar, my item command runs an  EXE (with parameters). The exe application run correctly via RUN, but when I try to run it from menu item the PB IDE crashes. Event log details: Faulting application name:...
C K C K
  1. PowerBuilder
Disable view (window) rendering
  1. Resolved
  2. How-to
  1. Last updated 7 months ago
  2.  John Fauss replied 7 months ago
1 reply
386 views
0 votes
Hi, I'm a developer from C#. In WinForms, I can disable/enable the rendering of the form (window). How can I do it in PowerBuilder? What is the best solution to freeze (disable rendering) all controls on view in PowerBuilder? Regards, Pawel  
Paweł Kasperek Paweł Kasperek
  1. PowerBuilder
PostgreSQL identity columns and Powerbuilder
  1. Resolved
  2. How-to
  1. Last updated 8 months ago
  2.  Fernando Gilli replied 8 months ago
4 replies
849 views
0 votes
Hello everyone i'm trying to understand how PostgreSQL is behaving against Powerbuilder 2022 R3, in particular the auto-increment columns. I've create a new postgres DB with a simple table called "test"; Reading the documentation i see that there ar...
Simone Olianti Simone Olianti
  1. PowerBuilder
Replacing Rows to Disk unsupported feature
  1. How-to
  1. Last updated 8 months ago
  2.  Chris Pollach @Appeon replied 8 months ago
1 reply
422 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 8 months ago
  2.  Yiannis Papadomichelakis replied 8 months ago
1 reply
461 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 8 months ago
  2.  Roland Smith replied 8 months ago
1 reply
468 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 8 months ago
  2.  Chris Pollach @Appeon replied 8 months ago
2 replies
478 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 8 months ago
1 reply
1331 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 8 months ago
  2.  Armeen Mazda @Appeon replied 8 months ago
1 reply
459 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 8 months ago
  2.  Armeen Mazda @Appeon replied 8 months ago
1 reply
500 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 8 months ago
  2.  Armeen Mazda @Appeon replied 8 months ago
2 replies
441 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

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