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
22137 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
5375 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
Using the Microsoft Text Driver ODBC driver to read text files
  1. Resolved
  2. How-to
  1. Last updated 3 years ago
  2.  Steen Jakobsen replied 3 years ago
1 reply
5105 views
2 votes
I need to read some data from tab-separated text files with a row of column headers, where I know that certain column names will always be there, but don't know whether they will always be in the same order, or what other columns might be there. So l...
  1.  ODBC
  2.  PowerBuilder
  3.  Text
  4.  DataStore
Daniel Vivier Daniel Vivier
  1. PowerBuilder
PS2021 Questions
  1. How-to
  1. Last updated 3 years ago
  2.  Milton Jiménez replied 3 years ago
4 replies
1235 views
0 votes
Hi Friends, I am trying PS2021, the lifetime of a session, how could I control it?because the service falls(api) if it is not used in a short time The system connects with the same transact SQLCA to several databases, dynamically, as it would be do...
Milton Jiménez Milton Jiménez
  1. PowerServer
Powerbuilder and Security
  1. Resolved
  2. Misc
  1. Last updated 6 years ago
  2.  Christophe Dufourmantelle replied 3 years ago
4 replies
5141 views
0 votes
Does anyone know of any tools that might be able to analyze a Powerbuilder classic app for potential security vulnerabilities?  Sort of like an HP Fortify for native Powerscript?  I saw an answer to a similar question that it may be possible with cer...
  1.  PowerBuilder
  2.  Security
Jeff Nesler Jeff Nesler
  1. PowerBuilder
Check the latest valid version in Server IIS of powerclient from an application
  1. How-to
  1. Last updated 3 years ago
  2.  Armeen Mazda @Appeon replied 3 years ago
2 replies
1285 views
0 votes
Is it possible to determine which is the latest valid version supported on the IIS Server of my application installed in powerClient mode? This by means of a query in execution time of the application. Thanks Marcelo
Marcelo Peñailillo Marcelo Peñailillo
  1. PowerBuilder
PB2019 R3 2703 PBDOM document has no root element?
  1. Resolved
  2. Issue
  1. Last updated 3 years ago
  2.  Armeen Mazda @Appeon replied 3 years ago
3 replies
1837 views
0 votes
So I have the following XML string: ResultStatusReplyStatus1/ReplyStatusReplyTextSuccess/ReplyText/StatusData //Result With the following PowerScript I create a PBDOM document from it: PBDOM_Builder idom_Builder //instance variable on nvo // me...
  1.  PBDOM
  2.  XML
Matt Balent Matt Balent
  1. PowerBuilder
SoapConnection CreateInstance method failing in 2019R3
  1. Resolved
  2. Issue
  1. Last updated 3 years ago
  2.  Armeen Mazda @Appeon replied 3 years ago
4 replies
1599 views
0 votes
Another question on the obsoleted (in 2019R3) SoapConnection object.  Since I migrated to 2019R3 the CreateInstance method is failing with a "Bad runtime function reference" error.  Since I've not worked with this since PB version 11 or so I was wond...
Matt Balent Matt Balent
  1. PowerBuilder
PB 2021 and 2019 R3: Reopen workspace on startup.
  1. How-to
  1. Last updated 3 years ago
  2.  Andreas Mykonios replied 3 years ago
3 replies
1375 views
0 votes
Testing PB 2021 Beta. I noticed that after closing PB 2021, if I launch PB 2019 R3 it attempts to load the most recent workspace that I used in PB 2021. If I select a different one, and then if I close PB 2019 R3 and launch PB 2021 it attempts to lo...
Andreas Mykonios Andreas Mykonios
  1. Beta Testing
Refresh workspace outside PB IDE
  1. How-to
  1. Last updated 3 years ago
  2.  Armeen Mazda @Appeon replied 3 years ago
1 reply
1672 views
1 vote
Currently I'm working on a desktop application on PB19 R3, it is connected over GIT. To apply any change made on code to PBL is needed to "refresh", like this attached image. I need to build this application outside IDE, but I still need to perform ...
juliano prado juliano prado
  1. PowerBuilder
How to find the object that caused the DBERROR?
  1. How-to
  1. Last updated 3 years ago
  2.  Olan Knight replied 3 years ago
3 replies
1355 views
0 votes
PB2019R3, b2703PostgreSQL database from Enterprise DB, v12.5Windows 64 bit platform32 bit, PFC-based applicationI'd like to grab the name of the object when a database error occurs:   1) Embedded SQL = the name of the current window, tab, or tabpage ...
Olan Knight Olan Knight
  1. PowerBuilder
how to open password protected word file in ole
  1. Resolved
  2. How-to
  1. Last updated 3 years ago
  2.  Mark Goldsmith replied 3 years ago
1 reply
1678 views
0 votes
I tried iole_word.documents.open("filename", true, false, false,"passwordhere") but it fails... Environment PB17r3, office 365 pro plus...
David Vasconcelos David Vasconcelos
  1. PowerBuilder
