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
19385 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
5021 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 mail messages via SMTP in PB2019?
  1. How-to
  1. Last updated 3 years ago
  2.  Miguel Leeuwe replied 3 years ago
3 replies
2205 views
0 votes
I downloaded Roland Smith's emailSMTP utility and was able to utilize a couple objects (n_winsock and n_smtp) in our application for the sending of emails using SMTP.  However, I also need to get messages from our mail sever and process those.  Is t...
  1.  PowerBuilder
  2.  SMTP
Mark Montgomery Mark Montgomery
  1. PowerBuilder
SYSTEM TREE no longer shows workspace or targets
  1. Resolved
  2. How-to
  1. Last updated 3 years ago
  2.  Olan Knight replied 3 years ago
2 replies
1641 views
0 votes
I uninstalled PB2019R2.I installed PB2019R3.I migrated my code, and it worked cleanly.I then got the DLLs out of the bug fix folder 19.2.0.2670_DLL and copied them into my C drive, on top of their respective files. Specifically, the DLLs copied were ...
Olan Knight Olan Knight
  1. PowerBuilder
How can I get my SYSTEM TREE restored?
  1. Resolved
  2. How-to
  1. Last updated 3 years ago
  2.  Olan Knight replied 3 years ago
2 replies
1108 views
0 votes
PB2019R3, b2670Windows 64 bit platformSomehow, I've lost the WORKSPACE view in the system tree. Instead, I have a disk drive view:   HOW CAN I GET MY WORKSPACE VIEW RESTORED????This is what it should look like: Thank you!  
Olan Knight Olan Knight
  1. PowerBuilder
Which runtime DLL is required for PrintGetPrinter & PrintSetPrinter?
  1. How-to
  1. Last updated 3 years ago
  2.  Olan Knight replied 3 years ago
1 reply
1063 views
0 votes
PB2019R3Windows 10, 64 bit platform   We have a utility that's a relatively small piece of code that does NOT use the PFC. In the code, we call PrintGetPrinter and PrintSetPrinter.On the production VM, this works perfectly. On my brand new test VM,...
Olan Knight Olan Knight
  1. PowerBuilder
Mismatch between retrieve columns and fetch columns
  1. Issue
  1. Last updated 3 years ago
  2.  Chris Pollach @Appeon replied 3 years ago
1 reply
1335 views
0 votes
I'm getting the "Mismatch between retrieve columns and fetch columns" error when calling a sql server proc with output parm. These are the particulars: PB 2017 R2 See attached for SQL Server specs It's important to note that the PB app has other s...
Pete Yankovich Pete Yankovich
  1. PowerBuilder
Mismatch between retrieve columns and fetch columns after PB migration
  1. Resolved
  2. Issue
  1. Last updated 3 years ago
  2.  Pete Yankovich replied 3 years ago
4 replies
2209 views
0 votes
I just migrated a PB app from 8.0 to 2019 R2 with no errors. We are also moving from Sql Server 2008 to 2016. When testing the application against Sql Server 2016, I get the sqlca error "Mismatch between retrieve columns and fetch columns" on the fir...
Raymond Longoria Raymond Longoria
  1. PowerBuilder
Issue with reading large value using PowerBuilder SQLDA.GetDynamicString()
  1. How-to
  1. Last updated 3 years ago
  2.  Chris Pollach @Appeon replied 3 years ago
2 replies
1252 views
0 votes
Hello, We are facing issue with  SQLDA.GetDynamicString(). We are creating dynamic SQL and trying to read a value from a string 'ls_input' ( 30000 characters) but  SQLDA.GetDynamicString() is giving us only 16385 characters.    Sample code:  Str...
  1.  PowerBuilder (Appeon)
Pratibha Rawat Pratibha Rawat
  1. PowerBuilder
Transaction ADO.NET Provider String
  1. Resolved
  2. How-to
  1. Last updated 3 years ago
  2.  Chris Pollach @Appeon replied 3 years ago
1 reply
1719 views
0 votes
Dear Team,   We are working on using Transaction for ADO.NET to connect Sybase database. Could  you guide us how to set up the DBParam for connection maximum number for Sybase? ProviderString='value'The MaxConnect don't support ADO.NET with below...
  1.  ADO.NET
Tony Jia Tony Jia
  1. PowerBuilder
"Create of executable file failed Creation of executable failed with a link error" with Jenkins
  1. Issue
  1. Last updated 3 years ago
  2.  Phil Wallingford replied 3 years ago
2 replies
2303 views
0 votes
Hello, today, I´ve run in an error, while using the PB19-Compiler (pbc190.exe) with Jenkins. Everytime i try to run this command: pbc190.exe /d "C:\Projekte\CLI-Build-Test\TestApp2\testapp2.pbt" /o "C:\Projekte\executable\testapp2.exe" /pd n via...
  1.  PowerBuilder Compiler
Mathias Scheck Mathias Scheck
  1. PowerBuilder
RibbonBar - how to trigger the menu on a LargeButton to dropdown
  1. Resolved
  2. How-to
  1. Last updated 3 years ago
  2.  Steen Jakobsen replied 3 years ago
2 replies
1844 views
0 votes
Hi my great fellow PB-champs :-)   Does anyone know if it is possible to trigger the dropdown menu associated with at "LargeButton" to dropdown from a script (programmatically).  I'm using 2019R3 (I want to do that because the used needs to make ...
  1.  PowerBuilder (Appeon)
  2.  Script
  3.  RibbonBar
