Featured Questions

Q&A Forum Tip: Including Source Code in Your Question
  1. Advice
  1. Last updated 3 years ago
  2.  Tjafzfa Gsjsf replied 4 months ago
6 replies
19380 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
5016 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
Deployment of C#
  1. How-to
  1. Last updated 3 years ago
  2.  Miguel Alzate replied 3 years ago
3 replies
1561 views
1 vote
When converting PB code to C# and deploying as a web service, is there any runtime besides the .Net framework? Does it use .Net Core?  
Roland Smith Roland Smith
  1. PowerBuilder
lnv_HttpClient.SendRequest("GET", lsurl, lsboby) show error Bad Request - Invalid Verb
  1. Resolved
  2. Issue
  1. Last updated 3 years ago
  2.  David Peace (Powersoft) replied 3 years ago
12 replies
2205 views
0 votes
When call  lnv_HttpClient.SendRequest("GET", lsurl, lsboby) On some PC it show "Bad Request - Invalid Verb" this error but it works on postman. Develop on Appeon PowerBuilder 2019 R2 Build 2353 Deploy on Windows 10 64Bit   My Code Integer li_r...
Kiran Patel Kiran Patel
  1. PowerBuilder
Create installation package
  1. Resolved
  2. How-to
  1. Last updated 3 years ago
  2.  Bjarne Anker replied 3 years ago
6 replies
2236 views
0 votes
Hi. What is the preferred software to create an installation package (setup.exe) for a PowerBuilder 2019 application? InstallShield or something like that? Right now we just zip all the files needed including runtime DLL's and ship it. But both o...
  1.  Installation
  2.  PowerBuilder (Appeon)
  3.  Runtime Packager
Bjarne Anker Bjarne Anker
  1. PowerBuilder
power script for outter join
  1. How-to
  1. Last updated 3 years ago
  2.  Armeen Mazda @Appeon replied 3 years ago