12.6 Issue ( Citrix )
  1. Issue
  1. Last updated 3 years ago
  2.  Olan Knight replied 3 years ago
3 replies
1832 views
0 votes
All - I apologize if this isn't the forum.  Hard finding answers for 12.6 related issues these days. We currently have a 12.6 application running on Citrix box ( 2016 server ). We have ONE user that recently switched to a new windows 10 laptop. W...
  1.  Citrix
  2.  PB Classic
John Brown John Brown
  1. PowerBuilder
Unable to display Chart using PBUltimateSuite
  1. Resolved
  2. Issue
  1. Last updated 3 years ago
  2.  Brad Wery replied 3 years ago
2 replies
1599 views
0 votes
We are using PBUltimateSuite.  Creating the graph went fine, however when the application is run we get the following error Unresolvable external w_pbwc_graph_painter when linking at line 1 in ue_init event of object uov_chart_js_datawindow. There ...
Joon Choi Joon Choi
  1. PowerBuilder
Calling a stored procedure as source for a datawindow Powerserver
  1. Issue
  1. Last updated 3 years ago
  2.  Armeen Mazda @Appeon replied 3 years ago
1 reply
992 views
0 votes
Hello, I have a stored procedure that populates a datawindow.  Works in Powerbuilder but not in Powerserver.  I'm on 2019 R2.  The message I get is: Failed to Analyse the Stored Procedure Syntax. due to input string was not in correct format. My sp...
William Nevins William Nevins
  1. PowerServer
issue adding rows to a nested report, with multiple master datawindows.
  1. How-to
  1. Last updated 3 years ago
  2.  Chris Pollach @Appeon replied 3 years ago
2 replies
1822 views
0 votes
I'm working on a nested report which has multiple masters and details. By using a datastore I can insert rows into the datastore (which uses the same datawindow as the nested report). I can copy the data from the datastore to the first nested repor...
Mike Trainor Mike Trainor
  1. PowerBuilder
PB 2019 R3 DW print error: "Error printing on . The printer couldn't print"
  1. Issue
  1. Last updated 3 years ago
  2.  Mark Goldsmith replied 3 years ago
1 reply
2586 views
0 votes
A strange new issue has come up since I migrated to PB 2019 R3. Unfortunately for me, two customers discovered this in production after I upgraded their applications. It seems that the DataWindow Print() method fails with certain printer/driver comb...
Ronnie Po Ronnie Po
  1. PowerBuilder
Error opening an Excel file with Windows Script
  1. Resolved
  2. How-to
  1. Last updated 3 years ago
  2.  Raymond Longoria replied 3 years ago
2 replies
1747 views
0 votes
I migrated an application from 8.0 to 2019 R3. I found a windows script command that is supposed to open an Excel file but it is not working. Does this need a syntax fix or is there a better way to open the file? The following is the code:   wsh = ...
Raymond Longoria Raymond Longoria
  1. PowerBuilder
Scrolling with the mouse while on the script panel
  1. Issue
  1. Last updated 3 years ago
  2.  Chris Pollach @Appeon replied 3 years ago
4 replies
1961 views
0 votes
Updated to PB 2017 R3 1951.  Now my scroll does not work using the mouse when on the script panel.  Has anyone run into this?
John Purugganan John Purugganan
  1. PowerBuilder
RestClient Submit method - does syntax 1 send all the dw buffers?
  1. Resolved
  2. Advice
  1. Last updated 3 years ago
  2.  Chris Pollach @Appeon replied 3 years ago
1 reply
1932 views
0 votes
I'm relatively new to using the RestClient and SnapDevelop, but things were going fine in converting our app's DB access to asp.net core web api's until I encountered an issue with the RestClient.Submit method...in particular Syntax 1,  objectname...
  1.  PowerBuilder
  2.  REST
  3.  .NET DataStore
Glenn Scamman Glenn Scamman
  1. PowerBuilder
Handling Invalid Password
  1. Issue
  1. Last updated 3 years ago
  2.  Olan Knight replied 3 years ago
1 reply
1473 views
0 votes
Our app uses SQL Server, SNC connection, PB 2019 GA.   One of our customers added a trigger that emails an admin person when someone enters an invalid password. They were getting three emails at a time so they did a dbtrace and sure enough there w...
Roland Smith Roland Smith
  1. PowerBuilder
PB 11.5 crashing
  1. Resolved
  2. Issue
  1. Last updated 3 years ago
  2.  Ashutosh Varshney replied 3 years ago
2 replies
1737 views
0 votes
Hello everyone. I am working with PB 11.5. The IDE crashes whenever I open the datawindow painter. I did a reinstall as well but that did not help. Any ideas how to get it working again? Here is the entry from the application event log:  Log Name: ...
Ashutosh Varshney Ashutosh Varshney
  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