One PDF capability that still hasn't been introduced as a native feature in PowerBuilder is the ability to merge PDF files. We're going to look at how we can easily add that capability using the open source (LGPL) PoDoFo library.
Tech Articles
Create Multiple DSNs from a single PostgreSQL Driver
FYI -
Summary:
You can create multiple databases from a single PostgreSQL driver.
Details:
PowerBuilder R2019R3
PostgreSQL 12
Windows 10
These instructions assume that at least one PostgreSQL driver has been successfully installed onto the Windows 10 platform.
Defining a PostgreSQL Database Profile in PB2019R3
PB2019R3
PostgreSQL v12 database
Summary:
Ensure that the database properties are defined correctly for the PostgreSQL database in the DB Painter.
If those properties are not defined correctly, the PB2019R3 IDE automatically creates the PB Catalog tables in the "public" schema every time it connects to the PostgreSQL (PG) database even if the catalog tables are already defined in the named "PowerBuilder Catalog Table Owner" schema.
Call SOAP Web Services Using HTTPClient Object
Since PowerBuilder 2017 R2, we have a new HTTPClient object, which is a base object for sending HTTP requests and receiving HTTP responses from a resource identified by a URI. Compared to the Inet object, the HTTPClient object is easier to use and supports more methods (Get/Post/Put/Delete) and more SSL protocols (TLS 1.0, TLS 1.1, TLS 1.2, SSL 2.0, and SSL 3.0).
Among other things, the HTTPClient can be also used to consume SOAP Web services. This is particularly useful as the Web Service Proxy has many limitations and defects calling SOAP Web services such as not supporting TLS 1.2. This article is to show how you can use the new HTTPClient to call your existing SOAP Web services instead.
Generating a QR code using QRCoder
QRCoder is an open source .Net assembly for creating QR Codes. What we're going to do is wrap that with an assembly in SnapDevelop we can use from PowerBuilder. First thing we need to do is create a .Net standard Class Library project in SnapDevelop.
Git for a single developer
Let's say you're an independent contractor or a one person shop. You want to take advantage of the source control features of Git, but you don't want to have to set up a server just for one developer. Fortunately, you don't have to. We're going to walk through the steps of connecting PowerBuilder to a local directory based repository.
Detecting a smart card insertion/removal from PowerBuilder
This is a follow up article to an earlier article I wrote called Communication with a smart card from PowerBuilder. In that article I showed how to interact with a smart card once it was inserted in the reader. In this article, we're going to look at how we can monitor the card reader to determine when the user inserts or removes a smart card from it.