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
22113 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
5348 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
Connect to AWS Aurora? Anyone?
  1. Resolved
  2. How-to
  1. Last updated 8 months ago
  2.  Matt Balent replied 7 months ago
2 replies
804 views
0 votes
Has anyone connected their PB application to an AWS Aurora database (using PB 2022 R3)?  If so, what did you use to connect? ODBC? something else? Thanks!
  1.  Amazon AWS
  2.  PowerBuilder
Matt Balent Matt Balent
  1. PowerBuilder
Use the DataWindow object (DWO) outside of a DataWindow
  1. How-to
  1. Last updated 7 months ago
  2.  Chris Pollach @Appeon replied 7 months ago
2 replies
623 views
0 votes
Hi Experts, How can I use the DataWindow object (DWO) outside of a DataWindow? Specifically, if I need to retrieve the name of a selected column in a DataWindow from outside of it, how can I achieve this? Thanks Deva.S
Deva Shanmuga Deva Shanmuga
  1. PowerBuilder
Enable DEP/SafeSEH/ASLR and Anti Tamper protection in Power Builder 2017/2019
  1. Resolved
  2. How-to
  1. Last updated 4 years ago
  2.  Krupa Kiran Tadepalli replied 7 months ago
4 replies
3448 views
1 vote
Hi , currently I'm using Power Builder 2017 to develop a windows application and I need to Know if there is a way to: Enable Data Execution Prevention (DEP) in my executable. Currently when I deploy my application all binaries generated have DE...
Erick Siliezar Erick Siliezar
  1. PowerBuilder
MS SQL Server Azure Connection
  1. Resolved
  2. How-to
  1. Last updated 7 months ago
  2.  Chris Pollach @Appeon replied 7 months ago
2 replies
640 views
0 votes
Hello,  Where is it possible to find the database driver for Microsoft Azure after PowerBuilder 2017, and what drivers were deprecated. I understand that after PB 2017, new drivers to connect MS SQL Server and Azure were provided.   Thanks and r...
Jhonns Salas Jhonns Salas
  1. PowerBuilder
Passing a datawindow in a structure from one user object to another first instance dw in structure got overwritten by the seconfd instance dw
  1. Resolved
  2. How-to
  1. Last updated 7 months ago
  2.  Sathishkumar S replied 7 months ago
3 replies
577 views
0 votes
HI All, I need help. I have a structure, `str_patient`, with different data types such as long, string, boolean, datetime, datawindow, and userobject. From one datawindow, I am loading the local structure with all required parameters and the datawin...
  1.  PowerBuilder (Appeon)
  2.  PowerScript (PS)
Sathishkumar S Sathishkumar S
  1. PowerBuilder
Design a Button
  1. How-to
  1. Last updated 7 months ago
  2.  Chris Pollach @Appeon replied 7 months ago
3 replies
545 views
0 votes
Hi Experts, I'd like to design a button with custom colors (background and text). While I can achieve this within a datawindow, it doesn't seem to work when I try it in a window. What should I do in such cases? Thanks Deva.S
Deva Shanmuga Deva Shanmuga
  1. PowerBuilder
The dimensions of one or more picture buttons have been changed to preserve the pictures´s original size
  1. Resolved
  2. How-to
  1. Last updated 7 months ago
  2.  Marco Armbruster replied 7 months ago
4 replies
605 views
0 votes
I get the following message when I open a UserObject or a Window in the IDE: The dimensions of one or more picture buttons have been changed to preserve the pictures´s original size So I have to save any opened UO or Window, even if nothing has che...
Marco Armbruster Marco Armbruster
  1. PowerBuilder
Illegal data type TRACKMOUSEEVENT
  1. Resolved
  2. How-to
  1. Last updated 7 months ago
  2.  Vinicius Geraldino replied 7 months ago
2 replies
504 views
0 votes
Hello, im trying to use TrackMouseEvent winapi, but when i put the function on "Local External Functions": Function boolean TrackMouseEvent ( Ref TRACKMOUSEEVENT lpEventTrack ) Library "user32.dll" Im getting error: Illegal data type TRACKM...
Vinicius Geraldino Vinicius Geraldino
  1. PowerBuilder
Match non-numeric characters
  1. Resolved
  2. How-to
  1. Last updated 7 months ago
  2.  Miguel Leeuwe replied 7 months ago
2 replies
586 views
0 votes
Wondering how to write the match clause so it finds the first non-numeric value.  This algorithm is finding the first a-z character, but if the first non-numeric character is a special character, it doesn't work. for li_x = 1 to li_length ls_char ...
  1.  Function
  2.  PowerBuilder (Appeon)
Tracy Lamb Tracy Lamb
  1. PowerBuilder
Update Properties in PowerBuilder
  1. How-to
  1. Last updated 7 months ago
  2.  Roland Smith replied 7 months ago
