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
19389 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
5025 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
DW Query mode does not like value 'In-' value in any field
  1. How-to
  1. Last updated 3 years ago
  2.  mike S replied 3 years ago
2 replies
1322 views
0 votes
Any search window in our system gets a search criteria with the DW query mode. But when a DW is in query mode I cannot specify any string value starting with 'IN-' in any field on the DW. Can anyone point out what is going on and how to solve the is...
  1.  DataWindow
  2.  PowerBuilder (Appeon)
  3.  Query
Hua Yan Hua Yan
  1. PowerBuilder
Why is this Oracle .DMP File Being Created?
  1. Resolved
  2. How-to
  1. Last updated 3 years ago
  2.  Chris Pollach @Appeon replied 3 years ago
1 reply
5961 views
0 votes
PB2019R3Oracle 12CWindows 10, 64 bit platformSummary:Anyone know why the Oracle .DMP files listed below are being generated?There does not seem to be any errors or issues with the running application.Details:I have an application that runs 24x7x365. ...
Olan Knight Olan Knight
  1. PowerBuilder
Chart JS Painter
  1. How-to
  1. Last updated 3 years ago
  2.  Olan Knight replied 3 years ago
2 replies
1447 views
0 votes
Hi Appeon Community,   Hope you guys are doing well.   We are facing a problem, we are not able to find our data window in the drop-down in Chart JS Painter. I have followed all the instructions given in the documentation It’ll be very great for ...
Sanjay Singh Sanjay Singh
  1. PowerBuilder
After PowerServer 2020 upgrade get Transaction not connected
  1. Issue
  1. Last updated 3 years ago
  2.  Chris Pollach @Appeon replied 3 years ago
5 replies
1120 views
0 votes
Just finished upgrading my PowerServer to 2020 along with MR2703.  When I clicked on my IWA runner icon, it asked me to upgrade then I get Followed by followed by and then Everything looks ok in AEM. Did I miss something in the upgrade? ...
  1.  PowerServer
William Nevins William Nevins
  1. PowerServer
PowerScript Migration tutorial
  1. How-to
  1. Last updated 3 years ago
  2.  Armeen Mazda @Appeon replied 3 years ago
3 replies
1354 views
0 votes
I'm doing the PB to C# tutorial: https://docs.appeon.com/powerscriptmigrator2019r3/PB_to_CSharp_Migrating_Re-factored_Business_Logics(NVOs)/index.html So first I have to manually create several files (controllers, services, interfaces) which the tu...
Roland Smith Roland Smith
  1. SnapDevelop
PBNI Exceptions
  1. Resolved
  2. How-to
  1. Last updated 3 years ago
  2.  Roland Smith replied 3 years ago
2 replies
989 views
0 votes
Calling PB 2019-R3 object from C++. I'm getting 'Unhandled Exception' in the error object and no exception in the C++ code. Any idea? The PowerBuilder function: public function integer of_exception (integer ai_value) throws n_cst_exception;n_cst_ex...
Roland Smith Roland Smith
  1. PowerBuilder
Oracle Number to c#
  1. How-to
  1. Last updated 3 years ago
  2.  Per Ahlander replied 3 years ago
4 replies
2643 views
0 votes
Possibly the wrong category but feel free to move if so. So i have converted some datawindow in snapdevelop. the model got some properties that are public decimai? The problem comes when some of those fields needs more decimal precision than decima...
Per Ahlander Per Ahlander
  1. .NET DataStore
retrieve Data from Model using the sqlselect attribute and paramvalues
  1. Resolved
  2. How-to
  1. Last updated 3 years ago
  2.  Tony Meißner replied 3 years ago
3 replies
1755 views
0 votes
  How can i retrieve Data from Model using the sqlselect attribute and paramvalues? I already ask a stackoverflow question; https://stackoverflow.com/questions/68129138   How can I retrieve data from my SQL-Model using the SqlSelect attribut...
  1.  .NET Core Framework
  2.  SnapDevelop
Tony Meißner Tony Meißner
  1. SnapObjects
Regarding Develop Android Application
  1. Resolved
  2. How-to
  1. Last updated 3 years ago
  2.  Armeen Mazda @Appeon replied 3 years ago
1 reply
887 views
0 votes
Hai, I purchased Appeon Powerbuilder 2021 just before a week. I am feeling a better performance and the latest technologies in the same. Special thanks to the Appeon team. I have a doubt regarding developing in the Android platform. Have any chance...
SHAMEEM KAKKAD SHAMEEM KAKKAD
  1. PowerBuilder
Error when trying to make an EJB connection.
  1. How-to
  1. Last updated 3 years ago
  2.  Chris Pollach @Appeon replied 3 years ago
