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
22123 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
5361 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
How to get the query string in PowerSript
  1. Resolved
  2. How-to
  1. Last updated 5 years ago
  2.  Olan Knight replied 5 years ago
2 replies
2099 views
0 votes
Hi All,    Is it possible in PB to get the query string I'm going to execute from PowerScript with the bind variables replaced like in sqlpreview() event of datawindow? How? Exemple. Insert into table_test (columA, columnB) Values (:colA, :colB);...
Mihai Apostol Mihai Apostol
  1. PowerBuilder
Recovering PBL objects from PBDs
  1. How-to
  1. Last updated 5 years ago
  2.  Olan Knight replied 5 years ago
6 replies
7194 views
0 votes
Is there a way to recover some of the objects that are in a PBD file and get them back into a PBL? My company keeps the developer's checked out files on the C drive of each person's computer. They took my computer to upgrade to Windows 10 and when th...
  1.  PBD
  2.  PBL
  3.  PowerBuilder (Appeon)
Cheri Hutchinson Cheri Hutchinson
  1. PowerBuilder
Access Json Array
  1. Resolved
  2. How-to
  1. Last updated 5 years ago
  2.  Ken Guo @Appeon replied 5 years ago
2 replies
3935 views
0 votes
Hi, I need to access the json array, but I can't find a way to do that. Array: {    "department_array":[       {          "name":"Website",         "col1":"AAA",         "col2":"AEI"      },      {          "name":"PowerBuilder",         "col1":"B...
  1.  JSON
  2.  PowerBuilder
Rodrigo Rosa Rodrigo Rosa
  1. PowerBuilder
Powerbuilder 12.5 vs 2017 not the same behavior on working windows ("not responding" message)
  1. How-to
  1. Last updated 5 years ago
  2.  Mark Lee @Appeon replied 5 years ago
4 replies
2975 views
0 votes
Hello PB users, With Pb 2017 the busy windows' UI behavior is so different that the process seems to be crashing. It's something quite disturbing for our customers. With PB 12.5 when a busy window can't respond, nothing appends, so it seems evident...
Pierre DETE Pierre DETE
  1. PowerBuilder
Is there a way to find out why, specifically, a data source is not found?
  1. Advice
  1. Last updated 5 years ago
  2.  Miguel Leeuwe replied 5 years ago
1 reply
2897 views
0 votes
We have two very similar programs, that are both running on Windows Server 2016.   They are PowerBuilder 12.6 programs.   Let’s call them A and B. A runs very well, just like it did on the old Windows Server 2008 R2 system we copied it from.   B can...
Rick Hedin Rick Hedin
  1. PowerBuilder
Is there a PowerBuilder DeCompiler available?
  1. Advice
  1. Last updated 5 years ago
  2.  Armeen Mazda @Appeon replied 5 years ago
2 replies
7296 views
0 votes
We have some PowerBuilder (PB) code that we may have lost the source.  We would like to know if anyone knows of a PB Decompiler that would help us reconstruct the code.  The only PB Decompiler we have found so far on the Internet has been from a deve...
  1.  PowerBuilder
Ronald Powalisz Ronald Powalisz
  1. PowerBuilder
Docker Linux and ODBC connection
  1. Resolved
  2. How-to
  1. Last updated 5 years ago
  2.  Olivier PAVLIN replied 5 years ago
1 reply
5111 views
1 vote
Hi, I am following this tutorial and I was abble to publish my web service to Docker. https://docs.appeon.com/appeon_online_help/snapdevelop2019r2beta/Publishing_a_Project_with_Docker.html   But I have a question about database driver, I am using...
Olivier PAVLIN Olivier PAVLIN
  1. SnapDevelop
Migration from 8 to 19 - data type errors
  1. Resolved
  2. Advice
  1. Last updated 5 years ago
  2.  Chris Pollach @Appeon replied 5 years ago
8 replies
3281 views
0 votes
New to PB 19. Migrating an app from PB 8 to PB 19. I have a short list of errors. Two at least appear to be PB related and not coding issues -  pfcmain.pbl(pfc_n_trp).2: Error C0001: Illegal data type: transportpfemain.pbl(n_trp).2: Error C0001: Il...
  1.  Error
  2.  Migration
  3.  PFC
  4.  PowerBuilder (Appeon)
Kelly Amott Kelly Amott
  1. PowerBuilder
SQLCA connection
  1. How-to
  1. Last updated 5 years ago
  2.  James Pendarvis replied 5 years ago
3 replies
2017 views
0 votes
Okay - I am not sure why this is happening, but I need to understand. When I execute the application via the IDE the SQLCA.dbparm = "DataSource='**************',TrustedConnection=1,Namespace='System.Data.SqlClient',Database='*******',CommandTimeout=...
James Pendarvis James Pendarvis
  1. PowerBuilder
Generate XML from Structured Data
  1. How-to
  1. Last updated 5 years ago
  2.  Mark Lee @Appeon replied 5 years ago
