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
22121 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
5357 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
Adjust font size according to field size in datawindow
  1. How-to
  1. Last updated 1 year ago
  2.  Chris Pollach @Appeon replied 1 year ago
1 reply
918 views
0 votes
Best regard. Is there a way to auto-adjust the font size in a datawindow field? This is in order not to enlarge the size of the field or column of the datawindow, but rather to adjust the font size. I require it, because I do not want the dimensio...
JOSE WILLIAM ROMERO OLIVOS JOSE WILLIAM ROMERO OLIVOS
  1. PowerBuilder
Datawindow SaveAS doesn't populate the Program Name of the excel file.
  1. Resolved
  2. How-to
  1. Last updated 1 year ago
  2.  Mark Goldsmith replied 1 year ago
7 replies
1295 views
0 votes
Does anyone know how i can make the datawindow saveas functionality creates the excel file with the Program Name populated with Microsoft Excel?  I'm saving my dw data to excel file and wants to use Syncfusion to open and manipulate the file as ne...
Catherine Canete Catherine Canete
  1. PowerBuilder
What ever happened to the Community Edition of Appeon products
  1. Issue
  1. Last updated 6 years ago
  2.  Miguel Leeuwe replied 1 year ago
1 reply
3409 views
4 votes
Last year there was indication of a community version of Appeon Powerbuilder. This would be inline with most of the other development platforms where there are low cost or no cost developer versions.  These types of licenses are important in several ...
  1.  COM
· tom · tom
  1. PowerBuilder