5 replies
1483 views
0 votes
Hi guru I would like to upgrade my powerbuilder script to 2019 r I have question about report for outer join  Powerbuilder 7.0 script as below   FROM pldtl , plhdr, sohdr, stock, customer  WHERE ( plhdr.pl_sysplno = pldtl.pt_sysplno ) and ( pt_sy...
william yau william yau
  1. PowerBuilder
Toolbar Error After Migration from 12.5 to 2019
  1. Resolved
  2. Issue
  1. Last updated 3 years ago
  2.  Chris Pollach @Appeon replied 3 years ago
5 replies
1973 views
0 votes
Hello, I am in the process of moving a powerbuilder app from PB12.5 to PB2019. The migration was a success except for one error. When a user clicks on the Window option in the toolbar the app freezes and then eventually crashes. I have found this er...
Mike Kochevar Mike Kochevar
  1. PowerBuilder
PB2017-R2 EOL
  1. Resolved
  2. Misc
  1. Last updated 3 years ago
  2.  Armeen Mazda @Appeon replied 3 years ago
1 reply
1295 views
0 votes
Hello,   Currently, we are using PB2017-R2. This version on PB is in End of Life (EOL) on 31 May 2020. What's happen the 1st June 2020 ?Will the PowerBuilder IDE continue to launch ? Will we be able to continue working on this PB version?Do we abs...
Guillaume Augier Guillaume Augier
  1. PowerBuilder
PowerBuilder 19 Themes in Windows 7
  1. Resolved
  2. How-to
  1. Last updated 4 years ago
  2.  Miguel Leeuwe replied 3 years ago
5 replies
1936 views
0 votes
Hello, I am migrating an application to PowerBuilder 2019 R2, but the themes are not working, i am working in Windows 7, i migrated the same application to PowerBuilder 2018 and the themes were working. Do you know how the apply the themes of Power...
Jhonns Salas Jhonns Salas
  1. PowerBuilder
Powertools framework from a company called Powercerv
  1. Resolved
  2. Misc
  1. Last updated 3 years ago
  2.  David Peace (Powersoft) replied 3 years ago
1 reply
1505 views
0 votes
Hi Guys I have a prospective client who has an application developed using the powertools framework from a company called Powercerv. They do not have the source for the framework. Has anyone come across this framework and potentially have access to ...
David Peace (Powersoft) David Peace (Powersoft)
  1. PowerBuilder
OKTA integration - How to capture redirect URI back to Appeon web app
  1. How-to
  1. Last updated 3 years ago
  2.  Armeen Mazda @Appeon replied 3 years ago
1 reply
1461 views
0 votes
Hi everyone, I would like to know have anyone done the OKTA integration with PowerServer web app using redirect URI(https://developer.okta.com/docs/guides/sign-into-web-app/aspnet/define-callback/) ?  FYI the company not encourage to used REST API ...
Jit Sing Chan Jit Sing Chan
  1. PowerServer 2020 or older (Obsolete)
system hang when cancel print datawindow in mobile appeon
  1. Issue
  1. Last updated 3 years ago
  2.  Chris Pollach @Appeon replied 3 years ago
3 replies
1404 views
0 votes
Dear appeon,     I have get issue for mobile appeon about print datawindow, the apps get hang or not respond when cancel to print. my script is : dw_report.print(true) do you have solution for this ? , thank you for your cooperation and I hope g...
tomms tomms tomms tomms
  1. PowerServer Mobile (Obsolete)
ODBC connection to HANA server
  1. How-to
  1. Last updated 3 years ago
  2.  Chris Pollach @Appeon replied 3 years ago
2 replies
1498 views
0 votes
Hi, About the 'Database Profile Setup ODBC' If I use Infomaker with an ODBC to a SQL server I can use the Driver-specific parameter : Database=MY_DB. And I will only see the tables in this database. But, if I use an ODBC to a HANA server with t...
  1.  InfoMaker
  2.  ODBC
John Slaats John Slaats
  1. InfoMaker
How do people work around datetime2 data type in MSSQL?
  1. Resolved
  2. How-to
  1. Last updated 3 years ago
  2.  James Hsu replied 3 years ago
3 replies
2395 views
0 votes
We are currently working on migrating an application developed in PB 11.5 to PB 2019 R2.  For about 80% of the functionalities the migration went fine, but for the 20% where we use the datawindow to update the database gives us the following error wh...
  1.  Migration
  2.  PowerBuilder (Appeon)
James Hsu James Hsu
  1. PowerBuilder
Chart Pro from Ultimate Suite
  1. How-to
  1. Last updated 3 years ago
  2.  Liang Frank replied 3 years ago
5 replies
1794 views
0 votes
Hello All,   We are looking for a great chart builder. The chart pro looks nice but I'm concerned about the facts: Locked to One machine by Mac address. This is old and fails often just like the SAP Powerbuilder Only get PBD's and no guarantee ...
  1.  PowerBuilder
Richard Carrier Richard Carrier
  1. PowerBuilder
Need Decryption API in power Builder 2019
  1. Resolved
  2. How-to
  1. Last updated 3 years ago
  2.  suresh Baggam replied 3 years ago
2 replies
1532 views
0 votes
In Power builder, I want to know API used to covert base64 Encrypted value to Decrypted actual string in power builder Below is encrypted string value: pw="3K1rUYBtc8mTlewC/mzLNhMEVCBPsbi5+lt6xw01LMM=" This need to be decrypted string value: pw="...
  1.  PowerBuilder (Appeon)
suresh Baggam suresh Baggam
  1. PowerBuilder
Application will not launch from a command line but works in the IDE.
  1. Issue
  1. Last updated 3 years ago
  2.  David Peace (Powersoft) replied 3 years ago
1 reply
1392 views
0 votes
Hi Appeon,     I have an application that was migrated from SAP PowerBuilder 12.6 Build 4098 to Appeon PowerBuilder 2019 R2.  The application launches and connects to Sybase 15 in the IDE Development environment but will not connect and "hangs" up t...
Craig Simonian Craig Simonian
  1. PowerBuilder
Datawindow Retrieve Error : 1722 - select Error : SQLstate = 22005
  1. Issue
  1. Last updated 3 years ago
  2.  David Peace (Powersoft) replied 3 years ago
7 replies
2218 views
0 votes
Hello, since I migrated an old app developped with PB 7 to PB 2019, I have a big problem with some SQL queries from my Datawindows when executed on a database under Oracle 11g. I get this message : 1722 - select Error : SQLstate = 22005.  But the s...
  1.  DataWindow
  2.  Oracle
  3.  PowerBuilder
  4.  Query
Stephane SHAN Stephane SHAN
  1. PowerBuilder
DataWindow issues passing arguments to nested report
  1. Issue
  1. Last updated 3 years ago
  2.  Ken Guo @Appeon replied 3 years ago
2 replies
1437 views
0 votes
We are using PB 2019 GA and SNC SQL Server database driver. We have a report datawindow that has three nested reports. The main datawindow has a number array as one of the arguments. Here is a snippet of the SQL taken from the SQL Server trace tool:...
Roland Smith Roland Smith
  1. PowerBuilder
Cannot change Tooltip Background or Text color properties on a DW object?!
  1. Issue
  1. Last updated 6 years ago
  2.  Kai Zhao @Appeon replied 3 years ago
5 replies
5251 views
0 votes
Hi, I have a very tiny yet very annoying problem. Im sure Im doing something wrong as the behaviour is identical when working on (grid) datawindows between PB 11.5 and PB 2017 R2.  I am setting up several Tooltips on a few fields on the datawindow...
  1.  Build
Vlad V. Vlad V.
  1. PowerBuilder
DB2 TimeStamp Retrieval Argument
  1. How-to
  1. Last updated 3 years ago
  2.  Chris Pollach @Appeon replied 3 years ago
1 reply
1928 views
0 votes
Hi all, I have a program that must be able to retrieve data based on the previous day's "Approved Date."  I am using PowerBuilder 2017 and I am accessing a DB2 database.  The only retrieval argument in my query is of DateTime type (see query attache...
  1.  DataWindow
  2.  DATETIME
  3.  DB2
  4.  Retrieve
  5.  TIME
Justin Perticone Justin Perticone
  1. PowerBuilder
SNAP API GET METHOD AUTHORIZE
  1. Resolved
  2. How-to
  1. Last updated 3 years ago
  2.  Armeen Mazda @Appeon replied 3 years ago
4 replies
1727 views
0 votes
I have created WEB API Via SNAP DEVELOP, there is controllers for GET Method. normally get method accessible for every one. I want to use specific people to use through JWToken / passing username password. I tried many ways  but no use from postmaste...
lingaiah T lingaiah T
  1. SnapDevelop

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