Featured Questions

Q&A Forum Tip: Including Source Code in Your Question
  1. Advice
  1. Last updated 3 years ago
  2.  Tjafzfa Gsjsf replied 12 months ago
6 replies
22399 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
5574 views
11 votes
Saw this and thought it was perfect. Note the angry mob in the background on panel 4.   :)
Olan Knight Olan Knight
  1. PowerBuilder
PowerServer Datawindow column issue with SQL Server and column of type char > length 32766
  1. New
  2. Issue
  1. Last updated 5 hours ago
0 replies
10 views
0 votes
We have many columns in various data windows across multiple applications that exceed the 32765 string length. While this is not an issue in native PowerBuilder, it is an issue in PowerServer, as any datawindow with the said column receives the error...
Dustin Sellers Dustin Sellers
  1. PowerServer
How to change update.bmp in CloudAppLauncher
  1. Resolved
  2. How-to
  1. Last updated 2 weeks ago
  2.  John Raghanti replied 6 hours ago
2 replies
66 views
1 vote
Hi. I'm running PB 2022R3 Build 3397. We are trying to brand the CloudAppLauncher loading screens. We created a loading_ica.gif and an update.bmp. I added both files to the "External files" Files preloaded in uncompressed format in the PowerServer...
John Raghanti John Raghanti
  1. PowerServer
SQLCA.SQLCODE and SQLCA.SQLDBCODE not capturing database error
  1. New
  2. Issue
  1. Last updated 21 hours ago
  2.  Sekhar Chitta replied 8 hours ago
2 replies
27 views
0 votes
We are connecting Powerbuilder 17 app to SQL server through ODBC using the native SQL server ODBC driver. We send batch sql statements to the sql server. The batch statements are mainly execute procedure and checking the success or failure of the pro...
Sekhar Chitta Sekhar Chitta
  1. PowerBuilder
Request for Official License Certificate for PowerBuilder
  1. New
  2. How-to
  1. Last updated 1 day ago
  2.  Chris Pollach @Appeon replied 9 hours ago
1 reply
40 views
0 votes
Hello, I would like to request official software license certificates for the PowerBuilder licenses currently in use. Is it possible to obtain formal license certificates for the software? In particular, I would like to request certificates for th...
sangyong baek sangyong baek
  1. PowerBuilder
Code signing for $10/month using azure trusted signing
  1. Resolved
  2. New
  3. How-to
  1. Last updated 4 days ago
  2.  David Peace (Powersoft) replied 10 hours ago
4 replies
110 views
2 votes
Has anyone tried this yet? I'm planning to try this after my current cert expires. FYI - New azure code signing service that includes the certification and HSM for 10/month. Typical EV certs cost well over 200+ year. Works with signtool as well a...
mike S mike S
  1. PowerBuilder
PFC database
  1. New
  2. How-to
  1. Last updated 12 hours ago
  2.  Arnd Schmidt replied 12 hours ago
1 reply
13 views
0 votes
Hi, I am probably being a bit stupid here but I want to run the PFC app PEAT - and i get database not found. I cannot see any .db in the PFC download ver 2022 Where do i get the database from please thanks in advance Andrew
Andrew Davis Andrew Davis
  1. PowerBuilder
datawindow filter code
  1. New
  2. How-to
  1. Last updated 2 days ago
  2.  Andrew Davis replied 12 hours ago
1 reply
48 views
0 votes
Hopefully someone can help I am sure that at some point i have seen enhanced / demo code for the default filter window or sort window string sznull setnull(sznull) dw_1.setfilter(sznull) dw_1.filter() and the equivalent sort features, but i...
  1.  DataWindow
  2.  Filter
  3.  Sort
Andrew Davis Andrew Davis
  1. PowerBuilder
PB2022 JVM Problems
  1. Issue
  1. Last updated 1 month ago
  2.  David Peace (Powersoft) replied 13 hours ago
2 replies
99 views
0 votes
I am setting up PB2022 to use the JDBC driver using jdk 1.6 but I am having some problems. The JVM is not loading in the java tab page of the system options windows. Also when i click on the view jvm classpath button nothing happens.
jorge gonzalez jorge gonzalez
  1. PowerBuilder
Database painter - drop column
  1. New
  2. How-to
  1. Last updated 1 day ago
  2.  David Peace (Powersoft) replied 13 hours ago
2 replies
15 views
0 votes
I'm still learning the PB2025 IDE from (PB6.0) and I've encountered a situation where I need to drop a column in a table. I've tried using the database painter objects list and when I right click on a field in one of the tables I can see a "drop colu...
Rich Gibson Rich Gibson
  1. PowerBuilder
Non visual data window NULLABLE error
  1. New
  2. Issue
  1. Last updated 6 days ago
  2.  Esau Redwan replied 1 day ago
3 replies
84 views
0 votes
Hello, we are getting an error on one of our datastores: "ModeulOrModelName": "d_customer_productgroup", "ErrorCode": 0, "ErrorMessage": "Unable to cast object of type 'System.String' to type 'System.Nullable`1[System.Single]'." We have changed all ...
Esau Redwan Esau Redwan
  1. PowerServer
