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
22132 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
5373 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
TLS 1.2 when connecting to a SOAP webservice in PB2017
  1. Resolved
  2. How-to
  1. Last updated 6 years ago
  2.  Sverre Tvedt replied 5 years ago
2 replies
4834 views
0 votes
My company recently updated from PowerBuilder 12.1 to 2017 R2, so we have a lot of legacy code. I have a working connection to a SOAP webservice using the SoapConnection object. I now need to implement TLS 1.2 when connecting to that webservice, but ...
  1.  SOAP
  2.  TLS/SSL
Joseph Neville Joseph Neville
  1. PowerBuilder
Connecting and populating an Excel template
  1. Advice
  1. Last updated 6 years ago
  2.  René Ullrich replied 5 years ago
4 replies
4887 views
0 votes
Hello,   I was wondering if there is another way to connect to and populate an Excel spreadsheet other than the way below...   OLEObject lole_xlapp // Create the oleobject variable xlapp lole_xlApp = Create OLEObject // Connect to Excel and che...
  1.  Excel
  2.  PowerBuilder
Michael Kochevar Michael Kochevar
  1. PowerBuilder
Powerbuilder 11 upgrade installation
  1. Resolved
  2. How-to
  1. Last updated 5 years ago
  2.  Michael Kench replied 5 years ago
2 replies
2528 views
0 votes
Hi Guys, My machine is dying on me so need to put PB11 on a new machine. I have an upgrade license and generated a new key. I'm not having luck when loading a new license key.  Maybe because I generated an alternate license or do I need to install P...
Michael Kench Michael Kench
  1. PowerBuilder
PB2018 BETA not displaying icons
  1. How-to
  1. Last updated 5 years ago
  2.  Ken Guo @Appeon replied 5 years ago
3 replies
2636 views
0 votes
Hi, After installing 2018 Beta, I do as I always have done, I place all my images in a resource folder and add this path to the PB180.EXE path in the registry. The problem is that none of the images are displayed. There are no hard-coded paths for t...
  1.  PowerBuilder (Appeon)
  2.  UI
Gerry Whitmarsh Gerry Whitmarsh
  1. Beta Testing
Automated Compile Problem
  1. How-to
  1. Last updated 5 years ago
  2.  Ken Guo @Appeon replied 5 years ago
1 reply
1995 views
0 votes
Hello, Trying to use the Autocompile in PB2017 with our automated process but I am stuck on how to point to the workspace when PB is not installed. The following lines are in an orca script that a batch file executes to do a GLV... ;**************...
Michael Kochevar Michael Kochevar
  1. PowerBuilder
Datawindow DDLB - how to search on datavalue
  1. Resolved
  2. How-to
  1. Last updated 5 years ago
  2.  Chris Pollach @Appeon replied 5 years ago
3 replies
2602 views
0 votes
I can't find any reference on how to do this, so it's either so simple I am missing it.  How can I search a column with edit style ddlb, on the data value (not display value).  Reason for this is. I get the original value for the column and now I nee...
David Vasconcelos David Vasconcelos
  1. PowerBuilder
Can't connet to DB(informix) with encoding utf8
  1. Resolved
  2. How-to
  1. Last updated 5 years ago
  2.  Chris Pollach @Appeon replied 5 years ago
1 reply
2264 views
0 votes
I try to connect DB(informix) with encoding utf8. When i set db connection in client works,but use same code in webservice dosn't work. error is Database locale missmatch. First i try to set dbparms(db_local=bg_bg.utf8) but dosnt works. Second i ...
iliyan iliev iliyan iliev
  1. PowerBuilder
Generate file in web app
  1. How-to
  1. Last updated 5 years ago
  2.  Chris Pollach @Appeon replied 5 years ago
3 replies
2328 views
0 votes
Hello!  I am making a web app, when I click a button I get through a webservice a string with the data of a pdf encoded in base 64.To be able to show it in the web browser I have to generate the pdf file.I would like this file to be saved in a web s...
Cecilia Jiménez Bedoya Cecilia Jiménez Bedoya
  1. PowerServer 2020 or older (Obsolete)
Need help with making API calls
  1. Resolved
  2. How-to
  1. Last updated 6 years ago
  2.  Kiat Chun replied 5 years ago
2 replies
4208 views
0 votes
Hi team, I'm using PowerBuilder 2017 R3, and completely new to WSDL/SOAP and RESTful webservice API stuff.. .I need some help, don't know where/how to start, or what approach to take for programming this in PB. I'm given two API urls, and some temp...
Kiat Chun Kiat Chun
  1. PowerBuilder
Any Impact in pure IPv6 network environment to Oracle database?
  1. Resolved
  2. Advice
  1. Last updated 5 years ago
  2.  Kai Zhao @Appeon replied 5 years ago
1 reply
2643 views
0 votes
Dear APPEON Team,   Due to network environment changes, oracle service would be hosted in cloud service with pure IPv6 network access only. We suppose network infrastructure support IPv6, and guarantee end-to-end connection can be established from...
  1.  Cloud
Chung Hing Charlie Wong Chung Hing Charlie Wong
  1. PowerServer 2020 or older (Obsolete)
