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
22123 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
5360 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
Web Service Not Working
  1. Resolved
  2. Advice
  1. Last updated 5 years ago
  2.  Antony Xavier replied 5 years ago
6 replies
2023 views
0 votes
Hi Gurus, I have web service, which was in Old version (pb 10.5) and convert to pb2017r3 , it is working from Design Runtime(Exe) . When I convert to web I changed the code and using "appeonwebservicecomponent" as mentioned in the help, it is not w...
Antony Xavier Antony Xavier
  1. PowerServer 2020 or older (Obsolete)
Powerbuilder 2019 - MS SQL Server - DB Error - SPs not returning values
  1. Resolved
  2. Advice
  1. Last updated 5 years ago
  2.  John J replied 5 years ago
1 reply
3304 views
0 votes
Hi All, I'm trialing PowerBuilder 2019 to upgrade an existing application currently on PB9. Did an auto upgrade using PB2019 and everything compiled well. Modified the code block to connect to MS SQL 2014 DB using OLE DB (I assume thats the best cho...
  1.  Database Driver
  2.  Database Profile
  3.  OLEDB
  4.  PowerBuilder
John J John J
  1. PowerBuilder
HTML in RTE Control
  1. How-to
  1. Last updated 5 years ago
  2.  Louis Mancini replied 5 years ago
3 replies
2733 views
0 votes
I have html in a column in a sql table and need to display it with all its formatting in a RTE control that I'm using to generate a RTF word document.   Is this possible?  Any ideas?   Thanks, Lou
Louis Mancini Louis Mancini
  1. PowerBuilder
PowerBuilder crash debug
  1. Misc
  1. Last updated 5 years ago
  2.  Rodrigo Rosa replied 5 years ago
6 replies
2681 views
0 votes
Hi everyone, I have a problem with PowerBuilder 2017R3 IDE. When i start debug, the IDE has crash. The button to debug disable and the IDE close. The event log from windows it is like this:   Nome do aplicativo com falha: PB170.EXE, versão: ...
  1.  Error
  2.  PowerBuilder
Rodrigo Rosa Rodrigo Rosa
  1. PowerBuilder
FindFirstFileA Windows API works on WIN7 but not WIN10
  1. Issue
  1. Last updated 5 years ago
  2.  Chris Pollach @Appeon replied 5 years ago
3 replies
2908 views
0 votes
Hello, We're moving PB 2017 application from WIN7 to WIN10.  One of the processes in that app is to process files in a given directory/folder.  Currently on WIN7 we use 'FindFirstFileA' WIN API to start the processing which works....returned value/h...
David Haas David Haas
  1. PowerBuilder
REST-Client PB 2017
  1. Resolved
  2. Issue
  1. Last updated 5 years ago
  2.  Marco Meoni replied 5 years ago
1 reply
2088 views
0 votes
In PowerBuilder 2019, the way to connect a Rest-Api is with this:   Application Window--client= CREATE RESTClientclient.SetRequestHeader("Content-Type","application/json")client.SetRequestHeader("Accept-Encoding","gzip") Function Window-- String ...
Samuel Sanchez Avila Samuel Sanchez Avila
  1. PowerBuilder
Oracle ORA-01013 error from ExecuteProcedure
  1. Resolved
  2. Issue
  1. Last updated 5 years ago
  2.  Miller Rhodes replied 5 years ago
2 replies
2267 views
0 votes
We have using SnapDevelop quite successfully on a project where the middle tier connects to an Oracle database.   I have a process that is run from an Oracle procedure that takes about 30 seconds to complete if run from within Toad or another SQL t...
Miller Rhodes Miller Rhodes
  1. SnapObjects
Upgrade from PopwerBuilder 9.5 to current version
  1. Advice
  1. Last updated 5 years ago
  2.  David Peace (Powersoft) replied 5 years ago
5 replies
2373 views
0 votes
Hi, My organisation has a 2-Tier PowerBuilder App last upgraded to PowerBuilder 9.5 in 2012. I am looking at upgrading it to a the latest version of PowerBuilder. Will the latest version of PowerBuilder be able to compile this quite old application...
  1.  Upgrade
  2.  Versioning
Ben Higgins Ben Higgins
  1. PowerBuilder
Automated Get latest with stand alone compiler.
  1. How-to
  1. Last updated 5 years ago
  2.  Jan Hoppe replied 5 years ago
3 replies
1758 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 5 years ago
  2.  Miguel Leeuwe replied 5 years ago
3 replies
1860 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 5 years ago
  2.  Chris Pollach @Appeon replied 5 years ago
2 replies
2090 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 5 years ago
  2.  Chris Pollach @Appeon replied 5 years ago
4 replies
1932 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 5 years ago
  2.  Kevin Ridley replied 5 years ago
2 replies
1650 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 5 years ago
  2.  Sivaprakash BKR replied 5 years ago
2 replies
1940 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 5 years ago
  2.  Rolf Knaden replied 5 years ago
6 replies
4661 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 5 years ago
  2.  Olan Knight replied 5 years ago
1 reply
1857 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 5 years ago
  2.  Yasir Masood replied 5 years ago
4 replies
2681 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 5 years ago
  2.  marco gaspar replied 5 years ago
3 replies
1934 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 5 years ago
  2.  Jon Tzeng replied 5 years ago
3 replies
1884 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 5 years ago
  2.  Chris Pollach @Appeon replied 5 years ago
4 replies
2209 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

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