Featured Questions

Q&A Forum Tip: Including Source Code in Your Question
  1. Advice
  1. Last updated 2 years ago
  2.  Tjafzfa Gsjsf replied 4 months ago
6 replies
19333 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
5003 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
Debug: How to Copy/Clipboard DataWindow/DataStore Data?
  1. Resolved
  2. How-to
  1. Last updated 5 years ago
  2.  Stuart Macandrew replied 5 years ago
2 replies
2546 views
0 votes
Hi all It's some time ago (PB 9 or 10)... It was possible to put the data of a datastore/datawindow into a clipboard during the debug-modus using a statement like this in the watch tab:  clipboard(ids_lv_gruppen_belegungen.describe("Datawindow.data...
Gzim Ramizi Gzim Ramizi
  1. PowerBuilder
non-visual .Net assemblies consumed in PowerBuilder
  1. How-to
  1. Last updated 5 years ago
0 replies
2167 views
0 votes
Hello, Has any consideration or alternative approaches been discussed by the Appeon folks to provide functionality within the PowerBuilder IDE to consume 3rd party .Net assemblies like First DataBank (https://www.fdbhealth.com/solutions/integration-...
  1.  .NET Assembly
Gregory Rusak Gregory Rusak
  1. PowerBuilder
Converting a blob to a string
  1. Resolved
  2. How-to
  1. Last updated 5 years ago
  2.  Chris Pollach @Appeon replied 5 years ago
1 reply
4054 views
0 votes
Hello i have a source text file with ansi encoding written using Macintosh (CR) containing a sequence of EOT,EOT NUL characters every 1024 bytes. I need to read this file and convert it to a string. I tried to open it in stream mode, and used the fil...
Simone Olianti Simone Olianti
  1. PowerBuilder
Case Sensitive in PB17
  1. How-to
  1. Last updated 5 years ago
  2.  Chris Pollach @Appeon replied 5 years ago
1 reply
2331 views
0 votes
Hi all,   Just find one issue, when we migrate the PB2012 to PB17, the code should not be case sensitive. But with the new version, there occurs some runtime error if we not keep same case in the code. For example, we initail the variable 'Test', ...
Sally D Sally D
  1. PowerBuilder
Transaction's DBHandle() yields DBError
  1. Issue
  1. Last updated 5 years ago
  2.  Roland Smith replied 5 years ago
1 reply
2608 views
0 votes
Hello, Trying to check if a transaction object is connected to a database, I'm calling its DBHandle() function. When the objects is not connected, this call yields the transaction object DBError event. How can this be worked around? PB 12.5.1 b 459...
  1.  PowerBuilder
  2.  Transaction
Konstantin Goldobin Konstantin Goldobin
  1. PowerBuilder
Printing Cheque - Custom Paper Size
  1. Resolved
  2. How-to
  1. Last updated 5 years ago
  2.  Sivaprakash BKR replied 5 years ago
2 replies
3939 views
0 votes
Hello, PB 2017 R3 Need to print Cheque from Powerbuilder, with customer paper size:  Width = 7.99 inch, Length / Height : 3.70 inch Tried: Created a datawindow, with required fields including a picture field.  Picture field is to display the imag...
  1.  NativePDF
  2.  PowerBuilder
Sivaprakash BKR Sivaprakash BKR
  1. PowerBuilder
PB 2017 Textcontrol Active-X
  1. Issue
  1. Last updated 5 years ago
  2.  Mark Lee @Appeon replied 5 years ago
4 replies
2218 views
0 votes
Since the internal RTF-Control of PB 2017 ist not usable, we purchased the Active-X version from Textcontrol. Everything works fine, except for the datawindow-control. As soon as the column gets the focus, word-wrap occures at about 50% of the lengt...
Thomas Dietrich Thomas Dietrich
  1. PowerBuilder
Are there other methods of being able to run an Application build and not be having to save all your PBL files to the remote repository?
  1. How-to
  1. Last updated 5 years ago
  2.  Phil Wallingford replied 5 years ago
2 replies
2668 views
0 votes
  Ideally, we would like to be able to do the following: Track all of our objects that exist in the ws_objects folder to source control (Bitbucket) We typically include PBL files in our .gitignore file so they would never be committed to our r...
  1.  AutoCompiler
  2.  Git
  3.  PBL
  4.  PowerBuilder
  5.  PowerBuilder (Appeon)
Peter Huynh Peter Huynh
  1. PowerBuilder
Will a PB7 application run on Windows 2012R2 or Windows 2016 Server?
  1. Misc
  1. Last updated 5 years ago
  2.  Roland Smith replied 5 years ago
3 replies
2075 views
0 votes
Will an application that was developed and compiled (built) in PowerBuilder 7 run on a Windows 2016 server?  Will it run on Windows Server 2012R2?  EXPLANATION: I have a client running an application that was developed and compiled with PowerBuilder...
Jon Stoller Jon Stoller
  1. PowerBuilder
Unexpected behavior when runtime dlls are missing
  1. Issue
  1. Last updated 5 years ago
  2.  Chris Pollach @Appeon replied 5 years ago
1 reply
1934 views
0 votes
When pbvm170.dll is missing I get an error message (dll missing).Now I tried the JsonGenerator feature of PB2017R3 but forgot to deploy the pbjson170.dll. I got no error message but every call to JsonGenerator returned -1. Why do I get no correspondi...
Bernhard Stoeter Bernhard Stoeter
  1. PowerBuilder
Encryption Dynamic LIbrary Error, Base64 Encoding
  1. Resolved
  2. Issue
  1. Last updated 5 years ago
  2.  Joe Hess replied 5 years ago
3 replies
2913 views
0 votes
Every now and then, I receive an error using Base64Encode. The message is "Please make sure that the encryption dynamic library has already existed." The code is below, offending line in bold. This message does not appear to come from a thrown except...
Joe Hess Joe Hess
  1. PowerBuilder
PDFs are being saved with wrong data
  1. How-to
  1. Last updated 5 years ago
  2.  Chris Pollach @Appeon replied 5 years ago
1 reply
1734 views
0 votes
I am using PowerBuilder 2017.  The database is MS SQL Server 2016.  My application has a function that creates a PDF with the following code: ls_folderfile = "\\APPSERVER\PDF\picklist870024818111309365604.pdf"    adw_rpt.Object.DataWindow.Export.PD...
  1.  PDF
Jon Stoller Jon Stoller
  1. PowerBuilder
Application Slowness when printers are working slow
  1. Advice
  1. Last updated 5 years ago
  2.  Balu Krishnasamy replied 5 years ago
2 replies
2275 views
0 votes
Hello - I've been hearing this strange issue from my support that the application is slowing down drastically when it tries to open up certain windows especially when the printers work slowly (it'd pause anywhere from 10s to 2m) trying to reach the p...
Balu Krishnasamy Balu Krishnasamy
  1. PowerBuilder