SetItemStatus does not change to NotModified
  1. Issue
  1. Last updated 3 years ago
  2.  mike S replied 1 day ago
4 replies
1393 views
0 votes
Dear all,   I am having a problem with setting a columns status to NotModiefied!, look here dw_list.SetItem(ll_row, "workitemstatus", 'Y')ldws_status = dw_list.getItemStatus(ll_row, 'workitemstatus', Primary! ) -- now it is dataModified!ll_ret = d...
Thorsten Kummer Thorsten Kummer
  1. PowerBuilder
Access sub-report on a nested datawindow
  1. New
  2. How-to
  1. Last updated 5 days ago
  2.  David Peace (Powersoft) replied 1 day ago
5 replies
74 views
0 votes
Hi There to all PowerBuilder Guru's - I have a composite datawindow (say dw_composite) which has 4 sub-reports inside it - dw_child_1, dw_child_2, dw_child_3 (all three placed in the Detail band of dw_composite) and dw_child_4 (placed in the summary...
Krishna Mohan Gullap Krishna Mohan Gullap
  1. PowerBuilder
GetCookies using Antview's WebView2 ActiveX Control
  1. How-to
  1. Last updated 4 weeks ago
  2.  David Peace (Powersoft) replied 1 day ago
3 replies
86 views
0 votes
Hello, We've been using AntView's MS Edge Webview2 ActiveX control (.ocx) for a while now with PowerBuilder 2022 R3 and with version 1.1.460.0 they have introduced a method to list all of the cookies for a User's Profile. The CookieManager is a "pr...
Gregory Rusak Gregory Rusak
  1. PowerBuilder
WebBrowser - save PDF problem
  1. New
  2. How-to
  1. Last updated 4 days ago
  2.  Kai Zhao @Appeon replied 2 days ago
2 replies
72 views
0 votes
Hello, PB 2022 R3, Build 3391 A problem with saving PDF files in WebBrowser has been detected. If you open a NEW WINDOW with a PDF file from WebBrowser window.open('https://www.w3.org/WAI/ER/tests/xhtml/testfiles/resources/pdf/dummy.pdf') ...
Michael Krul Michael Krul
  1. PowerBuilder
Debugger doesn't stop on breakpoints
  1. Issue
  1. Last updated 1 week ago
  2.  David Peace (Powersoft) replied 2 days ago
3 replies
75 views
0 votes
I'm having a weird issue where once PB hits this error I'm trying to debug, and then the debugger doesn't stop on my breakpoints... Any one have any idea what could cause this? -- My error even opens up a custom message window where I've put a break ...
Richard Donagrandi Richard Donagrandi
  1. PowerBuilder
PBDOM GetText() and XML Decoding - Comprehensiveness
  1. New
  2. Misc
  1. Last updated 2 days ago
0 replies
23 views
0 votes
PBDOM_ELEMENT.GetText() implicitly decodes encoded XML...but how comprehensively?' *** Can PBDOM_ELEMENT.GetText() be relied upon to decode all possible entities, all possibly encoded characters? While I'm normally loathe to reference Wikipedia...
John Strano John Strano
  1. PowerBuilder
Performance issue while using SyntaxFromSQL function.
  1. New
  2. Issue
  1. Last updated 6 days ago
  2.  David Peace (Powersoft) replied 2 days ago
2 replies
89 views
0 votes
We are using below lines of code, while working our application with Oracle database SyntaxFromSQL function is taking lot of extra time to execute as compared to the time taken while using SQL Server. Any idea what could be the issue and is there any...
Dhruv Jain Dhruv Jain
  1. PowerBuilder
Show all pages of multiple PDF files in one window
  1. New
  2. How-to
  1. Last updated 2 days ago
  2.  David Peace (Powersoft) replied 2 days ago
1 reply
30 views
0 votes
Hi How to show all pages of 2 different pdf files in same window? Which objects can be used? Programming with latest PowerBuilder version. All ideas welcome... Kind Regards,Sylvie
  1.  PDF
  2.  PowerBuilder (Appeon)
Sylvie Bouttelisier Sylvie Bouttelisier
  1. PowerBuilder
@col use in a datawindow expression
  1. Resolved
  2. How-to
  1. Last updated 1 week ago
  2.  David Peace (Powersoft) replied 2 days ago
5 replies
139 views
0 votes
Hello, I was watching an article about @col expression. Is it possible to use @col, to get the number or name of the column in a datawindow expression? I was making some tests with describe in with no success. Thanks and regards...
Jhonns Salas Jhonns Salas
  1. PowerBuilder
Pipeline doing INSERT instead of UPDATE
  1. New
  2. Issue
  1. Last updated 2 days ago
  2.  David Peace (Powersoft) replied 2 days ago
1 reply
24 views
0 votes
Hello, I'm using a pipeline object with the operation set to "Update - Update/Insert Rows", which I understand should update records in the target database that match the selected key criteria values selected from the source DB. However, instead of ...
  1.  Pipeline
  2.  PowerBuilder
Konstantin Goldobin Konstantin Goldobin
  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