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
19377 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
5015 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
Dropdown List ignores a forward slash in data value and display value
  1. Resolved
  2. Issue
  1. Last updated 3 years ago
  2.  Ganesan Rajan replied 3 years ago
2 replies
1548 views
0 votes
Dear Experts, I am facing a weird problem in drop down list box values in Powerbuilder 2017 R3 Build 1880. Our application gets the list of printers installed in a machine and lists it in a dropdown list box. A variable is used to collect data val...
  1.  DataWindow
  2.  PowerBuilder (Appeon)
Ganesan Rajan Ganesan Rajan
  1. PowerBuilder
Main! Modal Window
  1. How-to
  1. Last updated 3 years ago
  2.  Pete Yankovich replied 3 years ago
3 replies
1694 views
0 votes
In PB 2017 R2, can a Main! window be modal, ie, focus can not go to another window or menu when open.
Pete Yankovich Pete Yankovich
  1. PowerBuilder
statictext not show text complete
  1. Issue
  1. Last updated 3 years ago
  2.  Luis Pesaressi replied 3 years ago
2 replies
1402 views
0 votes
HI, I have this code li_file = GetFileOpenName("Buscar XLS",ls_path,ls_file,ls_ext,ls_filter)if li_file = 1 then  st_3.text=ls_pathelse  st_3.text=""end if before update the static text show text complete "C:\Users\name last\Documents\LPC\LpcSol\...
Luis Pesaressi Luis Pesaressi
  1. Beta Testing
Execution of stored procedure from Powerbuilder app stops inexplicably
  1. Issue
  1. Last updated 3 years ago
  2.  Miguel Leeuwe replied 3 years ago
5 replies
2083 views
0 votes
Our Powerbuilder application executes a stored procedure in Sybase and has been running without problems for a few years.  About a month ago the stored procedure began stopping without finishing and did not report any error to the calling application...
  1.  Appeon Workspace
  2.  Database
  3.  PBD
  4.  PowerBuilder (Appeon)
  5.  Stored Procedure
Tom McManus Tom McManus
  1. PowerBuilder
PB 2017 R3 database connection issue when running .pbl
  1. Issue
  1. Last updated 3 years ago
  2.  Olan Knight replied 3 years ago
4 replies
1464 views
0 votes
Using PB 2017 R3 with Sybase 16 Database: Connecting to the databases works fine thru the Database administrator but when trying to run my .pbl I am unable to connect. Using the function "of_connect" in the object pfc_n_tr of the pfcmain.pbl returns ...
Alan Trottier Alan Trottier
  1. PowerBuilder
User Name in the Active Session in AEM
  1. Resolved
  2. How-to
  1. Last updated 3 years ago
  2.  mike S replied 3 years ago
1 reply
1931 views
0 votes
Hi; Looking on how to fill in a value under the Welcome  Server  Sessions  Active Sessions; the value is User Name. All the other values there, Session ID, IP Address, Application Name, etc have been automatically filled in. How does, or how can we...
  1.  AEM
  2.  PowerBuilder (Appeon)
  3.  PowerServer
Bryant Burnard Bryant Burnard
  1. PowerServer 2020 or older (Obsolete)
Menu item images
  1. How-to
  1. Last updated 3 years ago
  2.  Roland Smith replied 3 years ago
2 replies
1463 views
0 votes
Is it possible to have the menu item image sourced from an exe or dll contained one or more icons? Some features of Windows show an icon from a registry setting that has the full exe filename followed by a comma and then a number which is the icon i...
Roland Smith Roland Smith
  1. PowerBuilder
xml issue
  1. Resolved
  2. How-to
  1. Last updated 3 years ago
  2.  René Ullrich replied 3 years ago
1 reply
1417 views
0 votes
Hi all ,    I am consuming api ws with httpclient .POST : url + xml string formatted . I build the xml string my self ( not dw export ) The problem is when i want to use the character in the string the ws return an error : Illegal xml . The ws ...
  1.  XML
Moshe Tangi Moshe Tangi
  1. PowerBuilder
OLE ConnectToNewObject("Outlook.Application")
  1. Resolved
  2. How-to
  1. Last updated 3 years ago
  2.  Miguel Leeuwe replied 3 years ago
2 replies
2298 views
0 votes
Hi All I would like to ask a question that somewhat relates to this one - https://bit.ly/3j3rrFT When I issue the command ConnectToNewObject('Outlook.Application'), Powerbuilder returns -3 = Object could not be created. Later I found out that when...
CJ Lai CJ Lai
  1. PowerBuilder
ERROR Updating New Columns - SQL SERVER 2016
  1. Resolved
  2. How-to
  1. Last updated 3 years ago
  2.  Armeen Mazda @Appeon replied 3 years ago
3 replies
1163 views
0 votes
Hello Everyone..  Need HELP! I am having issues updating new columns added to a dw inherited from u_dw..   I get update failed, invalid column.. Yet I added the column using the designer itself..  tried many things including changing column name m...
Ravi Pathirane Ravi Pathirane
  1. PowerBuilder
Datetime issue with SQL 2016
  1. Issue
  1. Last updated 4 years ago
  2.  Chris Pollach @Appeon replied 3 years ago
