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
22111 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
5347 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
Time interval overlap in hours
  1. Issue
  1. Last updated 6 years ago
  2.  Michael Kramer replied 6 years ago
2 replies
2880 views
0 votes
How can you determine the overlap in hours between two time intervals?   time interval 1: (starttime1 and endtime1) and time interval 2:  (starttime2 and endtime2) What is the overlap between these 2 different intervals.
  1.  TIME
Paul Shue Paul Shue
  1. PowerBuilder
PB2017 R2 build 1756 has no REST Client project
  1. Issue
  1. Last updated 6 years ago
  2.  Bruce Armstrong replied 6 years ago
5 replies
2767 views
0 votes
I am currently following the video https://www.youtube.com/watch?v=-upeWlrlSN4 for consuming a REST service using the REST client for a POC to show the PHB so we can upgrade to PB2017.  the video says to use File/New and select the REST client proxy ...
  1.  Client
Kevin Ridley Kevin Ridley
  1. PowerBuilder
SoapException -There is an error in XML document (1, 391).
  1. Issue
  1. Last updated 6 years ago
  2.  Bruce Armstrong replied 6 years ago
2 replies
2824 views
0 votes
PB2017 R2 build 1756 - Im trying to consume a BizTalk service.  Its a very simple person search service, where I pass a person id.  The response is generic for when we want to add name search etc, so it returns an array of person.  Not sure why, but ...
  1.  Build
  2.  Service
Kevin Ridley Kevin Ridley
  1. PowerBuilder
Add new library to project library list
  1. Resolved
  2. Issue
  1. Last updated 6 years ago
  2.  Chris Pollach @Appeon replied 6 years ago
1 reply
2517 views
0 votes
I created a new library to contain objects while Im developing them.  I updated the Target library list, but my project (which builds and compiles everything) doesnt include this new library to be included.  I couldnt find anything in the application...
  1.  Library
Tracy Lamb Tracy Lamb
  1. PowerBuilder
DBError of datastore
  1. Resolved
  2. Issue
  1. Last updated 6 years ago
  2.  René Ullrich replied 6 years ago
1 reply
3763 views
0 votes
Hi, Where and how can I track DBError of SQLCA transaction object when Im using Datastore? In Datawindow there is dberror event but how to do it with datastores? BR, Hannu  
  1.  Data
Hannu Pikkarainen Hannu Pikkarainen
  1. PowerBuilder
dddw with retrieval argument
  1. Resolved
  2. Issue
  1. Last updated 6 years ago
  2.  Marco Meoni replied 6 years ago
2 replies
5645 views
0 votes
My dw has a column with the dddw edit format.  The dddw requires a retrieval argument to isolate records from another table that only apply to the master record.  The retrieval argument is different from the data column specified from the master wind...
Tracy Lamb Tracy Lamb
  1. PowerBuilder
Documentation of Web Service
  1. Issue
  1. Last updated 6 years ago
  2.  Marco Meoni replied 6 years ago
1 reply
2446 views
0 votes
Im developing a web service in powerbuilder and I do not know how to say it so that when the list of functions is displayed, the input and output parameters appear, does anyone know how to do it?
  1.  Documentation
Carlos Romero Carlos Romero
  1. PowerBuilder
Generate Json File from datawindow is not working properly
  1. Resolved
  2. Issue
  1. Last updated 6 years ago
  2.  mike S replied 6 years ago