where I can download "PostgreSQL Native Drive" (for PostgreSQL version 10.5)
  1. Resolved
  2. How-to
  1. Last updated 5 years ago
  2.  Chris Pollach @Appeon replied 5 years ago
4 replies
1905 views
0 votes
Greetings., From where I can download "PostgreSQL Native Drive" (for PostgreSQL version 10.5) .  Installed Appeon Powerbuilder 2017, but not showing in the connection cache.   ref. https://www.appeon.com/support/documents/appeon_online_help/2016/...
Antony Xavier Antony Xavier
  1. PowerBuilder
Not connecting "postgre" database from "Powerserver web"
  1. Resolved
  2. Issue
  1. Last updated 5 years ago
  2.  Kai Zhao @Appeon replied 5 years ago
3 replies
1917 views
0 votes
Dears., I am trying to connect "postgre" database from "Powerserver web" thru ODBC but can't. From PowerBuilder it is working fine. I checked in "Error Logs" in the powerserver showing "[Application name=PFA System,conn cache=PFA]key=value argument ...
Pulickal Antony Pulickal Antony
  1. PowerServer 2020 or older (Obsolete)
timeframe for adding encryption to powerserver
  1. Misc
  1. Last updated 5 years ago
  2.  Chris Pollach @Appeon replied 5 years ago
1 reply
1623 views
0 votes
PS 2018 has most of new features of PB 2017R3 except for encryption and OAuth. Anytime frame for these, especially encryption? for both web and mobile The rest API's i need to access require encryption and hashing, and i will only have 1/2 of the ...
mike S mike S
  1. PowerServer 2020 or older (Obsolete)
.Net assembly web service security
  1. How-to
  1. Last updated 5 years ago
  2.  Armeen Mazda @Appeon replied 5 years ago
2 replies
1781 views
0 votes
Hi all, We now use PB2017R3 to migrate the PB12, using .net assembly as webservice to replace the EA server. One concern is that the security issue about the webservice. Do you have any good suggestion about the web service security in PB?
Sally D Sally D
  1. PowerBuilder
PowerServer Web - Are OUTPUT Parms Supported for MSS RPC?
  1. Resolved
  2. How-to
  1. Last updated 5 years ago
  2.  Tom Peters replied 5 years ago
6 replies
2122 views
0 votes
Good Day! Based on what I see in the community and the docs, PowerServer Web does support OUTPUT parameters for SQL Server. However, my RPC does NOT work when depoyed to PowerServer, yet is works just fine in PB 2017. Same source... RPC Declaration...
  1.  PowerServer
Tom Peters Tom Peters
  1. PowerServer 2020 or older (Obsolete)
How to enable Pb Translation Toolkit
  1. How-to
  1. Last updated 5 years ago
  2.  Chris Pollach @Appeon replied 5 years ago
2 replies
2468 views
0 votes
Hi, I am trying to translate Pb application Spanish language to english. How to enable to use Pb translation tool in my current small application. Could you please advice or share sample code for more help .   Thanks,  
Mariappan Balakrishnan Mariappan Balakrishnan
  1. PowerBuilder
Wide Group Header in Grid Datawindow
  1. How-to
  1. Last updated 5 years ago
  2.  Chris Pollach @Appeon replied 5 years ago
1 reply
1831 views
0 votes
Hi everyone I've got a grid datawindow with several rather narrow columns. I'd like to have a group header that's wider than the columns and basically ignores the grid. (see example from Excel) I've tried putting the control in the group header i...
  1.  DataWindow
Markus Eckert Markus Eckert
  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