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
19366 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
5009 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
right click copy and paste datawindow
  1. How-to
  1. Last updated 4 years ago
  2.  Chris Pollach @Appeon replied 4 years ago
4 replies
1943 views
0 votes
Hi I expect this is a simple question but i cant find the answer ! I have a datawindow that if i right click i do not get the copy and paste window up ?  Other datawindows in my application do have copy and paste Does anyone know why or how to fi...
  1.  PowerBuilder
Andrew Davis Andrew Davis
  1. PowerBuilder
.Net DataStore & ModelMaper
  1. Resolved
  2. How-to
  1. Last updated 4 years ago
  2.  Armeen Mazda @Appeon replied 4 years ago
1 reply
1833 views
0 votes
With .NetDataStore we can send datawindows from PB and make process with insert/delete/update and some filters, But i still dont know for what it is ModelMaper.. Is there any guide/tutorial/example for ModelMapper? or diferences between this two?
Samuel Sanchez Avila Samuel Sanchez Avila
  1. SnapDevelop
Specifying the WHERE clause for update/delete not working as described
  1. Issue
  1. Last updated 4 years ago
  2.  Miguel Leeuwe replied 4 years ago
3 replies
1652 views
0 votes
Hi according to the PB Help when choosing "Key and Updatable Columns" or "Key and Modified Columns" in the "Specify Update Properties" dialog the columns marked as updatable should be included in the where clause (either all or the changed), but... ...
Arthur Hefti Arthur Hefti
  1. PowerBuilder
Datawindow Select Property Returning Empty String
  1. Resolved
  2. Issue
  1. Last updated 4 years ago
  2.  Olan Knight replied 4 years ago
4 replies
1773 views
0 votes
I'm accessing an NVO method that accepts a datawindow as an argument. The NVO uses DESCRIBE to retrieve the select statement. I tried to use a datawindow variable instead of dropping a datawindow control onto the window. However, Describe("datawindow...
Joe Hess II Joe Hess II
  1. PowerBuilder
Crete PBL's from TFS source
  1. How-to
  1. Last updated 4 years ago
  2.  Pedro Lucas replied 4 years ago
4 replies
1727 views
0 votes
Hi there!Here in my company we have a round 50+ different systems.Let's suppose I have to make a change in one of them. If I have the PBL's in my PC = no problem, just connect to TFS and do a GLV... But what if I don't have them? That's what we do to...
Pedro Lucas Pedro Lucas
  1. PowerBuilder
PB19 connection to 18c - TNS:no listener
  1. Resolved
  2. Issue
  1. Last updated 4 years ago
  2.  Chris Pollach @Appeon replied 4 years ago
3 replies
2290 views
0 votes
This is almost a verbatim repeat of a question asked a year ago for which I didn't see a conclusive answer. I finished testing two migrations with Oracle 9 and am now ready to test the applications with Oracle 18c. My understanding is that PB19 supp...
  1.  Database Profile
  2.  Oracle
  3.  PowerBuilder
Kelly Amott Kelly Amott
  1. PowerBuilder
Datawindow Converter - Error: Index was outside the bounds of the array.
  1. Resolved
  2. Issue
  1. Last updated 4 years ago
  2.  Logan Liu @Appeon replied 4 years ago
1 reply
1938 views
0 votes
Hi - I am receiving an "Error: Index was outside the bounds of the array." when converting a datawindow that uses a stored procedure with 3 parameters to a C# Model.  I believe I tracked down the issue to my retrieval arguments. In my use of this sto...
Tony Fahlberg Tony Fahlberg
  1. SnapDevelop
Different page layouts in Print Preview and PDF
  1. How-to
  1. Last updated 4 years ago
  2.  Michael Kramer replied 4 years ago
1 reply
1807 views
0 votes
Hello, What I've been noticing from time to time for quite some time is an issue in how datawindows work with PDF printers (I saw it with Free PDF in Win7, Microsoft Print to PDF in Win10, Amyuni PDF Converter in both Windows versions, probably othe...
  1.  DataWindow
  2.  PowerBuilder
  3.  Print
Konstantin Goldobin Konstantin Goldobin
  1. PowerBuilder
Which official PowerBuilder version supports Oracle 18c
  1. Resolved
  2. Advice
  1. Last updated 4 years ago
  2.  Michael Kramer replied 4 years ago
2 replies
1873 views
0 votes
Hi Appeon team,   Currently we are using the version Appeon PowerBuilder 2017 R3 Build 1880 with Oracle 12c. Recently Our company planning to upgrade oracle 12c to Oracle 18c. I came to know from my friends that Appeon new release supports Oracle...
Aaron Anbu Johan Abraham Aaron Anbu Johan Abraham
  1. PowerBuilder
Powerbuilder list files in directories and subdirectories
  1. Resolved
  2. How-to
  1. Last updated 4 years ago
  2.  Larry Peters replied 4 years ago
2 replies
3506 views
0 votes
Hi, Can anyone point me at code which would recursively read files in directories as well as sub-directories. Recursion is necessary but I need a kick-start... TIA Larry
  1.  PowerBuilder
Larry Peters Larry Peters
  1. PowerBuilder
Client server PB 2019 web service
  1. How-to
  1. Last updated 4 years ago
  2.  selvam G replied 4 years ago
3 replies
2146 views
0 votes
Hi We have migrated our client server application to PB 2019. For our new project ,would like to consume a web service. Web service proxy wizard is not available anymore in PB 19. Am I missing something? How do we consume web service in PB 2019 ...
selvam G selvam G
  1. PowerBuilder
How to send Exe parameters using batch file ?
  1. Resolved
  2. How-to
  1. Last updated 4 years ago
  2.  Michael Kramer replied 4 years ago
3 replies
15905 views
0 votes
Environment : PB2017 R3 , Windows 10  Batch file has the following command to open "abc.exe" executable from "destination" folder  start "" "%destination%\abc.exe" "Parm1" But the Parm1 is not passed to application, although the Run command works...
  1.  .EXE
  2.  Batch
  3.  Command Line
  4.  Parameter
Nasir Ahmad Nasir Ahmad
  1. PowerBuilder
PD Web service call Error
  1. How-to
  1. Last updated 4 years ago
  2.  Mangutha replied 4 years ago
3 replies
1747 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
1643 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
2435 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
2675 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
3839 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
2216 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
1439 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
1633 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

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