Tech Articles


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

Enabling Drag & Drop from Outlook


Enabling Drag & Drop from Outlook to PB using a 3rd Party (free) DLL

 

While trying to find a solution on how to be able to do a drag & drop from outlook into PB, I did find a DLL library from a 3rd party. The DLL was free to use (source code available to purchase) and it worked bot in x32 and x64 environments.

The reason why I'm posting this is that while searching from the internet for a solution, I didn't find that many useful pages. After two days of searching, I stumbled on this and thought thet other PB users can benefit from this.

The link to the DLL site is here https://www.catsoft.ch/#download

and on the page look for "Drag & Drop in PowerBuilder"

I have now other association to the 3rd party, other than that I use the DLL. I also askes permission for the posting from the 3rd party.

I'm happy with the DLL, and the users of our product also like the possibility to drag & drop emails or just a sibgle attachemnt, directly from Outlook to the PB application.

 

Kari

 

Find Articles by Tag

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