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
PD Web service call Error
  1. How-to
  1. Last updated 4 years ago
  2.  Mangutha replied 4 years ago
3 replies
2025 views
0 votes
Built web service with below transaction Object on window 10 machine which has SQL native client 11 Installed  SQLCA.SERVERNAME = 'XXXXXX'SQLCA.DATABASE = 'DDDDDDDDDD'SQLCA.DBMS = "SNC SQL Native Client(OLE DB)"SQLCA.LogPass = '********'SQLCA.LogId ...
Mangutha Mangutha
  1. PowerBuilder
How to iterate a json result with many records as an array (seems to not have a root)
  1. Resolved
  2. Advice
  1. Last updated 4 years ago
  2.  Alfredo Santibanez replied 4 years ago
2 replies
1833 views
0 votes
Hi, I am trying to read data records returned from a web service in json format.  It contains a complex structure and starts as an array.  Please find bellow a sample text.   I need to read all records and from each record find some values. ls_Er...
Alfredo Santibanez Alfredo Santibanez
  1. PowerBuilder
c# delegate classes
  1. Resolved
  2. Misc
  1. Last updated 4 years ago
  2.  Michael Kramer replied 4 years ago
3 replies
2664 views
1 vote
Hi all One of the features I like most about PB19 R2 is the support .net assemblies. The C# class importer is a very useful tool.  I noticed that C# events are not yet supported. The message I am receiving is "Delegate classes are not supported". ...
  1.  .NET Assembly
  2.  C#
  3.  PowerBuilder (Appeon)
  4.  C# Class Importer
Yiannis Papadomichelakis Yiannis Papadomichelakis
  1. Beta Testing
How to get Font family from Font
  1. Resolved
  2. How-to
  1. Last updated 4 years ago
  2.  Miguel Leeuwe replied 4 years ago
4 replies
3035 views
0 votes
Hi, I'm listing all fonts installed on a pc in a dropdown. If a user chooses a font, I want to apply that to a dw column. To do so, I need to set the "font.face" and the "font.family" (values 0 - 6, "Modern", "DontCare", "Roman", "Swiss", etc.) wi...
Miguel Leeuwe Miguel Leeuwe
  1. PowerBuilder
MSOLEDBSQL Supported?
  1. How-to
  1. Last updated 5 years ago
  2.  Chris Pollach @Appeon replied 4 years ago
4 replies
4051 views
2 votes
Hi Appeon & community,   Appeon lists support for the OLEDB driver for MSSQL in PB 2017+. https://www.appeon.com/developers/roadmap/support-sql-server-2017.html   The third generation of OLEDB drivers, and only one currently supported by Microso...
Brian Twardzik Brian Twardzik
  1. PowerBuilder
Reading Data From Excel File Contain Number of Sheets
  1. How-to
  1. Last updated 4 years ago
  2.  Luiz Ribeiro replied 4 years ago
2 replies
2482 views
0 votes
Hello Team, I am using PowerBuilder 2017 R3 version. As per the business requirement in my project, data will load from excel and display it in screen. But I am finding problem to read data from each sheet around 5-sheets in the same excel file.   ...
Ashok Pattanaik Ashok Pattanaik
  1. PowerBuilder
TRY CONNECT; CATCH error can't be catched
  1. Issue
  1. Last updated 4 years ago
  2.  John Fauss replied 4 years ago
3 replies
1609 views
0 votes
Hi PB users, Migrating to x64 our application, I m facing big Crash if my client is wrong configured. (No ORACLE_HOME env variable). CONNECT; is crashing. And I'm not able to catch the error wit Try... CATCH.   gf_info_64 ("Just Before Connect")...
Pierre DETE Pierre DETE
  1. PowerBuilder
Amazon Cloud AWS and mailSession MAPI
  1. How-to
  1. Last updated 4 years ago
  2.  David Peace (Powersoft) replied 4 years ago
1 reply
1800 views
0 votes
Hi PB users, I'm not familiar with the AMAZON AWS subject and our customers are wondering how they will be able to send emails from our application on AWS. At the moment, on Windows, we have two methods: PB MailSession (MAPI) and SMTP. Do you think...
Pierre DETE Pierre DETE
  1. PowerBuilder
Possible bug when exporting XML
  1. Issue
  1. Last updated 4 years ago
  2.  Roland Smith replied 4 years ago
2 replies
1465 views
0 votes
I have this issue in PB 10.5 and PB 2019. My base DataStore object has a function with the following line of code: Return this.Object.DataWindow.Data.XML   The output has an extra CRLF after the xml header line and another extra one at the very e...
Roland Smith Roland Smith
  1. PowerBuilder
Ribbonbar menu and mdi application
  1. How-to
  1. Last updated 4 years ago
  2.  Brad Wery replied 4 years ago
