Tech Articles


OLE - Extending the Capabilities of PowerBuilder Part 2


This two-part article provides a primer on OLE, some practical examples of its use, and demonstrates some methods for addressing the limitations of PowerBuilder's implementation of OLE.

In Part 1 I provided some background information for OLE and discussed the use of custom controls, in Part 2 I talk about OLE Automation and OLE objects.

OLE Automation
OLE Automation is the interface through which one application (e.g., Microsoft Outlook) makes the methods, properties, and events of its objects (e.g., Folders, Messages, Address Book) available for use within another application. Using OLE Automation, a developer could automate another application (e.g., creating and then printing form letters from Microsoft Word) or they may just use a portion of another application within their own (e.g., using the spell-check capability within Microsoft Word to spell-check text in a control within PowerBuilder).

Read more

OLE - Extending the capabilities of PowerBuilder Part 1


Using Object Linking and Embedding (OLE) from PowerBuilder - whether in OLE Automation or the use of ActiveX controls - has long been a source of frustration for many PowerBuilder developers.

There are several reasons for this:

  • There is a lack of a full understanding of OLE.
  • There is little documentation and practical examples of using OLE with PowerBuilder.
  • There are some limitations inherent in the method that PowerBuilder implements OLE.

This article is intended to address some of these issues by providing a primer on OLE, providing some practical examples of its use, and demonstrating some methods for addressing the limitations of PowerBuilder's implementation of OLE.

The first thing we need to do is cover some background information, beginning with some definitions of terms and then some explanation of how OLE works.

Read more

Find Articles by Tag

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