Steen Jakobsen Steen Jakobsen
  1. PowerBuilder
IDE custom toolbar buttons - pass pbw or pbt via command line?
  1. Resolved
  2. How-to
  1. Last updated 3 years ago
  2.  Roland Smith replied 3 years ago
4 replies
1584 views
0 votes
You can add a custom icon to the PowerBuilder IDE toolbar, and one option is to specify in the "Command Line" a path to launch a separate executable. I'd like to create toolbar buttons that launch small custom utilities which operate against the cur...
Jeff Kandt Jeff Kandt
  1. PowerBuilder
Check embedded SQL when doing a full build
  1. How-to
  1. Last updated 3 years ago
  2.  Markus Schröder replied 3 years ago
2 replies
1896 views
0 votes
Hello, when i do a full build of my workspace, Powerbuilder sends the embedded sql commands to the database. Does Powerbuilder display incorrect sql statements anywhere? (in a postgres database i can see the incorrect statemants in a database logfi...
  1.  Embedded SQL
  2.  PowerBuilder
Markus Schröder Markus Schröder
  1. PowerBuilder
Can't find PBORA190.dll anywhere after installation
  1. Resolved
  2. How-to
  1. Last updated 3 years ago
  2.  Tracy Huang @Appeon replied 3 years ago
3 replies
2070 views
0 votes
Hey folks, I just installed PB2019 R3, Build 2670.  Migrated an app from PB2017 R2.  The only reason for the 2019 upgrade is because we're moving to Oracle v19 databases.  Wanted to get the app migrated before the DB upgrade.  I've searched high a...
  1.  Oracle
  2.  PowerBuilder
Jim Means Jim Means
  1. PowerBuilder
Original DateTime Value Changing When Importing Json
  1. Resolved
  2. Issue
  1. Last updated 3 years ago
  2.  Armeen Mazda @Appeon replied 3 years ago
2 replies
1336 views
1 vote
PB2019 R2 Build 2353, SQL Server 2014   There seems to be a problem with the ImportJson() function and DateTime/Time columns. If I export a JSON from a datastore and import it into a different datastore (same datawindow object), the current value b...
Joe Hess Joe Hess
  1. PowerBuilder
PFC classes for pb 2019 R3
  1. Resolved
  2. Advice
  1. Last updated 3 years ago
  2.  Miguel Leeuwe replied 3 years ago
1 reply
1218 views
0 votes
To anyone who is using the PFC classes for pb 2019: Bruce has updated (today) the downloadable ZIP file with the latest changes. The changes were in "ws_objects" but not yet in the ZIP. These changes mean that - if you rely on the PBDOM included i...
Miguel Leeuwe Miguel Leeuwe
  1. PowerBuilder
MS OLE DB driver - deploying connection strings
  1. How-to
  1. Last updated 3 years ago
  2.  Chris Pollach @Appeon replied 3 years ago
3 replies
2487 views
0 votes
We've been using the old SQL Server ODBC driver (SQLSRV32) for a long, long time now, and now it's finally time to update to a new driver. We originally looked at replacing it with the ODBC Driver 17 and that seems to work well and supports all the m...
  1.  OLEDB
Aron Cox Aron Cox
  1. PowerBuilder
Issue with PBDOM_Builder creation after upgrade to 2019R3
  1. Resolved
  2. Issue
  1. Last updated 3 years ago
  2.  Roland Smith replied 3 years ago
2 replies
1225 views
0 votes
Just upgraded to 2019R3 and am working with an application migrated from 2019R2 and when I try to run (from within PB) the application crashes PB when I try to create PBDOM_Builder. Code is standard like this: PBDOM_Builder lpbdom lpbdom = CREATE ...
  1.  PowerBuilder
Matt Balent Matt Balent
  1. PowerBuilder
PB 11.5 to PB 2019R3
  1. Advice
  1. Last updated 3 years ago
  2.  Miguel Leeuwe replied 3 years ago
5 replies
1453 views
0 votes
Good morning,   I would like to connect with someone who has made the journey from PB11.5 to PB2019R3. Thank you
  1.  PowerBuilder (Appeon)
Peter Andrews Peter Andrews
  1. PowerBuilder
Json Array object string building
  1. Resolved
  2. How-to
  1. Last updated 3 years ago
  2.  Chris Pollach @Appeon replied 3 years ago
4 replies
1412 views
0 votes
Hi Gurus,   We have migrated the PB from 2017 r3 to 2019 r3. We have a Json string building function which is working fine in 2017 where as its not building the expected array string in 2019. Following is the code   Jsongenerator jga  jga = crea...
vignesh ramkumar vignesh ramkumar
  1. PowerBuilder
Re: Event firing
  1. Resolved
  2. Misc
  1. Last updated 3 years ago
  2.  Chris Pollach @Appeon replied 3 years ago
1 reply
1594 views
0 votes
Hello, Using PB 2017 R3 Got a selection window, whereby users can select a row by pressing 'ENTER' key or 'DOUBLIC CLICK' that row by mouse.    *********************************Code in ue_key event (Event Id: pbm_dwnkey) If dw_list.RowCount() 0 ...
  1.  Event
  2.  PowerBuilder (Appeon)
Sivaprakash BKR Sivaprakash BKR
  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