Tech Articles


Communication with a smart card from PowerBuilder


12/26/2021 Update:  A PowerBuilder 2021 sample app that includes all of the following code is available in CodeXchange at: https://community.appeon.com/index.php/codeexchange/powerbuilder/306-reading-a-smard-card-from-powerbuilder

We’re going to look at using the Smart Card SDK provided in more recent versions of Windows (XP and later).  Earlier versions of Windows had an ActiveX installed called CAPICOM which could be accessed from PowerBuilder through OLE Automation, but that control was removed as of Windows Vista because of security issues.

We’re going to look at a number of operations:

·         Communication with the card

·         Validating the user’s PIN

·         Reading the certificate Subject Name

·         Reading other certificate data

 
Note:  This post was updated on December 8th, 2021 to support 64 bit compilation.  Thanks to Jason Schultz for pointing out the problem and to John Fauss and others for pointing out the necessary changes.

 

Communicating with the card

The first step is establish a context for the API calls.  To do that, we need to declare the following local external function for SCardEstablishContext:

Function ulong SCardEstablishContext  ( &

  ulong dwScope, &

  longptr pvReserved1, &

  longptr pvReserved2, &

  REF longptr phContext &

  ) Library "winscard.dll"

 

And call it as follows:

ulong    rc

rc = scardestablishcontext( SCARD_SCOPE_USER, 0, 0, context )

IF rc = SCARD_S_SUCCESS THEN

    Return SUCCESS

ELSE

    Return FAILURE

END IF

 

Read more

Using Autoincrementing Columns from a PowerBuilder DataWindow


Note:  This blog entry is basically the written version of a video I did for the SAP Database and Technology Academy.  You can either watch the video or read the blog entry, or both if you're so inclined.

 

 

Read more

Merging PDF files using PoDoFo


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.

Read more

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.

Read more

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.

 

Read more

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. 

Read more

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.

Read more

Find Articles by Tag

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