Get handle from Parent Process (C#) to Execute Child Process(PB application)
  1. Resolved
  2. How-to
  1. Last updated 1 year ago
  2.  Miguel Leeuwe replied 1 year ago
4 replies
1371 views
0 votes
  Our C# application needs to use a specific business feature within a PowerBuilder application. As advised by our technical team, the C# application will send instructions to the PowerBuilder application using commands. The PowerBuilder application...
  1.  C#
  2.  Command Line
  3.  PowerBuilder (Appeon)
  4.  PowerBuilder Runtime
Rajkumar Paramasivam Rajkumar Paramasivam
  1. PowerBuilder
Logging Embedded SQL in sqlpreview of a transaction object.
  1. Resolved
  2. How-to
  1. Last updated 1 year ago
  2.  Miguel Leeuwe replied 1 year ago
2 replies
909 views
0 votes
Hi all, I have a transaction (n_tr) object that uses its sqlpreview event to log all embedded SQL, to w_sqlspy (PFC classes). It works great, but I'd like to get information of where this embedded sql came from. It is really difficult to simply loo...
Miguel Leeuwe Miguel Leeuwe
  1. PowerBuilder
Is there a C# equivalent for PrintOpen()?
  1. Misc
  1. Last updated 1 year ago
  2.  Francisco Martinez @Appeon replied 1 year ago
1 reply
969 views
0 votes
In PB, I have a print feature to print a string directly to a Zebra label printer.  The string includes Escape characters with formatting commands. It works great in my PB app. ll_job = PrintOpen("Label",TRUE) li_rc = Print(ll_job, ls_ZPL) li_rc =...
  1.  C#
  2.  PowerBuilder (Appeon)
Tracy Lamb Tracy Lamb
  1. PowerBuilder
Question about canceldialog when printing from a DataStore
  1. Resolved
  2. Misc
  1. Last updated 1 year ago
  2.  Chris Pollach @Appeon replied 1 year ago
3 replies
672 views
0 votes
The reference for the Print method when printing a single DataWindow or DataStore states that for DataStores, "the canceldialog argument must always be set to false." Why is that? Link to reference page: https://docs.appeon.com/pb2022/datawindow_re...
Troy Cowan Troy Cowan
  1. PowerBuilder
Datetime or Date input parameter gives error in Datawindow retrieval.
  1. Issue
  1. Last updated 1 year ago
  2.  Chris Pollach @Appeon replied 1 year ago
2 replies
854 views
0 votes
I have a datawindow for report which has an argument of datatype DATETIME, and datasource as SQL Server 2019. The argument is related to table column of datatype datetime2. When I try to retrieve the report, I get an error as : When I try to conve...
Santosh Natal Santosh Natal
  1. PowerBuilder
Impact of Missing Datawindow on Dropdown Column
  1. Resolved
  2. How-to
  1. Last updated 1 year ago
  2.  Chris Pollach @Appeon replied 1 year ago
2 replies
651 views
0 votes
Hi Experts,   In PowerBuilder, when I define a datawindow (for example: d_city) for a dropdown column in my application, and at the time of assigning the datawindow to the column, the datawindow exists in my source code. Unfortunately, if the defin...
Deva Shanmuga Deva Shanmuga
  1. PowerBuilder
pbm_custom01 isn't triggered
  1. How-to
  1. Last updated 1 year ago
  2.  Roland Smith replied 1 year ago
4 replies
863 views
0 votes
Hello, I run .NET application from powerbuilder application, and send window's hadle as parameter from window's function, so: via RUN("NETAPP.EXE "  + String(Hanlde(this))) in .netr application, I send message by SendMessageA function, the handle ...
C K C K
  1. PowerBuilder
Select column including dash character - in embedded sql powerscript
  1. How-to
  1. Last updated 1 year ago
  2.  yaacov shamla replied 1 year ago
4 replies
715 views
0 votes
In order to select a db column which name including dash character -, the column need to be enclosed with brackets for example [COUNTRY-NAME].In embedded sql powerscript, selecting the column with brakets causes db error.Is there any way to select th...
yaacov shamla yaacov shamla
  1. PowerBuilder
[APPEON MOBILE] SHA256 encryption error question - Appeon PowerBuilder 2019 R3
  1. Resolved
  2. How-to
  1. Last updated 1 year ago
  2.  Shin Jungi replied 1 year ago
6 replies
971 views
0 votes
Hi, how are you?This is the source code written in Appeon PowerBuilder 2019 R3 version.[ Source Code ] Blob lblb_dataBlob lblb_sha1String ls_data lblb_data = Blob("Test SHA1", EncodingANSI!) CrypterObject lnv_CrypterObjectlnv_CrypterObject = Creat...
  1.  Appeon Workspace
Shin Jungi Shin Jungi
  1. PowerBuilder
Datawindow save as pdf image not displaying
  1. How-to
  1. Last updated 1 year ago
  2.  Avory Rose Pastoral replied 1 year ago
4 replies
1357 views
0 votes
Hi,   I am exporting pdf using the following script:   dw_printer.Modify("DataWindow.Export.PDF.Method = NativePDF!") dw_printer.Modify("DataWindow.Export.PDF.NativePDF.ImageFormat = '2'") dw_printer.SaveAs(s_newfilename, PDF!, FALSE) dw_printer...
  1.  DataWindow
  2.  PB Classic
  3.  PDF
  4.  PowerBuilder
Avory Rose Pastoral Avory Rose Pastoral
  1. PowerBuilder
DataWindow .Update executes but record is not inserted
  1. How-to
  1. Last updated 1 year ago
  2.  Sivaprakash BKR replied 1 year ago
8 replies
891 views
0 votes
Power Builder 2019 R3 Windows 11 Enterprise SQL Server 2019   I have a datawindow where I should be able to add a new record.  The Update fires and I can see the insert statement in the Sql Server Profiler but the data never makes it to the table...
Tim Bruce Tim Bruce
  1. PowerBuilder
SendMessage text from C# to PowerBuilder
  1. How-to
  1. Last updated 1 year ago
  2.  Arnd Schmidt replied 1 year ago
4 replies
951 views
0 votes
Hello, I have to send a text(string) message from C# application to PowerBuilder application via SendMessage function. When i sent as a followinf code, Powerbulder's Message object doesnt got the stringparam' only long param C# code: SendMessageW(...
C K C K
  1. PowerBuilder
Compiler Error moving project from PB2019 to PB2022
  1. Resolved
  2. Advice
  1. Last updated 1 year ago
  2.  Chris Pollach @Appeon replied 1 year ago
1 reply
850 views
0 votes
Hello, I am moving a application from PB2019 to PB2022. After migrating the project I get the following errors... ---------- Compiler: Errors (11:02:27 AM)pims_base.pbl(u_module_page).u_module_page.Instance Variables.14: Error C0101: Referenced obj...
Mike Kochevar Mike Kochevar
  1. PowerBuilder
SymmetricDecrypt - replicate in c# to decrypt value from PB
  1. Resolved
  2. Misc
  1. Last updated 1 year ago
0 replies
628 views
2 votes
I need to decrypt a password in c# that i both encrypt and decrypt in PB.  It took a while to figure out and the following works.  the value to decrypt is ls_encrypted (base64 string) and the decryption key is: is_symkey     PB:lblb_pwrdencypted ...
mike S mike S
  1. PowerBuilder
64-Bit PB using MailSession and 64-Bit Outlook
  1. Resolved
  2. Advice
  1. Last updated 1 year ago
  2.  Chris Pollach @Appeon replied 1 year ago
1 reply
804 views
0 votes
Hi Everyone I'm looking to use PB2022 deploying to 64-Bit EXE and was wondering if anyone has successfully used this to create a 64-Bit mailSession to access Outlook/Office 365 via 64-bit MAPI? In theory it should just work, but thought I would ask...
  1.  PowerBuilder
David Peace (Powersoft) David Peace (Powersoft)
  1. PowerBuilder
Power 2019 R3: webservice Token using certificate
  1. How-to
  1. Last updated 1 year ago
0 replies
784 views
0 votes
Hi all.   I need to request for a token from a webservice, but it's using a certificate (file in a folder and password for validation). I know it's already implemented in PowerBuilder 2022 as I've been able to test, but in production environment I...
  1.  PowerBuilder (Appeon)
  2.  REST
ANTONIO MACIAS NOGALES ANTONIO MACIAS NOGALES
  1. PowerBuilder
Remove datawindow title bar but not the column headings
  1. Issue
  1. Last updated 1 year ago
  2.  Miguel Leeuwe replied 1 year ago
3 replies
897 views
0 votes
Is there a function in datawindow that I can use to remove header (title and other objects) but leave the column headers intact?  I tried adjusting header height but it leave the space from the top not the bottom of the header bar.  I need to change ...
  1.  DataWindow
  2.  Excel
  3.  Format
Raman Dhillon Raman Dhillon
  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