Featured Questions

Q&A Forum Tip: Including Source Code in Your Question
  1. Advice
  1. Last updated 2 years ago
  2.  Tjafzfa Gsjsf replied 4 months ago
6 replies
19325 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
4997 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
Windows 2012 R2 and PB 2022 R3?
  1. Resolved
  2. Advice
  1. Last updated 6 months ago
  2.  Chris Pollach @Appeon replied 6 months ago
1 reply
447 views
0 votes
I am looking to deploy our application on 2022 R3 but we still have many customers running Windows 2012 R2.  The help has a statement “No longer supports installing runtime to Windows Server 2012 R2”.  It is also flagged as 'Discontinued' which means...
Christopher Craft Christopher Craft
  1. PowerBuilder
Opened Transaction on SQLSERVER without DML commands
  1. Issue
  1. Last updated 6 months ago
  2.  Aquitetura Corporativa Unicred replied 6 months ago
4 replies
408 views
0 votes
Hello all,   We are using Powerbuilder 2019 with SqlServer 2016 and we noticed that when connect to the database the application is always starting a new transaction (without any insert/delete or update) if we execute the following select: select...
Aquitetura Corporativa Unicred Aquitetura Corporativa Unicred
  1. PowerBuilder
Application crash due to PBSHR.dll
  1. Issue
  1. Last updated 6 months ago
  2.  Chris Pollach @Appeon replied 6 months ago
1 reply
606 views
0 votes
Team, we are in PowerBuilder 2022 Build 1900, Windows Server 2019 in some particular cases, we have a system error, while trying to print some PB reports from our PB application. Event viewer logs are attached.  
Balasubramanian Natarajan Balasubramanian Natarajan
  1. PowerBuilder
Sql Server - Row changed between retrieve and update
  1. Advice
  1. Last updated 6 months ago
  2.  mike S replied 6 months ago
1 reply
528 views
0 votes
Sql Server 2019  PowerBuilder 2019 R3 build 2728 I'm using ODBC connection  I have a datastore, I change data and then do an update lds_post_dates.setitem(i, "column_name", ll_value)ll_rv = lds_post_dates.update()   The base table for the datas...
  1.  ODBC
  2.  PowerBuilder
  3.  SQL Server
Tim Bruce Tim Bruce
  1. PowerBuilder
reading from the registry to connect to the db
  1. How-to
  1. Last updated 1 year ago
  2.  Albert van Bochove replied 6 months ago
6 replies
1047 views
0 votes
Hello, in my application I am connecting to the database using the connection string that is defined in a Registry key, this is my code and as I show you in the attached images, you can see that when I debug my code I am receiving my transaction all...
  1.  32-bit
  2.  Authentication
  3.  Database
Albert van Bochove Albert van Bochove
  1. PowerBuilder
datawindow button.Background.Color with themes: theme-customs.json
  1. Resolved
  2. How-to
  1. Last updated 7 months ago
  2.  Ronnie Po replied 6 months ago