3 replies
733 views
0 votes
Hi Experts, When updating a DataWindow, I have two options: "Use Delete then Insert" and "Use Update." Can you explain the usage of these options? When should I use each one, and what happens if I choose the wrong option while saving? Thanks Deva....
Deva Shanmuga Deva Shanmuga
  1. PowerBuilder
Dw Composite
  1. How-to
  1. Last updated 7 months ago
  2.  Chris Pollach @Appeon replied 7 months ago
1 reply
549 views
0 votes
Hola buenas, estoy teniendo un problema con una dw composite, el campo de texto no es richtext. La misma se corta en los saltos de pagina. adjunto captura de pantalla. Desde ya muchas gracias.
Jesus Perez Jesus Perez
  1. PowerBuilder
Rich Text fields
  1. How-to
  1. Last updated 7 months ago
  2.  Chris Pollach @Appeon replied 7 months ago
1 reply
641 views
0 votes
I have some Rich Text fields on a few datawindow objects.  The issue I'm having is that the user cannot tab out of the RichText field.  When the user types TAB, it inserts a tab character (not really a big deal).  More importantly, when the cursor is...
  1.  DataWindow
  2.  PowerBuilder (Appeon)
  3.  Rich Text
Tracy Lamb Tracy Lamb
  1. PowerBuilder
Encryption/Decryption of INI file in PowerBuilder
  1. How-to
  1. Last updated 7 months ago
  2.  Chris Pollach @Appeon replied 7 months ago
4 replies
1022 views
0 votes
Hi Everyone,   I have an existing PB 2019 project that needs an encryption and decryption of INI file. (the INI file contains database credentials). I don't have any idea how will I'm going to do that, so any help or suggestions would be very much ...
  1.  Database
  2.  Encryption
  3.  PowerBuilder (Appeon)
  4.  PowerBuilder (SAP)
Avory Rose Pastoral Avory Rose Pastoral
  1. PowerBuilder
PowerBuilder Build 3356 ADO.NET SQL Connection Error
  1. Issue
  1. Last updated 8 months ago
  2.  Angie Liu@Appeon replied 7 months ago
6 replies
1412 views
0 votes
I was at PowerBuilder Version 2022 Build 1878 when we received the update about that there was a vulnerability when using ADO.NET database connection in a newer update.  I stayed at my current version.  I did not perform a PowerBuilder update until n...
Tim Moulaison Tim Moulaison
  1. PowerBuilder
Please add an "AI" TAG to the tags list in this community.
  1. How-to
  1. Last updated 7 months ago
  2.  Armeen Mazda @Appeon replied 7 months ago
1 reply
546 views
0 votes
Hi admin,   Please add an "AI"  TAG to the tags list in this community.   Thanks  Steen
  1.  PowerBuilder (Appeon)
Steen Jakobsen Steen Jakobsen
  1. PowerBuilder
Display an image in a circular format
  1. How-to
  1. Last updated 7 months ago
  2.  Ronnie Po replied 7 months ago
2 replies
631 views
0 votes
Hello experts, How can I display an image in a circular format similar to the display style used in WhatsApp? Thanks  Deva.S
Deva Shanmuga Deva Shanmuga
  1. PowerBuilder
Local Database
  1. Resolved
  2. How-to
  1. Last updated 7 months ago
  2.  Miguel Leeuwe replied 7 months ago
8 replies
665 views
0 votes
  Hello , we need a local database and we are using Powerbuilder 2022 R3. Does anyone have experience with local databases.what is a possible solution. I haven't been able to connect to SqlServer Express LocalDb so far. Is SQLite a solution? Un...
Heribert Goeckel Heribert Goeckel
  1. PowerBuilder
Crashing of application, as the datawindow is not loaded using ODBC driver
  1. Issue
  1. Last updated 7 months ago
  2.  Andreas Mykonios replied 7 months ago
1 reply
580 views
0 votes
Hi , Recently, upgraded the application to latest ODBC driver 18 for sql server. Application is crashing as the datawindow is not loading properly. c_bo_mss.pbl is not being formed using SQL Server 2022.    Any idea, why the datawindow is not bein...
Apoorva JUKANTI Apoorva JUKANTI
  1. PowerBuilder
C# documentation for powerserver 22R3 to build out my own set of connection strings
  1. How-to
  1. Last updated 7 months ago
  2.  Logan Liu @Appeon replied 7 months ago
2 replies
584 views
0 votes
looking for documenation on the powerserver c# objects. specifically, the details on : AddPowerServerAppConfig   what i want to do is use my own code to build the connection strings for powerserver (many databases/servers) so i can use a username/...
mike S mike S
  1. PowerServer
Modify Theme
  1. How-to
  1. Last updated 7 months ago
  2.  Miguel Leeuwe replied 7 months ago
1 reply
476 views
0 votes
I would like to modify the Dark Theme that PB22 offers. I know there are json files that contain the properties and settings. Can I copy the json file to the directory in which my pbls are and make changes? If so, can I leave the original json file ...
Robert Sawyer Robert Sawyer
  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