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
22119 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
5356 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
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
2596 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
2256 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
2324 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
4205 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
2639 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
2447 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
3816 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
2454 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
2871 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
2644 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
3526 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
4267 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
2305 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 5 years ago
  2.  Sivaprakash BKR replied 5 years ago
3 replies
3149 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
4603 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
What if I want to continue using DBMS=MSSQL and not DBMS=SNC
  1. How-to
  1. Last updated 5 years ago
  2.  Roland Smith replied 5 years ago
1 reply
2712 views
0 votes
Hi,   Is there a way I can avoid changing database provider/driver from Microsoft SQL Server (MSSQL NTWDBLIB - I now this will not be supported by MS) to MS SQL Native Client (SQLNCLI11) ?    Thanks!  
  1.  Database Driver
  2.  PB Native
Sanjay Shivade Sanjay Shivade
  1. PowerBuilder
Multiple monitor support?
  1. Resolved
  2. How-to
  1. Last updated 5 years ago
  2.  Chris Pollach @Appeon replied 5 years ago
2 replies
2462 views
0 votes
Hello everyone, Our end users use two monitors and they open two copies of the same application which they slide one copy over to their second monitor.  When the system opens a dialog it always opens up on the primary monitor not the one that it's f...
Kyle Griffis Kyle Griffis
  1. PowerBuilder
Connection Caches
  1. How-to
  1. Last updated 5 years ago
  2.  Chris Pollach @Appeon replied 5 years ago
1 reply
1974 views
0 votes
Hi all,   Now we are using the pb2017 r3 webservice function to replace the funtions in EA server before as .net webservice interface.   But we set the DB connection in the EA server in connection caches, then the PB just get the CacheName to con...
Sally D Sally D
  1. PowerBuilder
Editing theme datawindow style
  1. Resolved
  2. How-to
  1. Last updated 5 years ago
  2.  Ken Guo @Appeon replied 5 years ago
1 reply
2155 views
0 votes
Hello All, i'm edditing the jsom of the theme under the "datawindow": tag if found : "grid-style": and "cross-style": i like to know the other style values for the json file  i like to change the value of the selected-row-background-color in a...
Andres Slachevsky Andres Slachevsky
  1. Beta Testing
Migration assistant reporting issues with "try catch"
  1. Issue
  1. Last updated 6 years ago
  2.  Miguel Leeuwe replied 5 years ago
7 replies
2599 views
0 votes
Hi, I am in the process of evaluating migration of our PB 9.0.2 code to PB 2017 version of yours. My 4K lines of code have weird issue with Try and Catch. As per Migration assistant the details are as follows. Could you review the code and point us ...
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