2 replies
2866 views
0 votes
Hi,   Here is my code for generating JSON file from datawindow. it shows some issues. The out put should show like below  [ { "postId": 1, "id": 1, "name": "id labore ex et quam laborum", "email": "Eliseo@gardner....
  1.  JSON
SHIJILESH CHERROT SHIJILESH CHERROT
  1. PowerBuilder
DisableBind=0 and reused parameter.
  1. Issue
  1. Last updated 6 years ago
  2.  Alfredo Aldama replied 6 years ago
2 replies
2982 views
0 votes
Hi After finding out about the DisableBind=0 setting in an earlier question (https://community.appeon.com/index.php/qna/q-a/parametrized-query-execution) I've been experimenting with it for a while. (using SNC11 on SQL Server 2012) One particular t...
Markus Eckert Markus Eckert
  1. PowerBuilder
How best to publish parts of PB application to a web interface?
  1. Issue
  1. Last updated 6 years ago
  2.  Chris Pollach @Appeon replied 6 years ago
2 replies
2136 views
0 votes
Hi,  SQL Anywhere 16 / PB 2017 R2 #1756 We have a comprehensive Win32 system that we have been maintaining for quite a few years, but are looking at possibilities of starting to port some of the crucial segments of it to a web interface, at fir...
  1.  Build
Vlad V. Vlad V.
  1. PowerBuilder
how to change the technical name to some readable name in the datawindow extraction in excel
  1. Issue
  1. Last updated 6 years ago
  2.  Chris Pollach @Appeon replied 6 years ago
1 reply
2112 views
0 votes
Hi, My requirement is that when user save the data in excel from the data window then its technical name changed to proper name.. Where to make changes..   Please help..
  1.  Build
radha rani radha rani
  1. PowerBuilder
Any differences between J2EE vs .NET deployments?
  1. Issue
  1. Last updated 6 years ago
  2.  Andres Slachevsky replied 6 years ago
2 replies
2174 views
0 votes
Hi everyone, Could you please point me to any documents (if available) to learn what could be the difference (in terms of supported functionality) between J2EE vs .NET migrations to WEB?
  1.  PowerServer
7013022 2203107 7013022 2203107
  1. PowerServer 2020 or older (Obsolete)
Using FindFirstFileA against a 64bit server directory
  1. Issue
  1. Last updated 6 years ago
  2.  Roland Smith replied 6 years ago
3 replies
3923 views
0 votes
My PowerBuilder app is using Appeon 2017 R2 Build 1756 with PFC. The pfc_n_cst_filesrvwin32 object has a function of_dirlist() which lists all the files in a directory. It uses the Win API calls FindFirstFileA() and FindNextFileA(). The first a...
  1.  File
Larry Peters Larry Peters
  1. PowerBuilder
GetOpenFileName/GetSaveFileName Windows Common Dialogs
  1. Issue
  1. Last updated 6 years ago
  2.  Chris Pollach @Appeon replied 6 years ago
1 reply
3760 views
0 votes
With my PB 12.5 app, I had coded a call to the Windows API GetOpenFileName function that worked perfectly. When I compile that same app in PB 2017 64Bit, it doesnt work because of a structure size error. Can you point me to some code (or someone) tha...
  1.  API
  2.  COM
  3.  File
Timothy Beck Timothy Beck
  1. PowerBuilder
hosting for Appeon web application
  1. Issue
  1. Last updated 6 years ago
  2.  Chris Pollach @Appeon replied 6 years ago
1 reply
2303 views
0 votes
Can anyone recommend a good hosting service for our appeon web application. The app uses .net and sybase ASA database. User base will be from 10 to 1000 concurrent users Our clients will be scattered around the USA and Canada  
  1.  Deployment
Robert Sleath Robert Sleath
  1. PowerServer 2020 or older (Obsolete)
External .pbx file - Sending email from server
  1. Issue
  1. Last updated 6 years ago
  2.  Chris Pollach @Appeon replied 6 years ago
1 reply
2703 views
0 votes
I downloaded the .pbx file and Pb example from http://www.topwizprogramming.com/pbnismtp.html This all works in my desktop PB app but Im missing something deploying the app using AppeonWeb. What is required to deploy and use the .pbx file in th...
  1.  Email
  2.  PBX
Robert Sleath Robert Sleath
  1. PowerServer 2020 or older (Obsolete)
PB2017 support for GIT, How do we establish CI/CD with Bitbucket Pipelines as its free
  1. Issue
  1. Last updated 6 years ago
  2.  Bruce Armstrong replied 6 years ago
2 replies
3408 views
0 votes
Hi PB Tech gurus, In my current project we are planning to migrate the PB builds to integrate with Bitbucket Pipelines CI/CD as it is free. Currently, we are using Jenkins as build server for CI/CD process and we use PowerGen to generate PBLs f...
  1.  Git
  2.  TIME
Ibrahim Syed Ibrahim Syed
  1. PowerBuilder
JSonParser with more than 2 levels of data
  1. Resolved
  2. Issue
  1. Last updated 6 years ago
  2.  Bruce Armstrong replied 6 years ago
1 reply
2660 views
0 votes
Hi, Could someone advice me how to access JSON-data in deeper levels, for example street and area in this example data. Im able to read upper level like location and formatted_address but how to access child data of address_components? { "re...
  1.  Data
Hannu Pikkarainen Hannu Pikkarainen
  1. PowerBuilder
How to find the database or table used in the datawindow.
  1. Issue
  1. Last updated 6 years ago
  2.  Chris Pollach @Appeon replied 6 years ago
1 reply
1964 views
0 votes
Hi everyone! Working on PB9 I need to do changes in one datawindow in which i need to add some more column , how can i find the table or database used in it from the powerbuilder. As column is selected from insert-->coulmn and then popup ...
  1.  Build
radha rani radha rani
  1. PowerBuilder
Powerbuilder IDE performs a redundant initial commit
  1. Issue
  1. Last updated 6 years ago
  2.  Chris Pollach @Appeon replied 6 years ago
1 reply
2039 views
0 votes
  After a developer clones the repository. Then opens the Powerbuilder IDE and selects the .pbw file via "Open Workspace". Next, when the project is added through the IDE for version control, the IDE executes an unnecessarily empty commit. What fo...
  1.  Build
  2.  Git
Tareq Haschemi Tareq Haschemi
  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