4 replies
1603 views
0 votes
Hi, We recently started supporting SQL Server 2016 and SQL Native Client 11.0 in our application, but we are running into some issues with DateTime and Time fields. In the DB we have several Datetime columns, but since we added the compliance with ...
Daniela Jimenez Daniela Jimenez
  1. PowerBuilder
Can't set the background colour of a dw text control while theme applied
  1. Resolved
  2. Issue
  1. Last updated 3 years ago
  2.  Colin Cruikshank replied 3 years ago
3 replies
1457 views
0 votes
Hello, I have a mousemove script that changes the colour of the column header on a grid datawindow to indicate that the column header is clickable for sorting. The column header is a text control. I now want to use the theme feature, so in order to ...
Colin Cruikshank Colin Cruikshank
  1. PowerBuilder
deployment of 64bit TX Text control
  1. How-to
  1. Last updated 3 years ago
  2.  Steen Jakobsen replied 3 years ago
1 reply
2185 views
0 votes
Hi,   Where do I find documentation for how to register the TX control in 64 bit My guess is to run something like this: ..\Windows\system32\regsvr32 ..\Runtime 19.2.0.2556\x64\tx4ole28.ocx   Anyone tried it ?   Thanks //Steen      
  1.  64-bit
  2.  Deployment
  3.  TX Control
Steen Jakobsen Steen Jakobsen
  1. Beta Testing
Deploy 64bit PB app
  1. How-to
  1. Last updated 3 years ago
  2.  Steen Jakobsen replied 3 years ago
1 reply
1461 views
0 votes
Hi   When deploying a 64bit PB application do I need all of the runtime files and folder or only the x64 folder? Thanks //Steen  
  1.  Deployment
  2.  PowerBuilder
  3.  PowerBuilder Runtime
Steen Jakobsen Steen Jakobsen
  1. Beta Testing
SaveNativePDFToBlob Abort
  1. Issue
  1. Last updated 3 years ago
  2.  Mark Lee @Appeon replied 3 years ago
2 replies
1533 views
0 votes
Our application is PB 2019 GA (Build 2082). Having recently upgraded from 12.5, we are still using Ghostscript and starting to move to NativePDF. We are trying SaveNativePDFToBlob on a really complex report with 29 nested reports. SaveNativePDFToB...
Roland Smith Roland Smith
  1. PowerBuilder
PowerBuilder 2019 R3 Installer does not work
  1. Resolved
  2. Issue
  1. Last updated 3 years ago
  2.  Chris Pollach @Appeon replied 3 years ago
5 replies
1708 views
0 votes
Hello, I am trying to test PowerBuilder 2019 R3, but the installer has an malware in it. I tried to install it in my work computer, and it presented an error. Then, i tried to install it in my personal computer, the Panda Antivirus catch the malwa...
Jhonns Salas Jhonns Salas
  1. Beta Testing
Local datastore - retrievestart
  1. Resolved
  2. How-to
  1. Last updated 3 years ago
  2.  Michał Misijuk replied 3 years ago
2 replies
1849 views
0 votes
Hello,The case is this: for every row in table A- I want to updates these records in table B, which points on A.ID What I've managed to do: - for ll_i = 1 to dw_a.RowCount()  if in b exists records for a get records from b do ds_b  ds_b.update  ds_b....
  1.  Event
  2.  PowerBuilder
  3.  Retrieve
  4.  DataStore
Michał Misijuk Michał Misijuk
  1. PowerBuilder
How to install the "Microsoft OLE DB Driver for SQL Server"
  1. Resolved
  2. How-to
  1. Last updated 3 years ago
  2.  Steen Jakobsen replied 3 years ago
2 replies
6053 views
0 votes
Hi, How do I the easiest way install the new "Microsoft OLE DB Driver for SQL Server" Would it be enough to simply copy the single dll (msoledbsql.dll) into ../system32 (or the 32bit version into SysWOW64 for 32 bit pb apps) ? This link explains t...
  1.  Installation
  2.  SQL Server
Steen Jakobsen Steen Jakobsen
  1. Beta Testing
ole excel - Want to Find the last column Cell in a excel(Result should be for ex: Y6)
  1. Advice
  1. Last updated 3 years ago
  2.  Miguel Leeuwe replied 3 years ago
5 replies
2857 views
0 votes
Regarding Ole excel - powerbuilder script I Want to Find the last column Cell in a excel(Result should be for ex: Y6 or Z10) using the below usedrange, script i can able to get the total columns and total rows ll_xls_cols = excel.worksheets(1).Use...
  1.  OLE
Sankar AR Sankar AR
  1. PowerBuilder
Beta 2019 R3 - Error deploying Powerclient c/s App - Failed to split PBD files.
  1. Issue
  1. Last updated 3 years ago
  2.  Enrico Fuoti replied 3 years ago
1 reply
1558 views
0 votes
When try to deploy my application with the new PowerClient c/s deployment feature, after compiling the pbd files, deployment fails with the error message: Failed to split the PBD files Failed to publish the PowerClient app The app it's rather big....
Enrico Fuoti Enrico Fuoti
  1. Beta Testing

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