Tech Articles


Free Utilities - Code Samples from CodeXchange


In this article you will find a list of Code Samples related to Free Utilities for your PowerBuilder apps. These code examples are found at Appeon's CodeXChange.

 

**The list has been ordered from newest to oldest.

Free Utilities Code Samples from CodeXchange
Name Description

WebAPI JSON to DataWindow

(Download)(CodeXchange)

This sample shows how you can interacts with WebAPI addresses by calling the HttpClient and JsonParser objects.

[PowerBuilder / HTTPClient / JsonParser]

RS256 Encryption through .Net Assembly import

(Download)(CodeXchange)

PowerBuilder demo code and SnapDevelop projects for two different .Net Assemblies that does RS256 ( RSA with SHA256 ) encryption. You can use either a PKCS#8 or PKCS#1 private key. PowerBuilder generates the latter when you use AsymmetricGenerateKey. Either way, you need to provide the non-Base64 prefix ( the part that contains "BEGIN RSA PRIVATE KEY" for PKCS#8 and "BEGIN PRIVATE KEY" for PKCS#1 ) so that the assembly can determine which key type it's working with.

[PowerBuilder / Encryption / .NET Assembly]

String Break - Adds line breaks to strings by analyzing content

(Download)(CodeXchange)

When attempting to display the contents of a long string into an area having limited width, but with room for multiple lines, PowerBuilder & Windows will simulate a line break only where it finds white space in the string. Sometimes this behavior is adequate, but when the string lacks spaces the data is usually cropped.

[PowerBuilder / DataWindow / NVO]

PFC Resize without PFC

(Download)(CodeXchange)

Code for my 2020 Elevate Session Using the PFC Resize service without the PFC. I have broken out 2 objects from the PFC that can now be used without any other PFC objects. I've also supplied a base window to use as a guide for your ancestor window and a descendant window that shows some different resize options. Also included are 2 objects for the datawindow resize service also broken out of the pfc that you can use. Note - this target is PB2019 R2. Happy resizing!

[PowerBuilder]

Enhanced SizeOf Utility with Sample Application and WinAPI Tutorial Demo & Tests

(Download)(CodeXchange)

PB does not currently have a "SizeOf" function for returning the amount of memory required by a variable of a standard datatype or a structure. The ability to dynamically determine the size of a structure is very helpful when setting the "size" member required in some WIndows API (WinAPI) structures, particularly if it could take into account member boundary alignment padding and other conventions for both the 32-bit and 64-bit environments.

[PowerBuilder / WinAPI]

RibbonBar Menu Generator

(Download)(CodeXchange)

The attached utility allows you to select a target and will list the menus within the application. If you double click on a menu, the utility will generate sample XML for a RibbonBar that will contain app menu items and ribbon buttons corresponding to menu items in the selected menu.

[PowerBuilder / RibbonBar]

u_json Object oriented JSON in PB

(Download)(CodeXchange)

JSON handling in PowerBuilder is fine to handle relational data, as long as it comes in the format defined by Appeon. But often, we need to work with data from an external interface, that’s where u_json comes in handy: You can parse, manipulate and/or generate all JSON files with the same object, in a true object oriented way.

[PowerBuilder / JSON / NVO]

Sending Email (with images) using MS Outlook and an ActiveX custom RichTextEdit

(Download1, Download2 )(CodeXchange)

Sending Email (with images) using MS Outlook and an ActiveX custom RichTextEdit

[PowerBuilder / Email / MS Outlook / ActiveX / RTE]

Icon Replace Tool

(Download)(CodeXchange)

As PB 2018 introduced many new Windows 10 style icons, this tool can be used to batch replace the old icons with the new ones in an PB application by exporting the source code using ORCA API, replacing the matching strings and then importing back into the PBLs. Please refer to the Readme.docx inside the zip file for more details.

[PowerBuilder]

Icon Replace Tool for PB 2019

(Download)(CodeXchange)

