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

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