Tech Articles


Applying a New UI Theme to Your Application


This tutorial is an update to the 2019 tutorial. If you have zero experience with the UI Theme feature, please first follow our Quick Start tutorial. If you are ready to gain a comprehensive understanding of this feature and dive deeper into UI Theme settings, then please proceed with this updated tutorial.

Starting from PowerBuilder 2019, Appeon added the UI theme feature to PowerBuilder so that developers can codelessly control how commonly-used controls and objects render during application runtime.

Read more

UI Theme Quick Start Tutorial


This quick start tutorial walks you through the 3 simple steps to apply the UI Theme to your PowerBuilder application. For more advanced techniques, such as how to define a customized theme and how to define theme settings for selected objects/controls, you may refer to the advanced tutorial: https://community.appeon.com/index.php/articles-blogs/tutorials-articles/2-powerbuilder/301-applying-a-new-ui-theme-to-your-application-2.

Read more

Como Instalar PowerBuilder 2019 R2


 En este vídeo veremos los requisitos de hardware para instalar PowerBuilder 2019 R2, como se descarga la versión trial y como es el proceso de instalación.

 

Read more

RibbonBar Menu Generator


I've uploaded a small utility (PowerBuilder source code) to CodeXchange here that you can run on the menus in your applications and create RibbonBar XML based on them.  It's intended to quick start your migration from existing menus to the RibbonBar  I'm expecting that you're going to want to tweak the output somewhat after it's generated.  however, it is a whole lot better from having to create them from scratch. 

Read more

How to use HTTPClient or RESTClient to call an API with basic authentication


Background

Almost every API requires some sort of authentication. Basic authentication is the simplest way to handle authentication. Here we are going to do a simple example to show you how to use HTTPClient or RESTClient to call an API with basic authentication.

Access a simple API with basic authentication in IE

Let’s take a simple basic authentication API from the Internet as an example.

If we input https://jigsaw.w3.org/HTTP/Basic/ in IE and press Enter, then input Username: guest; Password: guest in the pop-up login window.

Read more

Call WCF Services Using HTTPClient or RESTClient Objects


Background

Prior to PowerBuilder 2017 R2, the SoapClient did not support calling WCF Services.

In PowerBuilder 2017 R2 and the latter versions, the HTTPClient object is available, through which you can call WCF Services.

In PowerBuilder 2019, the RESTClient object is strengthened, now you can also call the WCF Services.

 

How to use HTTPClient object to consume a WCF Service

      a. To get the methods and parameters to consume the WCF Service.

Normally when you open a WCF Service website, you will get the following page:

Read more

Exporting Datawindows to Excel / Html without losing Format


I have a function called "GuardarAExcel2()" which uses a step datawindow called "d_filafichero". With this function you generate an excel with the same visual aspect as your datawindow. I hope it helps you:

Example of use:

GuardarAExcel2( dw_1, "c:\Report.xls")
GuardarAExcel2( dw_1, "c:\Report.html")

Result in datawindow:

 

Read more

Find Articles by Tag

Debugger RESTClient Text Export JSON Window Database Object CoderObject Database Table Schema Mobile Data PostgreSQL OrcaScript Automated Testing PowerBuilder REST Deployment DataType 32-bit Oracle Branch & Merge Filter PFC Transaction PDF Menu .NET Assembly Event Handling Bug Variable .NET DataStore C# SqlModelMapper SVN License Application Encryption Database Table Visual Studio Database Connection JSON Encoding Git JSONParser PostgreSQL ODBC driver Android Syntax TLS/SSL GhostScript Stored Procedure UI Themes PowerServer Mobile Model .NET Std Framework SQL Testing DragDrop SnapObjects DataWindow JSON Design Outlook Database Table Data Azure Expression OAuth 2.0 TreeView Validation WinAPI RibbonBar Source Code Debug OLE PowerBuilder (Appeon) Authorization Repository HTTPClient JSONGenerator Installation Platform Debugging Import NativePDF DLL OAuth API Event Handler SnapDevelop Migration BLOB SOAP PowerScript (PS) Messagging ActiveX SqlExecutor Class WebBrowser SDK UI Modernization Authentication Linux OS Service UI Excel Database Profile RibbonBar Builder 64-bit Sort Error Elevate Conference Database PDFlib PowerServer Web Database Painter PBDOM Export Windows 10 Icons Web Service Proxy Open Source DataWindow IDE Trial Icon PBVM DevOps CI/CD Event Charts Resize External Functions InfoMaker RichTextEdit Control Array PowerBuilder Compiler TFS Interface TortoiseGit CrypterObject Performance File Source Control Jenkins Script iOS Web API Import JSON Configuration PBNI XML Windows OS ODBC COM MessageBox Graph SQL Server