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
19366 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
5009 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
Automated Get latest with stand alone compiler.
  1. How-to
  1. Last updated 4 years ago
  2.  Jan Hoppe replied 4 years ago
3 replies
1614 views
0 votes
The "stand alone compiler" option seems very nice, but we need to get the PBL's updated from TFS as well, does anybody know if an automated "Get Latest" or similar is also possible?
Jan Hoppe Jan Hoppe
  1. PowerBuilder
Error due to structure changing definition
  1. Resolved
  2. Issue
  1. Last updated 4 years ago
  2.  Miguel Leeuwe replied 4 years ago
3 replies
1678 views
0 votes
PB2017r3 Windows 10 I had an issue that I have not seen before.  I did not see anything in the questions and answers about it, I was wondering if anybody else has seen a similar issue. I have a window opened as a sheet.  This window, when a user c...
Rex Chivers Rex Chivers
  1. PowerBuilder
Photos/Images - PowerImage
  1. Issue
  1. Last updated 4 years ago
  2.  Chris Pollach @Appeon replied 4 years ago
2 replies
1913 views
0 votes
We are just starting to explore upgrading our applications from PowerBuidler 10.5 to PowerBuilder 2019.  We have a few applications that we use a 3rd party product 'PowerImage32' that was developed/sold by Visionary Solutions, Inc.  One of the applic...
Linda Butler Linda Butler
  1. PowerBuilder
PB2017 and PB2019 Native Source Control issue
  1. Resolved
  2. Issue
  1. Last updated 4 years ago
  2.  Chris Pollach @Appeon replied 4 years ago
4 replies
1762 views
0 votes
Hi there, i'm experiencing a strange behaviour using PB Native source control (PB2019 Build 2082).I'm working on an application migrated from pb2017 and it is like the second time that i grab an object using check out, modify it, then check in. Later...
Simone Olianti Simone Olianti
  1. PowerBuilder
Import Json DW
  1. How-to
  1. Last updated 4 years ago
  2.  Kevin Ridley replied 4 years ago
