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

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