Tech Articles


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

 

NULL Handling in C# vs. PowerScript/SQL


C# handles NULL quite different than PowerScript and SQL.
Same code in PowerScript and C# may have different outcome.

 

Read more

Implementing OAuth 2.0 Authorization with PowerBuilder 2019 R2


Introduction

PowerBuilder supports getting secured data from the OAuth 2.0 authorization server. The Bearer access token is supported, and the following grant types are supported:

  • Authorization Code
  • Implicit Flow
  • Client Credentials
  • Extension (or Refresh Token)
  • Resource Owner Password

This document provides an example on how to set up OAuth 2.0 authorization workflow using the Authorization Code grant type in a PowerBuilder application.

Read more

How to Define Events for RibbonBar Controls


Learning to define user events for items in the RibbonBar control feels like a lot of trial and error.
Different items support different events. Same event type requires different parameters.
My aim with this article is to take "... and error" out of your RibbonBar coding.
For each ribbon item type you get user event definitions that work.

 

 

      

Each ribbon item has its own XML element (here: Print Title is a CheckBox).
Each item binds specific user events via properties (here: Clicked on CheckBox binds to ue_PrintTitle)
Each user event must have the correct parameter list (here: Clicked event for CheckBox always requires al_handle while no other parameters allowed)
Each item type has its own PowerScript class and functions to obtain the object (here: Obtain class = RibbonCheckBoxItem via function GetCheckBox)
 

Read more

Enhanced JSON handling


Why enhance JSON handling?

Reading and writing JSON in PowerBuilder is simple using PowerBuilder’s RESTClient object; however, the JSON needs to be in a two-dimensional format. But there are times when the JSON you are working with has multiple nested levels, especially if working with data from an external interface not under your control.

The PowerBuilder objects JSONParser and JSONGenerator can be used to parse or generate such JSON with multiple nested levels.  However, a key caveat is that the JSONParser and JSONGenerator require the JSON data to be accessed through “handles”.  For example, the getItemObject() returns a handle rather than the full JSON object.  Compared to an object-based approach, this handle-based approach requires more coding by the developer.

Read more

Powerbuilder 2019 on Linux


 

From Windows to Linux 

Did you know that Powerbuilder 2019 could run on Linux ?

Since Powerbuilder 2019 is now in 64 bit, it is now a lot easier to run on Linux using wine64

Read more

How to deal with the error 'No Network Connection' on logon to PowerBuilder


ISSUE: Receive error “No Network Connection” on logon to PowerBuilder

 

SYMPTOM: Error “No Network Connection” was received on every attempt to open PowerBuilder and occurs immediately on version installation. Experienced on install of  V19 - but may be experienced in other versions.  When initiating PowerBuilder process hangs for a long time and then returns a message “No Network Connection”. You exit and the application closes.

Read more

Find Articles by Tag

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