2 replies
1500 views
0 votes
Hi, How can I import a multiline Json with an array into a datawindow?[ { "id":123, "agendamentoTED":false, "usuario":"AUTOM", "id_ususario":20141, "idCanal":11, "codigoBancoDestino":1, "tipoConta":1, "codigoFinalidade":2, "array":[ { "nm_user":"...
  1.  PowerBuilder
  2.  PowerBuilder (Appeon)
Rodrigo Rosa Rodrigo Rosa
  1. PowerBuilder
Issue with generateguid in an executable
  1. How-to
  1. Last updated 4 years ago
  2.  Sivaprakash BKR replied 4 years ago
2 replies
1749 views
0 votes
I am having trouble creating a GUID on my executable. It works fine in development but it fails when I run it on an executable on any machine that I do not have PB installed.   OLEObject myoleobject myoleobject = CREATE OLEObject PBObject = CRE...
Rick Wolfgang Rick Wolfgang
  1. PowerBuilder
Saving datawindow to Excel using XLSX!
  1. Issue
  1. Last updated 4 years ago
  2.  Rolf Knaden replied 4 years ago
6 replies
4172 views
0 votes
Hi all, We have changed from saving datawindows to Excel using Excel8! to XLSX! and as a consequence the column widths in Excel have become extremely wide. The users now have to scroll far to the right in order to see the data and it is very annoyin...
Berit Sandvik Berit Sandvik
  1. PowerBuilder
Crosstab DW with stored procedure as source
  1. Issue
  1. Last updated 4 years ago
  2.  Olan Knight replied 4 years ago
1 reply
1688 views
0 votes
Hi all,  I wish you a happy new year. Using PB 12.5, 2017 and 2019. When defining a crosstab DW with a stored procedure as source, you cannot view the "column specification" panel so you cannot change anything about the stored procedure. You have ...
Philippe PILAT Philippe PILAT
  1. PowerBuilder
Clear Blob Data
  1. Resolved
  2. How-to
  1. Last updated 4 years ago
  2.  Yasir Masood replied 4 years ago
4 replies
2446 views
0 votes
Hi, I am using the following code to read data from a web service. However, i get the same Picture every time. How do i clear the Blob to get the new picture? I am using PB 2018 R3 Build 1858. Thanks http = create httpclientli_rc = http.ClearReq...
  1.  HTTPClient
  2.  PB Classic
Yasir Masood Yasir Masood
  1. PowerBuilder
Conversion PB 2017 to 2019
  1. How-to
  1. Last updated 4 years ago
  2.  marco gaspar replied 4 years ago
3 replies
1791 views
0 votes
Bom dia! Quando tento converter o PB 2017 para 2019 e executo em uma máquina, dá a seguinte mensagem de erro: GetTimeZoneInformationForYear na dll Kernel32.dll. Como devo proceder? Por favor. Grato! Good Morning! When I try to convert PB 2017 to 201...
marco gaspar marco gaspar
  1. PowerBuilder
How to install MR (Appeon PowerBuilder 2017 R3 build 1915) release on PowerServer
  1. How-to
  1. Last updated 4 years ago
  2.  Jon Tzeng replied 4 years ago
3 replies
1748 views
0 votes
I just installed Appeon PowerBuilder 2017 R3 MR build 1915. But when I check the version of my PowerServer (AEM), it is still build 1880. How can I upgrade PowerServer to build 1915. My PowerBuilder version is build 1915. Thanks, Jon
Jon Tzeng Jon Tzeng
  1. PowerServer 2020 or older (Obsolete)
error at insert a register in a table where primary key is a datetime
  1. Issue
  1. Last updated 4 years ago
  2.  Chris Pollach @Appeon replied 4 years ago
4 replies
2031 views
0 votes
I have this message when I try to save a register with a primary key formed by two columns (moneda char(1) , fecha datetime ).   The message is SQLSTATE = 42000 sintaxis incorrecta cerca de '00' no changes made to database   INSERT INTO CA ( MO...
RAFAEL RODRIGUEZ RAFAEL RODRIGUEZ
  1. PowerBuilder
Huge default width of columns in excel12-export of datawindow.
  1. Resolved
  2. Issue
  1. Last updated 4 years ago
  2.  John Fauss replied 4 years ago
1 reply
1988 views
0 votes
Hi. I am using PB 2017 R3 Build 1858. When exporting a datawindow to excel12 the width of the string-columns is huge (254,29), regardless of whether the column contains onbly short texts. When using excel8 for export the columns are only 10,71 wide...
  1.  DataWindow
  2.  Excel
  3.  Export
Rolf Knaden Rolf Knaden
  1. PowerBuilder
PB 2019 R2 Beta program
  1. Resolved
  2. How-to
  1. Last updated 4 years ago
  2.  Mariano Collado @Appeon replied 4 years ago
1 reply
1398 views
0 votes
Hello, all Is it possible to participate in the beta program for PB 2019 Beta? Currently we are heavy users of COMs and it is extremely important to us to access and, if possible, fix the limitations of the new versions when working with .NET assem...
  1.  PowerBuilder (Appeon)
Arcady Abramov Arcady Abramov
  1. Beta Testing
How to Generate QR Code from PowerBuilder offline?
  1. How-to
  1. Last updated 4 years ago
  2.  Sivaprakash BKR replied 4 years ago
1 reply
2295 views
0 votes
In India, from April 2020 - QR Code on every invoice is mandatory. How to print QR Code from application without Internet. ?   
  1.  PowerBuilder (Appeon)
Sripal Bachawat Sripal Bachawat
  1. PowerBuilder
How to compare a Date time field with other date time static date time object?
  1. Resolved
  2. How-to
  1. Last updated 4 years ago
  2.  John Fauss replied 4 years ago
4 replies
2292 views
0 votes
Happy New Years to All and thank You to all that replied to my last question. By the way I was able to display and save the current date and time correctly. [ 12/30/2019 7:50 am ] - field 4  Can You help me to compare this, date and time, data field...
Arthur Foux Arthur Foux
  1. PowerBuilder
Error with the PB 2017 R3 Build 1915
  1. Resolved
  2. How-to
  1. Last updated 4 years ago
  2.  Tom Jiang @Appeon replied 4 years ago
2 replies
1815 views
0 votes
I upgraded from PB 2017 R3 Build 1880 to Build 1915 (PWRBLDR-2017R3LTS-MR07-1915-EN) but now PB is not running. When I install the new build I get the following message: ---------------------------Self-Registration Error---------------------------T...
Eduardo G. Eduardo G.
  1. PowerBuilder
SAP Ultralite 17 on mobile app
  1. How-to
  1. Last updated 4 years ago
  2.  Kai Zhao @Appeon replied 4 years ago
1 reply
1588 views
0 votes
Hi, Since we have problems using SQLite on mobile app (bug 3787) and the Appeon doesn't know when the issue will be fixed (and the project deadline is comming soon) we would like to try SAP Ultralite on that project, but I'm not able to access the d...
Marcos Bolonha Marcos Bolonha
  1. PowerServer Mobile (Obsolete)
Re: Better event/place to inform users regarding DB errors
  1. Advice
  1. Last updated 4 years ago
  2.  Sivaprakash BKR replied 4 years ago
12 replies
2500 views
0 votes
Hello,  Using PB 2017 R3, Postgresql 11 Want to display better error message(s) to users, when error(s) returned by database.   All users can't understand message(s) like Primary key violation, check constraint error, Unique key violation etc.. Cu...
  1.  Error
  2.  PowerBuilder (Appeon)
Sivaprakash BKR Sivaprakash BKR
  1. PowerBuilder
PFC 64bit?
  1. Resolved
  2. Misc
  1. Last updated 4 years ago
  2.  Kyle Griffis replied 4 years ago
6 replies
1942 views
0 votes
Anyone know if there is a 64 bit version of the PFC?   Thanks ahead of time! Kyle  
Kyle Griffis Kyle Griffis
  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