PxPlus Releases

PxPlus 2019 (version 16.00)

May 2019

PxPlus 2019 consists of various new features and enhancements, including the ability to create Android and iOS apps, a new Panel Creation generator, new Charting capabilities, Grid Presets improvements and industry-standard encryption.

Major New Features

Generate Android and iOS Apps
App Launcher for Android and iOS for launching PxPlus iNomads/Web applications as Android and iOS apps
Panel Creation Generator for generating file maintenance and inquiry panels using the Data Dictionary and Data Classes
Enabled the built-in Windows Spell Checker for Multi-Lines
Ability to locally Cache Database Tables (ODB, OCI, DB2, MYSQL) and VLR/EFF data files in memory resident keyed tables to improve performance
Extended Class Validation and Display options for dynamic Multi-Line Data Classes for validating against a data file and displaying selected data
Populate from a Data Source when defining dynamic Drop Box and List Box Data Classes
Save and recall shareable run-time Query Profiles
"Plus" Charts with full integration for Windows, iNomads, PDF, HTML and Image files

Additional Features

Language Enhancements

*PDF* hyperlink options for 'PICTURE' and 'RECTANGLE' mnemonics (arbitrary regions)
Ability to use the current font and foreground color for a 'TEXT' hyperlink when outputting to *PDF*
".png" printing support for PDFs on Linux
Multilingual Data Validation Messages support
Multilingual support for Chromium Browser Object *BROWSER
Multiple Character Search capability for Drop Boxes and Grid Drop Boxes to make it easier to find an exact match
Industry standard Data Encryption using AES and Hashing algorithm
Chunked Hashing capability for the HSH function when using SHA-1 and SHA-256 to improve performance
System logging when the Concurrent User Limit is exceeded
CALL and ENTER support for passing arrays by read-only values
ShowLocked Grid property for controlling the color of locked cells
Let's Encrypt SSL/TLS Certificate support for EZWeb and EZWeb as a Service
EZWeb Server Automatic SSL/TLS Certificate Renewal
PRIVKEY option for [TCP] OPEN directive
PRIVKEY and PFXPSWD options for configuring EZWeb Server
PFXCERTCONVERT utility for converting PFX SSL/TLS security certificates to a PEM format

Directives

New OPT= clause of CACHE=xxx for the OPEN LOAD directive to indicate if caching is to be done
PASSWORD directive support to accept SHA-256 encryption for hashing a password
"Hover" option for the SETMOUSE directive
"S" option for the MULTI_LINE directive for enabling the Windows built-in spell checker

Objects

Created a new Chart Object for all chart types
Improved Excel performance when using SetRange methods
Added properties to the Excel object and the ability to allow RGB values when setting text and fill colors
Document, paragraph and sentence methods added to the Word object, as well as the ability to allow RGB values and named constants when setting text color

OPTION Mnemonics

AutoSpellCheck for setting automatic spell checking for Multi-Line controls
BrowserLang for defining the language code for the embedded Chromium browser language

Note: The above options are also available to read using the FIN function.

Mnemonics

"style=inherit" option added to the 'TEXT' hyperlink <URL> attribute for applying the current font and foreground color
'PICTURE' and 'RECTANGLE' support for the *PDF* Hyperlink option

Functions

IOL(FILE "pathname") format for returning the IOList for a given pathname of a file
IOL(TABLE "tablename") format for returning the IOList for a given table
Internal SHA-256 hashtype -2 and Chunked Hashing for the HSH( ) function

Enhanced IDE, Nomads, iNomads and Toolkit

New Pointer Tool and Default to Pointer option for the NOMADS+ Toolbar
Specific type of List Box, Chart and Shape displays in the Type column in the NOMADS+ Toolbar grid
Release Notes added to the IDE menu bar
Refresh option for refreshing the Library Object Selection list box
Ability to create a Message Library Message on-the-fly in all designers
Default Program field added to the Logic panel for all panel controls (e.g. Button, Multi-Line, etc.)
Themes Maintenance and Visual Class Maintenance accessibility from the Utilities menu in Library Object Selection
Suppress Panel Persistence for individual panels
Add/maintain Themes from Library Defaults and Panel Header
Add/maintain Visual Classes from NOMADS panel controls (e.g. Button, Multi-Line, etc.)
Moveable attribute for Button controls
Advanced Image settings for Button, Check Box and Radio Button controls
Center Alignment option for Button, Check Box and Radio Button controls
Spell Check attribute for Multi-Line controls
Specify a bitmap image as an expression when defining a Multi-Line Query Button
Extended Data Class properties for Multi-Lines, Drop Boxes and List Boxes
Extended Class Browse when creating Multi-Line controls for Extended Class Validation data elements
New Arc, Circle, Line and Pie shapes for the Shape control
Center Text Vertically attribute for Report View List Box controls
Lock Top Rows attribute for Report View List Box controls
Lock Top Rows property for Grid controls
Grid Presets functionality and usability enhancements:

Filter the Property list by property type
Right-click Property selection by property category
Create a duplicate of the current row and insert below
Insert a new row above or below the current row
Rearrange rows using drag and drop
Replace column number settings with column names
New Format button to launch Grid Format Definition dialog