Application/IDE crash with ODBC Driver 17 for SQL Server
  1. Resolved
  2. Issue
  1. Last updated 5 years ago
  2.  Chris Pollach @Appeon replied 5 years ago
2 replies
2451 views
0 votes
We've recently updated one of our internal testing environments to use ODBC Driver 17 for SQL Server to support more recent versions of TLS and have discovered that our application will crash to desktop with an IDMS error in PBSHR170.dll if we SELECT...
Jonathan Miller Jonathan Miller
  1. PowerBuilder
Orca Script for build machine
  1. Resolved
  2. Misc
  1. Last updated 6 years ago
  2.  Phil Wallingford replied 5 years ago
2 replies
3823 views
0 votes
Hi,   If we want to build our powerbuilder 2017 R3 application on a build machine, do we need some licence? We dont want to use the PBC apps to compile because we don't want one PBD by PBL. We will have some conflict between the PBD generated on ...
  1.  Build
  2.  License
  3.  OrcaScript
  4.  Server
Mathieu Normandeau Mathieu Normandeau
  1. PowerBuilder
Orca error in 'setLibList'. Result Code -4
  1. Resolved
  2. How-to
  1. Last updated 6 years ago
  2.  Phil Wallingford replied 5 years ago
2 replies
2459 views
0 votes
Hi,   I'm getting stumped on an orca script for a PB app that I'm migrating to PB2017R3.  It throws an error "Orca error in 'setLibList'. Result Code -4" "Library 'xxxxxx.pbl' failed to open2019-01-08T19:46:48.4553438Z [exec] An OpenLibrary() opera...
Jeffrey Alonzo Jeffrey Alonzo
  1. PowerBuilder
Migration Assistant: printheader event in pfc_u_rte object
  1. Resolved
  2. Issue
  1. Last updated 6 years ago
  2.  Kevin Ridley replied 5 years ago
6 replies
2876 views
0 votes
Hey All, I wouldn't normally use a Critical priority, but I have to get this one PB app migrated from v11.2 to 2017 R2 to keep up with pending Oracle DB upgrades.  Our first app went through Migration Assistant without a snag and built just fine, ...
  1.  Error
  2.  Migration
Jim Means Jim Means
  1. PowerBuilder
Performance issues with an array of userObjects (and nothing abnormal whos up in trace)
  1. Resolved
  2. Issue
  1. Last updated 6 years ago
  2.  François Rossignol replied 5 years ago
7 replies
2659 views
0 votes
Hi,   I'll try to summerize the problem I encounter I use PowerBuilder 2017R3   I have a window That window has 3 arrays of userobjects in the instance variables u_datawindow idw_reports[] (the report datawindow) u_sort_options iuo_sort_optio...
François Rossignol François Rossignol
  1. PowerBuilder
Rollback on database disconnect
  1. Resolved
  2. How-to
  1. Last updated 5 years ago
  2.  Andreas Mykonios replied 5 years ago
5 replies
3532 views
0 votes
Hello, Using PB 2017 R3, PostgreSQL 11 Need to rollback on database disconnect command. Updating a sequence of dw within a database transactions.  If, in the middle of the update, some error erupts my application gets closed after disconnecting th...
  1.  PowerBuilder (Appeon)
Sivaprakash BKR Sivaprakash BKR
  1. PowerBuilder
Client Certificate in HTTPClient
  1. How-to
  1. Last updated 5 years ago
  2.  Roland Smith replied 5 years ago
1 reply
4278 views
2 votes
I have trying to connect to our external party using the HTTPClient but it requires a Client Certificate to be included. How do I go about setting the certificate in the HTTPClient?
  1.  Certificate
  2.  HTTPClient
Joshua Woon Joshua Woon
  1. PowerBuilder
of_appeondownload fails with error "File is half-baked"
  1. Issue
  1. Last updated 7 years ago
  2.  Marco Meoni replied 5 years ago
2 replies
2308 views
0 votes
In my mobile application the upload of image to the server takes place successfully but the download fails. Using AppeonFileservice function of_appeonupload and of_appeondownload. The log file shows "download failed. File is half-baked". The same fil...
  1.  File
DK BATRA DK BATRA
  1. PowerBuilder
How to get list of columns from a query?
  1. Issue
  1. Last updated 6 years ago
  2.  Sivaprakash BKR replied 5 years ago
3 replies
3154 views
0 votes
A PowerBuilder datawindow has some parameters and those parameters are obviously matched with columns in query of the datawindow. The query is too complex. In my script i get the query syntax in a string variable. Also i get parameters list defined i...
  1.  DataWindow
  2.  Query
Berka Frenfert Berka Frenfert
  1. PowerBuilder
SQLCA.Database v/s SQLCA.DBParm Database
  1. How-to
  1. Last updated 5 years ago
  2.  Roland Smith replied 5 years ago
3 replies
4611 views
0 votes
Hi,   Is SQLCA.Database = "DatabaseName" not supported by "SNC SQL Native Client(OLE DB)" driver?   The connection object fails to connect to the database unless it's passed as SQLCA.DBParm = "Database='databasename',Provider='SQLNCLI11'"   I ...
  1.  Database
  2.  Database Driver
  3.  DB2
  4.  PowerBuilder (Appeon)
Sanjay Shivade Sanjay Shivade
  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