2 replies
413 views
0 votes
Hi All. Appeon PB 2019 R2 I am trying to change datawindow button control ( b_1 ) background to red in the datawindow ( dw_1 )  in the window ( w_test ) using theme-customs.json {"meta-info": {"version": "190"},"w_test.dw_1.b_1": {"drawing": true,...
Vladimir K. Vladimir K.
  1. PowerBuilder
duplicated primary key error even tho it dosent exist
  1. Issue
  1. Last updated 6 months ago
  2.  Berka Frenfert replied 6 months ago
5 replies
517 views
0 votes
hello everyone here in my powerbuilder 19 project, it's about article management. so when i insert a new article it works fine and when I update an article it works fine also but when I insert another article (after the update), i get the sqlstate e...
  1.  PowerBuilder
hatem moalla hatem moalla
  1. PowerBuilder
how can i get a message box for duplicated primary key before submitting the form
  1. How-to
  1. Last updated 6 months ago
  2.  Berka Frenfert replied 6 months ago
4 replies
466 views
0 votes
in my powerbuilder 19 project, i have a DB called "gest_article" and a column "reference" set as a primary key and unique value, and a data window called "dwc_article" is a freeform to insert an article. i wanna get a message box for duplicated refe...
  1.  PowerBuilder
hatem moalla hatem moalla
  1. PowerBuilder
SBOM form PowerBuilder Application
  1. How-to
  1. Last updated 6 months ago
  2.  Armeen Mazda @Appeon replied 6 months ago
1 reply
402 views
0 votes
Hi Team,     We've been asked to generate a Software Bill of Materials regarding our PowerBuilder based application. Any option there to generate this information from PowerBuilder. Is there any tools to generate this information? We are currentl...
Ilamathi Ravindran Ilamathi Ravindran
  1. PowerBuilder
Snapdevelop Error to Publish
  1. How-to
  1. Last updated 6 months ago
  2.  Armeen Mazda @Appeon replied 6 months ago
1 reply
406 views
0 votes
When I try to publish it sends permissions error, how can I fix it? Please launch SnapDevelop under administrator mode to perform this deployment action The login user I am using is the administrator of the computer. GreetingsRenaul  
Renaul Medina Renaul Medina
  1. SnapDevelop
Web Api Tester starts but closes immediately
  1. Issue
  1. Last updated 6 months ago
  2.  Riccardo Pasqualetti replied 6 months ago
1 reply
434 views
0 votes
  HI,if I try to debug my service, Web Api Tester starts but closes immediately. The Snap Developer version is old but has always worked. Here is the console output: Web API Tester-The test service has started and is listening on port 65533.Host- i...
Riccardo Pasqualetti Riccardo Pasqualetti
  1. SnapDevelop
Custom Colors, Where stored in the Registry?
  1. Misc
  1. Last updated 6 months ago
  2.  Matt Balent replied 6 months ago
1 reply
460 views
0 votes
I'm getting ready to upgrade my work laptop.  Where in the registry are the custom color settings in PB stored? (registry way too big to search manually) Thanks Matt
  1.  PowerBuilder
Matt Balent Matt Balent
  1. PowerBuilder
SQL Anywhere 16+ Default DB Owner for alternate user
  1. How-to
  1. Last updated 6 months ago
  2.  Ronnie Po replied 6 months ago
3 replies
519 views
0 votes
If App_user is created to connect to SQL Anywhere that is other than DBA, granted Select on the tables, how can the table owner default to DBA without explicitly using DBA.my_table? We don't want to use the DBA account for the application.I've tried ...
  1.  ODBC
  2.  SQL Anywhere
Jeff Wayt Jeff Wayt
  1. PowerBuilder
Connecting PB2022R3 to GitLab
  1. How-to
  1. Last updated 7 months ago
  2.  Tobias Roth replied 6 months ago
1 reply
407 views
0 votes
Hi, I'm trying to connect PB to GitLab repository, but failing with error "Cannot connect to the repository. Please make sure you have specified the correct user ID and password".Which I think as I can log into GitLab using a browser using those cre...
Kari Paukku Kari Paukku
  1. PowerBuilder
Can Powerserver/CAL install .Net runtime on Client's PC
  1. Resolved
  2. Advice
  1. Last updated 7 months ago
  2.  Anoop Chaurasia replied 7 months ago
3 replies
449 views
0 votes
My Application have multiple .net DLLs which is built using .net 2 and 4. While launching the powerserver application it is throwing error on client's PC when .net runtime is not available. Is there a way to check the .net runtime and install on cli...
Anoop Chaurasia Anoop Chaurasia
  1. PowerServer
Deployment on clean computer crashes
  1. Issue
  1. Last updated 7 months ago
  2.  Ken Guo @Appeon replied 7 months ago
5 replies
488 views
0 votes
Upgrading a PB 12.5  app to PB 2022R3. Uses ADO.NET to connect to SQL Server. App crashes during connection process (i.e., after credentials are entered and Login button is clicked) on a Windows 11 machine. Faulting application name: xxx.exe, versio...
  1.  Deployment
Neil N Neil N
  1. PowerBuilder
SMTPClient Object - read confirmation
  1. Resolved
  2. How-to
  1. Last updated 7 months ago
  2.  Andreas Mykonios replied 7 months ago
2 replies
443 views
0 votes
Hi I'm trying SMtpClient in Powerbuilder 2022 R2. There are many new features to use like encodig,logfile,setproxy and xoauth2AccessToken. it's working amazing!! But just to try to maintain the above functionality, is there a way to get opened ema...
damian jimenez damian jimenez
  1. PowerBuilder
httpclient help
  1. Resolved
  2. How-to
  1. Last updated 3 years ago
  2.  Steven Carter replied 7 months ago
7 replies
2275 views
0 votes
Hi I am converting the old 'web service proxy' calls to the new 'httpclient'.I'm running the directions in 'https://www.appeon.com/developers/get-help/knowledgebase/call-soap-web-service-using-httpclient-object.html', but it doesn't work. (performed...
Gimmy Susan Gimmy Susan
  1. PowerBuilder
datawindow button.Background.Color with themes
  1. How-to
  1. Last updated 1 year ago
  2.  Tomas Beran replied 7 months ago
6 replies
1078 views
0 votes
Hi Is there a way how to force a different button color from code if a theme is applied?   The only working method I've found is to disable theme for the button with "drawing":false But what I want is to use the theme and only override it progra...
Tomas Beran Tomas Beran
  1. PowerBuilder
Determine Process CPU Percent
  1. How-to
  1. Last updated 7 months ago
  2.  Roland Smith replied 7 months ago
3 replies
423 views
0 votes
I'm looking to automatically kill a process if it gets over a certain CPU percentage. I need to know what API function to call to get the CPU percent. I already know how to get a list of processes.
Roland Smith Roland Smith
  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