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
22132 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
5373 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 the Catalog Tables Installed in a PostgreSQL Database?
  1. Resolved
  2. How-to
  1. Last updated 4 years ago
  2.  Kai Zhao @Appeon replied 4 years ago
3 replies
1714 views
0 votes
PB2019R2, b2353Windows 64 bit platformPostgreSQL database hosted on a remote serverAs per my last post, I got the DSN created for the new "dev12c" PostgreSQL database. I then created a Database Painter Profile for the new database.... and it works! H...
Olan Knight Olan Knight
  1. PowerBuilder
Datawindow Control Name/Tag
  1. Resolved
  2. How-to
  1. Last updated 4 years ago
  2.  John Fauss replied 4 years ago
5 replies
1458 views
0 votes
I'm using PB 2017R2 and PFC.  The window has a dw control to have as the parent.  In code, an array of dw contols are inherited from the dw on the window.  I've assigned a tag to each of these controls. In the itemchanged event of the dw parent, I wa...
Pete Yankovich Pete Yankovich
  1. PowerBuilder
Unstable IDE
  1. Issue
  1. Last updated 4 years ago
  2.  Olan Knight replied 4 years ago
3 replies
1768 views
0 votes
I'm having a problem with the PowerBuilder IDE. If I open PB and run the selected target (of 2 targets) in the local workspace, the application starts and runs OK. But if I close the application and then right click the other target (with the intent...
  1.  Crash
  2.  IDE
Michael Connell Michael Connell
  1. PowerBuilder
Deployment of 2019 R2 Applications into same directory as 12.6 Applications
  1. Resolved
  2. How-to
  1. Last updated 4 years ago
  2.  Daniel Mullings replied 4 years ago
4 replies
1526 views
0 votes
We would like to start building our applications in 2019 R2.    Our apps are currently in PB 12.6 Build 3506 Enterprise.   We wanted to do a gradual switch over so that 12.6 apps and 2019 apps could both be released to the clients and both run.   I'v...
Kelly Wonderly Kelly Wonderly
  1. PowerBuilder
Error - Invalid DataWindow row/column specified
  1. Issue
  1. Last updated 4 years ago
  2.  Kevin Ridley replied 4 years ago
3 replies
5888 views
0 votes
Hello,  I've built an infomaker page in an effort to display elements in the front end of gui system. Using a query and updating all fields to be no edit.  Code pulls a handful of elements from a series of joined tables with the where clause ..  s...
  1.  DataWindow
  2.  Error
  3.  InfoMaker
  4.  PowerBuilder (Appeon)
Lisa Rudnitsky Lisa Rudnitsky
  1. InfoMaker
Use of HasExceptionThrown() with PBNI
  1. Resolved
  2. Issue
  1. Last updated 4 years ago
  2.  John Fauss replied 4 years ago
2 replies
1598 views
0 votes
Hi. I wrote this simple function in PB for testing: public function long uof_square (long al_arg) throws exception;exception ee = create exceptione.Text = "test"throw ereturn al_arg * al_argend function As you can see, it will always throw an exce...
Isidro Reina Monsó Isidro Reina Monsó
  1. PowerBuilder
Commit assets with git integration
  1. How-to
  1. Last updated 4 years ago
  2.  Georg Brodbeck replied 4 years ago
3 replies
1483 views
0 votes
Hi there We are planning to use the git integration of Appeon PowerBuilder, which works perfectly for source and PBLs. Problem: PowerBuilder just ignores all assets like images, icons, external components etc. Of course, we could use tortoise git t...
  1.  Git
  2.  PowerBuilder (Appeon)
Georg Brodbeck Georg Brodbeck
  1. PowerBuilder
.Net DLL Importer Issues
  1. How-to
  1. Last updated 4 years ago
  2.  Mark Lee @Appeon replied 4 years ago
2 replies
1626 views
0 votes
I am using the .NET DLL Importer to bring a vendor's DLL into my PowerBuilder app.  Below are a couple of screen shots.  Not sure what is going on, but basically seeing two issues. 1. Several functions appear in the failed items list. Any insight ho...
Rick Domogalik Rick Domogalik
  1. PowerBuilder
Infomaker Error Connecting to SQL Server
  1. Resolved
  2. Advice
  1. Last updated 4 years ago
  2.  Armeen Mazda @Appeon replied 4 years ago
4 replies
2635 views
0 votes
Hi, I have a couple Infomaker reports that I've converted from Oracle to SQL Server. I am using SNC SQL Native Client as the connection type for both and have deployed the EXEs to my users' machines. The EXEs both work fine for me on my computer and...
  1.  Error
  2.  InfoMaker
  3.  SQL Server
Keeley Stalnaker Keeley Stalnaker
  1. InfoMaker
Displaying Last Characters in Datawindow
  1. How-to
  1. Last updated 4 years ago
  2.  John Fauss replied 4 years ago
3 replies
1663 views
0 votes
I have a 1 row datawindow that contains various lengths of text depending on the query.  The users want to see the last entries upon the open of the datawindow.  I found the following example in your HELP system that I think will solve the problem: ...
Gary Cooper Gary Cooper
  1. PowerBuilder