2 replies
1126 views
0 votes
Is there a powerbuilder detail debug log that contains java call exceptions with stack trace info?  The jboss-client.jar is on the classpath but org.wildfly.naming.client.WildFlyInitialContextFactory class from the jar can not be instantiated. Why c...
Layne Strong Layne Strong
  1. PowerBuilder
How to suppress header on the second page
  1. How-to
  1. Last updated 3 years ago
  2.  Miguel Leeuwe replied 3 years ago
6 replies
1548 views
0 votes
Good day,   Please help...   How can I suppress the headers on the second page? so that the list of rows will occupy the header portion.   thanks in advance
Winthor Caingles Winthor Caingles
  1. PowerBuilder
View Attachments or Open File
  1. Resolved
  2. How-to
  1. Last updated 3 years ago
  2.  Chris Pollach @Appeon replied 3 years ago
2 replies
963 views
0 votes
Hi, We wish to open the file (.pdf, .xlsx, .docs etc) from Powerbuilder application. The file needs to be visible for users. OpenFile function opens the file but is not visible to users.   How can I achieve this?   Thanks, Falguni
Falguni Patel Falguni Patel
  1. PowerBuilder
SnapDevelop Connecting to MS SQL Server
  1. Resolved
  2. Issue
  1. Last updated 3 years ago
  2.  Armeen Mazda @Appeon replied 3 years ago
6 replies
1333 views
0 votes
I'm using SnapDevelop 2019R3 Build 2703. I cannot connect to MS SQL Server. I get network connectivity error and a timeout. I can connect to the same database using PB IDE on the same Wind 10 PC. I've checked that required protocols are enabled o nt...
  1.  SQL Server
  2.  SnapDevelop
David Peace (Powersoft) David Peace (Powersoft)
  1. SnapDevelop
Adding Nested Report
  1. How-to
  1. Last updated 3 years ago
  2.  Chris Pollach @Appeon replied 3 years ago
2 replies
1576 views
0 votes
I'm trying to add a subreport to a grouped report.  I added retrieval arguments to my subreport.  When I added the subreport to the grouped report, I filled in the criteria with fields from the grouped report (including the ID_Num that the report is ...
  1.  InfoMaker
Diane Royer Diane Royer
  1. InfoMaker
AES Encryption (CrypterObject) How to use PKCS7 padding?
  1. How-to
  1. Last updated 3 years ago
  2.  Armeen Mazda @Appeon replied 3 years ago
2 replies
1339 views
0 votes
I'm trying to encrypt something with AES , but i have to use PKCS7 padding. Is there a way with PB2019R3 ? 
Stefan Zierold Stefan Zierold
  1. PowerBuilder
ItemChanged event on EditMask DropDownCalendar
  1. Resolved
  2. How-to
  1. Last updated 3 years ago
  2.  Aleš Vojáček replied 3 years ago
2 replies
1406 views
0 votes
Hi all, I'm using on some fields in datawindow dropdown calendar. If I choose date from calendar then event ItemChanged on datawindow is fired, but when I type date manualy into field and tab out from that field, then ItemChanged event is not fired....
Aleš Vojáček Aleš Vojáček
  1. PowerBuilder
Cloud Application - Attachments to save to cloud or local server
  1. How-to
  1. Last updated 3 years ago
  2.  Falguni Patel replied 3 years ago
1 reply
1284 views
0 votes
Hi, We wish to save attachments to our local server for cloud deployed application. The PB application will store only path of the attachment document. How is this possible.   Kind regards, Falguni
Falguni Patel Falguni Patel
  1. PowerServer
pixel density for png/jpg/image files for datawindow printing
  1. Advice
  1. Last updated 3 years ago
  2.  Armeen Mazda @Appeon replied 3 years ago
2 replies
1136 views
0 votes
I have a user asking about the recommended DPI settings for PNG files for printing.  the png is loaded into a datawindow using either the bitmap() function in a compute or the display as picture on a column.  The datawindow is then printed to a laser...
mike S mike S
  1. PowerBuilder
FYI: Defining your Database Properties when connecting to PostgreSQL
  1. Resolved
  2. How-to
  1. Last updated 3 years ago
0 replies
827 views
2 votes
PB2019R3PostgreSQL v12 database Summary:   Ensure that the database properties are defined correctly for the PostgreSQL database in the DB Painter.    If those properties are not defined correctly, the PB2019R3 IDE automatically creates the PB Catal...
Olan Knight Olan Knight
  1. PowerBuilder
How do I use an Argument for a Row Limitation START AT in datawindow SQL
  1. Resolved
  2. How-to
  1. Last updated 3 years ago
  2.  Olan Knight replied 3 years ago
5 replies
1077 views
0 votes
In PB 2017 we have an SQL statement that can potentially retrieve too many rows to be manageable.   We would like to limit the retrieve to a specified number of rows and use the SQL START AT syntax to say where to start based on the order by The da...
  1.  DataWindow
Glenn Barber Glenn Barber
  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