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

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