Navigate Sidebar folders using up/down arrow keys
Usability enhancements for NOMADS panel designers and utilities
Optional values for Certificate Key (EZWeb Server and Simple Client Server) and PFX Password (EZWeb Server) when Installing a Windows Service
Updated to the new TinyMCE HTML Editor and new modern Layouts
Added support to automatically set the logic for Custom Title Bar standard variables
IT Tracing capability of IF conditions when single stepping through a program

iNomads Configuration

Relaunch option for relaunching an iNomads task
Full_Screen option that forces a full screen display when first displaying a panel in iNomads
Added iNomads Classes for use on Web style buttons for hyperlinks

Charts

Ability to create Smart Charts
New Chart display for Chart controls in the panel designers
Select a Chart Brand when defining a Chart in the panel designers
Chart Image Generator uses the new "Plus" Charts
Updated RGraph Charts to Version 4

Get_File_Box

Specify Directories to which users can have access
Suppress the Make New Folder button
Case Insensitive Suffix check box option when running UNIX

Themes and Visual Classes

Moveable attribute for Button properties
Focus Background Color and Focus Text Color attributes for Drop Box, Variable Drop Box, List Box, Variable List Box and Multi-Line properties
Center Text Vertically attribute for List Box properties
Bitmap, Connector Line, Legend Location, Pastel Palette, Show Values, Default Color, Face Color (Back) and Face Color (Bottom) attributes for Chart properties

Data Dictionary

Database Export Utility for migrating a standard data file to a database table (ADO, DB2, OCI, ODB, MYSQL)
Ability to update selected data dictionary elements based on changes made to the Global Dictionary Element record

Data Class Definition

Extended Class Validation and Display option for Multi-Line Data Classes for validating data at run time
Load From File option for defining a "source" data file when populating a Drop Box or List Box at run time
Spell Check attribute for Multi-Line Data Classes
Lock Top Rows attribute for Report View List Box Data Classes
State Images/Indicators is a Dynamic attribute for Tree View List Box Data Classes
Specify a bitmap image as an expression when defining a Multi-Line Query Button
Copy Class button in Data Class Definitions maintenance for Multi-Lines, etc.
Usability enhancements for Data Class Definitions maintenance

Menu Maintenance

Specify a bitmap as an expression in Menu Item/Group Definition
New Merge-Jumpto function in Menu Item/Group Definition
Usability enhancements for Menu Bar Definition

Query Plus

Save and recall shareable run-time Query Profiles
Suppress Persistence on the query
Center Text Vertically attribute for centering text vertically in the query line when Display Line Height is greater than 1
Auto Column Resize attribute for automatically adjusting column sizes to fit the width of the query
Assign a Theme to a Query
No Drop Query Header attribute for suppressing the display of column headings in a drop query
Define a Chart from the Query Definition
Hot Key Transfer added to the Query button for a Multi-Line with the PermaLock/Query Input attribute set
Improved loading performance of large Query+ displays
Updated the Query Bulk Edit Utility for the parameter

Report Writer

Specify a Class and/or Format for a Parameter Definition
Vertical Text Alignment options for setting both horizontal and vertical alignment (i.e. Left Top, Left Middle, Left Bottom, etc.)

PxPlus SQL ODBC Driver

Increased the maximum number of Catalogs to 256 (for Windows and UNIX/Linux)
Improved performance when using SELECT BETWEEN directive

WindX

Ability to Reset WindX Security
New options to provide additional workstation authorization when connecting to a server using Simple Client-Server
WindX authorization check during WindX installation to ask for security settings
Ability to use a separate PEM and private key for SSL/TLS Certificates to Simple Client Server

Web Services

New parameters for Query Web Service to control the sort column, sorting direction and number of records to display
New Query parameters for Web Services Maintenance
Chart Web Service uses the new "Plus" charts

PxServer

Enable Exclusive File Use option for controlling access to files that PxServer has open from other processes
Prefix option added to allow a list of search paths to be defined when using relative pathnames
Service option added to allow PxServer to run as a Windows service
Enhanced the functionality of the PxServer interface to eliminate the need for mapped/networked file access from applications
Improved the PTH( ) function when checking a [pxs] path

Other Changes for Reference

NOMADS Properties Added

%NOMADS'Gfb_Dir_Tbl$ is used to set a list of directories to which a user can have access when using Get_File_Box
%NOMADS'Query_AutoColSize$ is used to automatically adjust the sizes of the columns to fit the width of a query
%NOMADS'Query_NoDropHeader is used to suppress the display of the column headings in drop queries
%NOMADS'Query_Suppress_Persistence is used to suppress persistence on the query
%NOMADS'RelPnl_Suppress_Persistence is used to suppress panel persistence for all dialogue panels with relative positioning
%NOMADS'SuppressWindXMakeFolder is used to hide the Make New Folder button in Get_File_Box

Parameters Added

'CL' system parameter to define the number maximum number of records that can exist in a file to be cached
'EA' system parameter to control how file passwords are hashed and how files are encrypted for new file passwords

Properties

LoadPoint property enhanced with a new option that allows the data included with the List Box or Drop Box LOAD directive to replace the current contents of the list starting at the item number set in the 'Item property