Startup of PB app crashes - from explorer, but not command prompt
  1. Advice
  1. Last updated 4 years ago
  2.  Olan Knight replied 4 years ago
4 replies
2032 views
0 votes
Here is a strange one.  I have a PB 2017 R3 desktop app which fails when trying to launch it with a double click from Explorer.  However when I launch it from a command prompt it works correctly.  This was not always the case with this App, so obviou...
  1.  .EXE
  2.  Client/Server
  3.  PowerBuilder
Mark Lundell Mark Lundell
  1. PowerBuilder
How to create an ODBC DSN for PostgreSQL Database?
  1. Resolved
  2. How-to
  1. Last updated 4 years ago
0 replies
2062 views
0 votes
Update:   Welp...stupid me. the name of the CONNECTION used in pgAdmin for the database was "dev12c - Pg", but the actual name of the database is "dev12c".    I changed the database name and the connection worked.Olan ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~...
Olan Knight Olan Knight
  1. PowerBuilder
project build options - rebuild - incremental greyed out
  1. Resolved
  2. How-to
  1. Last updated 4 years ago
  2.  Chris Pollach @Appeon replied 4 years ago
2 replies
1952 views
0 votes
Hi can anyone help On one of my applications the project build options, incremental is greyed out, i can select the prompt for overwrite and classic style but not the incremental On other applications I can tick this.   regards and thanks in adva...
  1.  Compiler
Andrew Davis Andrew Davis
  1. PowerBuilder
Database Profile Setup issue
  1. Resolved
  2. Issue
  1. Last updated 4 years ago
  2.  Suhas Shravagi replied 4 years ago
5 replies
1698 views
0 votes
Hi,   I setup a database profile thru PowerBuilder IDE (2017 R3.) Wnen I check the "Encrypt All Results" option under Security tab (as below screen) and test the connectivity, it throws the error mentioned in second screenshot. Can you help in sort...
Suhas Shravagi Suhas Shravagi
  1. PowerBuilder
datawindow SaveAs XLSX! with column that has more than 32767 characters
  1. Issue
  1. Last updated 4 years ago
  2.  Olan Knight replied 4 years ago
1 reply
1875 views
0 votes
Hello, In PB2017R3 when you do dw.SaveAs XLSX! an there is a cell with more than 32767 characters (character size limit of Ecel's cell) - resulting .xlsx file will consider this cell unreadable in MicroSoft Excel. At the same time Open Office just t...
  1.  DataWindow
  2.  Excel
Aliaksei Hlinski Aliaksei Hlinski
  1. PowerBuilder
Es posible cargar archivo con mas de 10,000 registros en aplicación appeon web?
  1. How-to
  1. Last updated 4 years ago
  2.  mike S replied 4 years ago
2 replies
1880 views
0 votes
Hola a todos.   como puedo cargar archivo que contiene mas de 10,000 registros, a traves de una aplicacion appeon web? es posible? de no ser así, que otra alternativas debería usar para cargar un archivo con mas de 10,000 registros a traves de appe...
  1.  PowerBuilder (Appeon)
Jorge Humberto Peralta Molina Jorge Humberto Peralta Molina
  1. PowerBuilder
MDI App - auto generating sheet menu is missing in Ribbonbar
  1. Issue
  1. Last updated 4 years ago
  2.  Brad Wery replied 4 years ago
2 replies
1643 views
0 votes
  Hello, we have migrated your mdi application to use the Ribbonbar. All works fine but we are missing one thing. In the old menu there was automaticly under Window/Fenster a list of all opened sheets/windows. Is there something similar in the ribb...
Stefan Malkwitz Stefan Malkwitz
  1. PowerBuilder
PowerBuilder App Crashed - GetFileOpenName(...)
  1. Advice
  1. Last updated 4 years ago
  2.  Dennis Huynh replied 4 years ago
3 replies
1684 views
0 votes
Hi, I am currently using PowerBuilder 2017 R3 Build 1915.  The company had upgraded Windows 7 to Windows 10.  Since the upgraded there came up a strange behavior.  Every time when user tried to upload file, the app would crash between 2 - 5 minutes....
Dennis Huynh Dennis Huynh
  1. PowerBuilder
COUNT en MySQL
  1. Issue
  1. Last updated 7 years ago
  2.  Mark Lee @Appeon replied 4 years ago
5 replies
3687 views
0 votes
Buen día tengo el siguiente problema con mi gestor de base de datos(MYSQL): 1)INTEGER LI_ROWS SELECT COUNT(id_obra) INTO :LI_ROWS FROM obras_trabajador USING SQLCA;   ERROR:FUNCTION BD.COUNT does not exist. Check the Function Name Parsing an...
  1.  Build
Elvis Cardenas Elvis Cardenas
  1. PowerBuilder
Converting from MS SQL to MySQL select into variable error
  1. How-to
  1. Last updated 4 years ago
  2.  Mark Lee @Appeon replied 4 years ago
4 replies
2827 views
0 votes
I am running PB 2019 R2 build 2353.  I currently use MS SQL Server.  I am in the process of converting to MySQL version 8.0.21.  I am able to connect to the database no problem using ODBC drivers.  I converted one of the simpler applications and it c...
  1.  MySQL
  2.  PowerBuilder
Louis Arena Louis Arena
  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