2 replies
1942 views
0 votes
Since the support of webservice component had end in the PowerBuilder we have to change the strategy to transform and generate the xml.I have been reading about the PBDOM for the XML parsing and this works well, But how about the generation of the XM...
shaila panwar shaila panwar
  1. Beta Testing
Thumbnail Viewer for Images?
  1. Advice
  1. Last updated 5 years ago
  2.  Dennis Little replied 5 years ago
3 replies
1843 views
0 votes
I am developing an application where I need to show the user all the images associated to a particular inspection. I want these images to be grouped and displayed from left to right just like File Explorer does.  I would have thought PB would have t...
Christopher Craft Christopher Craft
  1. PowerBuilder
Setting up an Oracle 9i connection in PB 2019
  1. Resolved
  2. How-to
  1. Last updated 5 years ago
  2.  Kelly Amott replied 5 years ago
5 replies
2397 views
0 votes
New to PowerBuilder 2019. I have two PB 8 apps that I will be migrating. Found the hard way that I have to have a DB connection for a full migration. I am attempting to set up a database profile but need guidance on the server connection parameters. ...
Kelly Amott Kelly Amott
  1. PowerBuilder
How to read mails from a specific folder in outlook
  1. How-to
  1. Last updated 5 years ago
  2.  Roland Smith replied 5 years ago
1 reply
1689 views
0 votes
Hi Team, How to read mails from specific user created folder in outlook? Using the below logic to connect outlook from PowerBuilder: nvo_outlook.connecttonewobject("outlook.application")  nvo_outlook.Activeexplorer()    
Balasubramaniam N Balasubramaniam N
  1. PowerBuilder
Upload documents in Powerbuilder web app
  1. Resolved
  2. How-to
  1. Last updated 5 years ago
  2.  mathews rutto replied 5 years ago
3 replies
1663 views
0 votes
Hi There, I need help on how do i upload a document into my powerbuilder web app running on powerserver. The document can be any format e.g pdf, word, jpf, png etc User can also retrieve. Thank you in advance.
mathews rutto mathews rutto
  1. PowerServer 2020 or older (Obsolete)
ConnectToObject problem
  1. Resolved
  2. How-to
  1. Last updated 5 years ago
  2.  Roland Smith replied 5 years ago
3 replies
1986 views
0 votes
Hi, I have the following code lines.    iole_OLE = CREATE OleObject result = iole_OLE.ConnectToObject(filename,"excel.chart")   it has been working correctly but since a few days the ConnectToObhect returns a -2, Class name not found.   The a...
Cornelis Lijzenga Cornelis Lijzenga
  1. PowerBuilder
pbdwe170.dll failing after Windows upgrade
  1. Issue
  1. Last updated 5 years ago
  2.  Ken Guo @Appeon replied 5 years ago
4 replies
2431 views
0 votes
We are currently experiencing a dll failure issue after upgrading from Windows 2008 R2 to Windows 2012 R2 with the pbdwe170.dll. Looking at some docs, it appears this dll is related to database access.  Below is the screenshot from the event log. C...
David Watson David Watson
  1. PowerBuilder
PBDOM bug?
  1. Issue
  1. Last updated 5 years ago
  2.  Ken Guo @Appeon replied 5 years ago
2 replies
1547 views
0 votes
Has anyone been able to use the PBDOM_Element.GetChildElement method successfully in PB2017?  I'm using PB2017 R2 currently, won't be migrating to 2019 until R2 is GA.  Anyway, I have an element with 5 sub elements.  I'm able to get all of the sub el...
Kevin Ridley Kevin Ridley
  1. PowerBuilder
Do I have to replace my SOAP Connection webservice in PB2019?
  1. Resolved
  2. How-to
  1. Last updated 5 years ago
  2.  Kevin Ridley replied 5 years ago
3 replies
2453 views
0 votes
We are having a SOAP Connection build in PB12.5 for a webservice but in PB2019 its not getting connected giving error, what should I need to do? 
Kalpana Snehi Kalpana Snehi
  1. PowerBuilder
Increase in column size of datawindow
  1. Resolved
  2. Issue
  1. Last updated 5 years ago
  2.  Michael Kramer replied 5 years ago
4 replies
3401 views
0 votes
Hello, Using PB 2017 R3, Postgresql 11.6 By using the query Select a.itemcode as code, a.value as value, a.itemname as name, a.version as versionFrom  tablex aUnion All Select '' as codem, 0 as value, b.name as name, '001' as versionFrom  tabley ...
  1.  PostgreSQL
  2.  PowerBuilder (Appeon)
Sivaprakash BKR Sivaprakash BKR
  1. PowerBuilder
2 Separate PB apps talking to each other
  1. How-to
  1. Last updated 5 years ago
  2.  Armeen Mazda @Appeon replied 5 years ago
2 replies
2331 views
0 votes
I am trying to connect two separate PB Classic applications. One is installed locally on my computer and the other is on a remote web based server. I want to call a function from the local PB application in the Remote PB Application and pass argume...
  1.  PowerBuilder
Richard Shakour Richard Shakour
  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