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
22126 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
5362 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
Excel VBA from PB script
  1. Resolved
  2. How-to
  1. Last updated 4 years ago
  2.  Sylvain . replied 4 years ago
2 replies
2721 views
0 votes
I'm trying to create a group inside an excel sheet from PB script, I have found the instruction to do so at this address:    https://docs.microsoft.com/en-us/office/vba/api/excel.range.subtotal The VBA instruction look like this:   Worksheets("Shee...
Sylvain . Sylvain .
  1. PowerBuilder
Debug with Visual Studio and PowerBuilder for C# components
  1. Issue
  1. Last updated 4 years ago
  2.  Chris Pollach @Appeon replied 4 years ago
3 replies
2710 views
1 vote
When we want debug our ActiveX components written in C# (Visual Studio) and PowerBuilder the application starts and stops. We have enabled 'Enable native code debugging' and 'Use Managed Compatibility Mode'. When we use PowerBuilder 12 is starts Po...
  1.  .NET Std Framework
  2.  C#
  3.  Debugging
  4.  Visual Studio
Stèphan Eizinga Stèphan Eizinga
  1. PowerBuilder
Fixed DATA in a DW how to Describe and Modify ?
  1. Resolved
  2. How-to
  1. Last updated 4 years ago
  2.  Miguel Leeuwe replied 4 years ago
3 replies
1920 views
0 votes
Hi, I have this datawindow with 4 "fixed data rows". Does anyone know if there's a way to manipulate these fixed rows with Modiy() or Describe()? I want to allow a user to create a sort of a template and drag field-names on columns in a datawin...
Miguel Leeuwe Miguel Leeuwe
  1. PowerBuilder
Postgres and asynchronous retrieve
  1. Resolved
  2. Issue
  1. Last updated 4 years ago
  2.  Miguel Leeuwe replied 4 years ago
3 replies
2291 views
0 votes
Hello, we are migrating a powerbuilder 2019 project from Oracle to Postgres 12. The async database parameter is set to 1 and the retrieverow event is coded, so i can cancel a retrieve.When i am connected to Oracle (native driver), everything works ...
  1.  PostgreSQL
  2.  PowerBuilder
Markus Schröder Markus Schröder
  1. PowerBuilder
Encoding Problem converting RTE to HTML
  1. Issue
  1. Last updated 4 years ago
  2.  Mark Lee @Appeon replied 4 years ago
3 replies
2491 views
0 votes
Hello, I have a problem with different encoding behavior of special characters (e.g. äöüÄÖÜß) and empty lines when using different versions of RichTextEdit. The goal is to convert the content of a RichTextEdit to HTML such that it can be send as a ...
  1.  Encoding
  2.  HTML/5
  3.  TX Control
Paul Bungert Paul Bungert
  1. PowerBuilder
What we really need is a HTML Editor
  1. How-to
  1. Last updated 5 years ago
  2.  Miguel Leeuwe replied 4 years ago
12 replies
3690 views
3 votes
Hello All, We constantly have issues converting RTF to HTML when sending out smtp emails via our PB app. You cannot send RTF thru SMTP. The RTF control is nice but what we are really looking for is a nice HTML editor . I'm not aware of it being buil...
Richard Carrier Richard Carrier
  1. PowerBuilder
Install of 2017 R3 (1858) fails
  1. Issue
  1. Last updated 4 years ago
  2.  Chris Pollach @Appeon replied 4 years ago
1 reply
1591 views
0 votes
"The installed version of the application could not be determined. The setup will now terminate".    Why am I getting this error when running the Installshield install for PB 2017 R3, rel 1858?  I am currently on PB 2017 R2.   Where is it looking ...
Linda Swanson Linda Swanson
  1. PowerBuilder
PB 17 and oracle 19c
  1. Issue
  1. Last updated 4 years ago
  2.  Chris Pollach @Appeon replied 4 years ago
7 replies
3396 views
0 votes
Testing a connection to Oracle 19C. Our login window is successful connecting to the database. When we run our next select statement that just counts records in a table we get an error saying we are not connected. Not sure why the connection is be...
tim schmidt tim schmidt
  1. PowerBuilder
prevent new logons
  1. How-to
  1. Last updated 4 years ago
  2.  Michael Kramer replied 4 years ago
4 replies
1621 views
0 votes
Hi, I am after some advice / best practice. If i want to take down a powerserver web application for some maintenance is there a way of preventing new logons, what i want is to allow the users currently logged on to finish their transaction / leave...
  1.  PowerServer Web
Andrew Davis Andrew Davis
  1. PowerServer 2020 or older (Obsolete)
Printing window using print function
  1. Issue
  1. Last updated 4 years ago
  2.  Andy Preman replied 4 years ago
3 replies
2018 views
0 votes
Hi, Does anybody have any solution regarding printing problem in pb2019 ver.2170 ? Seems like there is only one blank (white) paper coming from printing. Last versjon we get this working is pb 2017 ver.1880 Hope that somebody has one solution, bu...
Ivan Aase Ivan Aase
  1. PowerBuilder