As PB 2019 introduced many new Windows 10 style icons, this tool can be used to batch replace the old icons with the new ones in an PB application by exporting the source code using ORCA API, replacing the matching strings and then importing back into the PBLs. Please refer to the Readme.docx inside the zip file for more details.

[PowerBuilder]

Advance_Excel_Searching

(Download)(CodeXchange)

This application helps you to search a key word from excel file. Its develop on PB 2017 R3.

[PowerBuilder / Excel]

Fast Find Demo in DataWindow

(Download)(CodeXchange)

Fast Find service to a DataWindow with PB custom event pbm_enchange, using an SLE English regional settings need to be set.

[PowerBuilder / DataWindow]

A DataWindow Head Sort UserObject

(Download)(CodeXchange)

The PB UersObject that can let the user click the head then sort the column.
You can use that UO in place of the original PB DataWindow control.

[PowerBuilder / DataWindow / NVO]

DataWindow Tooltip Service

(Download)(CodeXchange)

A service for providing tooltips on DataWindows with a wrapper for Microsoft Common Control using external API control comctl32.dll and so on.

[PowerBuilder / DataWindow / WinAPI]

Autosize Height of Header and/or Trailer

(Download)(CodeXchange)

Autosize Height of Header and/or Trailer The only band that has autosize height is the detail band. This is a way to simulate autosize height of the header and/or trailer by using nested reports. Retrieve d_main using demo db.

[PowerBuilder / DataWindow]

DataWindow ApplyStyle

(Download)(CodeXchange)

A PB utility to clone display style between two datawindows. Support save as another SRD.

[PowerBuilder / DataWindow]

SQL Extract

(Download)(CodeXchange)

Converts Unicode (PB/IM 10.x, WS, DW.Net) DataWindow PBSelect to ANSI SQL for use with the SQLExpert or Quest Central DB Tuning products.

[PowerBuilder / DataWindow / ANSI SQL]

Query Builder

(Download)(CodeXchange)

Build SQL statements graphically by using PB.
For more details, please read 'ReadMe - QueryBuilder.txt'.

[PowerBuilder / SQL]

PB Image Demo

(Download)(CodeXchange)

Demo of storing/retrieving image data in blob columns and applying to window/DataWindow image controls.

[PowerBuilder / DataWindow / SQL / Blob]

DB Search Example

(Download)(CodeXchange)

Example of searching for a character string in various db objects in SQL Server 2000.

[PowerBuilder / SQL Server]

UserObject Wizard Example

(Download)(CodeXchange)

A PB Wizard example using UserObjects.

[PowerBuilder / User Object]

Multilevel UserObject Wizard Example

(Download)(CodeXchange)

A PB example of a wizard with object-oriented ideas.

[PowerBuilder / User Object]

A Taskbar To Create and Close Windows

(Download)(CodeXchange)

A simple taskbar example using PB MDI window features.

[PowerBuilder]

RTF Font Demo (Version 2)

(Download)(CodeXchange)

An example of the ability to edit the font using the external API function (gdi32.dll etc).
Pay particular attention to object u_rte_demo.

[PowerBuilder / RTF]

RTF Font Demo with Enhancements

(Download)(CodeXchange)

This is an upgraded version of the RTF font demo that uses the RTF control new to powerbuilder 10 and set to work with unicode. In addition to the conversion to 10.5 I also added some other demonstration functions such as italics, underline, and strike out and weight.

[PowerBuilder / RTF]

PB Editor Control v1.0

(Download)(CodeXchange)

The PB Editor Control is used to display PowerScript code in a PowerBuilder application.

Syntax highlighting is achieved by using the open source editor control Scintilla. In order to make the editor control work properly you must download the file SciLexer.dll from scintilla.sourceforge.net/SciTEDownload.html and copy it to your Windows System32 folder.

Note: When adding the UserObject u_pbeditor to your window or UserObject, instead of setting the border property to false, using the SetBorderStyle function in u_pbeditor.

[PowerBuilder]

Comments (0)
There are no comments posted here yet

Find Articles by Tag

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