1 reply
2150 views
0 votes
Hi. In the Ribbonbar tutorial ( https://docs.appeon.com/appeon_online_help/pb2019r2/pbug/ch13s03.html#_Add_the_RibbonBar ), it says that you must uncheck the control menu of the sheet windows. How does the user manage the size of sheets windows (ma...
Thierry Garrigues Thierry Garrigues
  1. Beta Testing
How to validate XML against XSD file
  1. Resolved
  2. How-to
  1. Last updated 4 years ago
  2.  Jan Kopal replied 4 years ago
3 replies
2548 views
0 votes
Hello, is it possible to validate XML against XSD file i Powerbuilder? I have XML string (of XML file) and local copy of XSD file. I found XMLParseFile and XMLParseString functions, but i don't know how to tell which XSD file to use... Thank You, ...
Jan Kopal Jan Kopal
  1. PowerBuilder
Grid-Datawindow: width.autosize does not change width-property
  1. Issue
  1. Last updated 4 years ago
  2.  René Ullrich replied 4 years ago
2 replies
1890 views
0 votes
Hi, we generate grid-dw-syntax dynamicly.The width of the columns is 200 with width.autosize=1. All works fine so far the autosize changes the width of the column. But now we want activate the powerfilter on that datawindow. (Powerfilter is a gr...
Tobias Roth Tobias Roth
  1. PowerBuilder
Where are the Fonts?
  1. Resolved
  2. How-to
  1. Last updated 4 years ago
  2.  David Flory replied 4 years ago
4 replies
1817 views
0 votes
I have a block of datawindows that are formatted as IRS forms, primary among which is a nasty little piece of work known as the partnership Schedule K-1.  This schedule requires the use of the font Arial Narrow at 7pts. The datawindows I ported over...
David Flory David Flory
  1. PowerBuilder
Cannot open the working copy due to Git version incompatibility.
  1. Issue
  1. Last updated 4 years ago
  2.  Gene Kanten replied 4 years ago
2 replies
1867 views
0 votes
I'm getting this error when opening a workspace on a local feature branch in the PowerBuilder IDE (PB 2017 R3). After reviewing many of the Git questions/issues it appears that the IDE is hardwired to only look at the "master" branch. Is that correc...
  1.  Git
Gene Kanten Gene Kanten
  1. PowerBuilder
Consume Rest API
  1. Resolved
  2. How-to
  1. Last updated 4 years ago
  2.  mathews rutto replied 4 years ago
5 replies
1814 views
0 votes
Hello, how can i consume Rest API given that i have to pass API key and header request. I want to retrieve the response in a datawindow. Thank you in advance.
mathews rutto mathews rutto
  1. PowerBuilder
Powerbuilder 2017 R3 en Window 10
  1. Advice
  1. Last updated 4 years ago
  2.  Francisco Javier Vizueta Logroño replied 4 years ago
2 replies
1825 views
0 votes
He instalado PowerBuilder 2017 R3 en una maquina con window 10 y al registrar el usuario  me aparece el siguiente mensaje de error: Alguien me puede ayudar, qué puede ser?
Francisco Javier Vizueta Logroño Francisco Javier Vizueta Logroño
  1. PowerBuilder
Need SQL Anywhere patch v8.0.3 for SA Studio 8.0
  1. Resolved
  2. Issue
  1. Last updated 4 years ago
  2.  Michael Ray replied 4 years ago
2 replies
2306 views
0 votes
Summary: server down, lost files. Details: Trying to recreate production environment for database network server. Have the purchased disc for SQL Anywhere v8.0 and the patch for v8.0.2, but need patch for v8.0.3. Can anyone direct me or provide the ...
  1.  Database
  2.  SQL Anywhere
Michael Ray Michael Ray
  1. PowerBuilder
PB Migrating from DB2 v11.1.1.1 to SQL Server 2016
  1. How-to
  1. Last updated 4 years ago
  2.  mike S replied 4 years ago
3 replies
2458 views
0 votes
We  are thinking of migrating our PB Classic application (2017 build 1769) from DB2 v11 to Microsoft SQL Server 2016. Currently we connect to DB2 via ODBC. Any suggestions on what to do? Are they any tools that can help? Will native connection be bet...
  1.  DB2
  2.  PowerBuilder (Appeon)
  3.  SQL Server
Kwadwo Boahene Kwadwo Boahene
  1. PowerBuilder
Building Help Screens for Windows
  1. Resolved
  2. How-to
  1. Last updated 4 years ago
  2.  James Medick replied 4 years ago
4 replies
2198 views
0 votes
I would like to create and display a simple help screen (window) for each window in my application, e.g., press F1 and display the appropriate help window for the application current window.  Is there a preferred method for this?  Or is it simply to...
James Medick James Medick
  1. PowerBuilder
switching dataobjects in a datawindow not working in runtime
  1. Resolved
  2. Issue
  1. Last updated 4 years ago
  2.  Roland Smith replied 4 years ago
2 replies
1807 views
0 votes
I have several programs where I switch the dataobject in a datawindow back and forth depending on how the users want to see the data by using the following code example. dw_main.DataObject = 'd_by_shift' Then I run a reset and go on my merry way. T...
Jason Peck Jason Peck
  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