Slow opening of mobile app
  1. Advice
  1. Last updated 4 years ago
  2.  Chris Pollach @Appeon replied 4 years ago
1 reply
1311 views
0 votes
Hello, My mobile application running on Appeon powerserver takes time while opening. I need help on how to make it open more first. Thank you in advance.
mathews rutto mathews rutto
  1. PowerServer Mobile (Obsolete)
need new pbdom's for version 19
  1. Resolved
  2. Misc
  1. Last updated 4 years ago
  2.  JOHN THOMAS replied 4 years ago
4 replies
1681 views
0 votes
All - we have installed the new PB19 version but now need the new pbdom19.pbd's as the pbdom17's are not working, can anyone point me to a download of these or should they be in the install package already? Thanks.
JOHN THOMAS JOHN THOMAS
  1. PowerBuilder
Graph Minimum and Maximum axis values are not getting changed and saved if we try to modify the axis values
  1. How-to
  1. Last updated 4 years ago
  2.  John Fauss replied 4 years ago
1 reply
1611 views
0 votes
Hi Team, We are using PowerBuilder 2017 R3 and trying to modify the graph axis properties(Minimum and Maximum values) of graph in the axis menu. If I am trying to change the axis values the min and max values were not changing and are not getting sa...
Minogue Susan Minogue Susan
  1. PowerBuilder
Change text menu of ribbonbar
  1. Resolved
  2. How-to
  1. Last updated 4 years ago
  2.  Thierry Garrigues replied 4 years ago
2 replies
2046 views
0 votes
HiI create a Ribbonbar from a xml file. This one contains a menu associated with a Largebutton ("tag = mybutton"). I want to change the text of the 1st menu with the following code: long ll_retRibbonLargeButtonItem lr_buttonll_ret = uo_ribbonbar.Get...
  1.  RibbonBar
Thierry Garrigues Thierry Garrigues
  1. Beta Testing
external function call with struct parameter by reference
  1. Resolved
  2. Issue
  1. Last updated 4 years ago
  2.  Stefan Schoppmann replied 4 years ago
1 reply
1643 views
0 votes
We migrated from PB 12.1 to 2019 (Build 2170). We have external function calls to self written C# DLLs like FUNCTION long VollyballModel(ref str_volley_dll_call marketOdds[] , ref long odds_size, double odd_H, double odd_A,..... All works fine in ...
Stefan Schoppmann Stefan Schoppmann
  1. PowerBuilder
dw.insertrow(0) returns -1
  1. Resolved
  2. Advice
  1. Last updated 4 years ago
  2.  Rins Francis replied 4 years ago
2 replies
1667 views
0 votes
dear team,   please help me to resolve the issue plz go thru the script   long ll_row  DataWindow ldw_print ldw_print= create DataWindow ldw_print.dataobject = 'dw_test' ll_row = ldw_print.insertrow(0)   this is the script ; ll_row gives m...
Rins Francis Rins Francis
  1. PowerBuilder
catalog tables could not be created
  1. Issue
  1. Last updated 4 years ago
  2.  moritz nölting replied 4 years ago
2 replies
2036 views
0 votes
hi, i have the latest build of PB (2019.2170) on windows 10.  i'm using MySQL (8.0.19) db and have the aggravating issue of not being able to generate or use the system catalog tables.  i've tried blank, root and the name of the database in the tabl...
moritz nölting moritz nölting
  1. PowerBuilder
Catalog tables could not be created and are not available for use
  1. Issue
  1. Last updated 4 years ago
  2.  Marco Meoni replied 4 years ago
1 reply
1857 views
0 votes
Hi I just installed powerbuilder 12.5 and mysql 8 on a Windows 10 machine all installations are working but when training to connect powerbuilder 12.5 to mysql 8 I get this error " Catalog tables could not be created and are not available for use" ...
FAUSTO CORDOVA GARCIA FAUSTO CORDOVA GARCIA
  1. PowerBuilder
How to implement Access Control List for menu object ?
  1. Advice
  1. Last updated 4 years ago
  2.  PRASHANT NIRGUN replied 4 years ago
2 replies
1970 views
0 votes
I am using PB 12.5.2 I want to implement Access Control List. ie appliction user or user group has right for CRUD if he has the permission he can able to perform the operation. I created acl, user_permission and group_permission table. CREATE TABLE ...
  1.  Menu
PRASHANT NIRGUN PRASHANT NIRGUN
  1. PowerBuilder
Using encryption for two columns on a DB2 database and PB17.
  1. How-to
  1. Last updated 4 years ago
  2.  Miguel Leeuwe replied 4 years ago
4 replies
2364 views
0 votes
We have to encrypt two columns on one DB2.  We have set it up as a varbinary with a with of 32 characters. Using an insert statement we added the column not problem; INSERT INTO YCCFSSC5.BANK_ACCOUNT (TX_PRVD_ACCTN_NMBR)      VALUES(ENCRYPT('58672...
  1.  Encryption
Dana Willey Dana Willey
  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