PxPlus Releases

PxPlus 2018 (version 15.00)

May 2018

PxPlus 2018 consists of various new features and enhancements, including Dynamic Data Class Properties, new SELECT JOIN capabilities, iNomads Security enhancements and new Hotlink capabilities.

Major New Features

Ability to create Dynamic Control Properties that are evaluated and automatically populated at run time based on the data class
Added Hotlink capability to Report View or Query+ columns with the associated logic that will execute when selected for drill down
Added JOIN-style SELECT with key optimization for enhanced performance for both PxPlus data files and external database tables
Added utility to run the PxPlus Application Framework for accessing development tools, utilities and programs
Improved iNomads security:

Introduced a Single Port connection between the Web Server and the App Server
Removed the requirement to use a Shared disk directory (mapped drive/share point)

Additional Features

Language Enhancements

Improved List Box load performance when using background loading
Reduced screen flicker during List Box load
Enhanced the SAVE command and '+R' system parameter when using passwords with multiple program versions enabled
Added:

New 'SO' system parameter to enable SELECT optimization that automatically uses the best key and key range for selects on Keyed or EFF data files
New 'IT' system parameter to enable the addition of trace lines to an active trace file for any IF condition evaluated and its result
New capability to the JUL function to allow a specified date format in addition to the DAY format
Ability to create Hyperlinks in PDF files when using LibHaru
Support for scaled images in Tree View
New HdrBackColor, HdrFont, HdrTextColor and CelliNomadsClass properties for Grids
Windows proxy support for product registrations
Support for client merges to SETDEV MERGE for TCP channels
OPEN CREATE support for WindX

Directives

Added:

New SELECT JOIN support that allows multiple files to be read in a single statement for both PxPlus data files and external database tables
▪ New WITH option for LEFT JOINS
▪ New WITH REQUIRED option for INNER JOINS
New SAVE WINDOW directive to save the current child window rather than the top level window
New * option to the POP directive that removes all entries from FOR/NEXT and GOSUB/RETURN stack
New EXIT WITH option to pass a value back from a multi-line function, an embedded I/O procedure, or OOP method logic
New logic to SETMOUSE OFF to ignore mouse signals in the toolbar, status bar and menu bar regions of the window
Ability to skip * entries in the IOLIST for a LOCAL directive
New TABLE option to all file functions, READ, WRITE, FIN, FIB, PTH, etc.

OPTION Mnemonics

Added new options:

StdLvueHotlinkClr defines the default Hotlink column color for all List Box Report Views
StdLvueHoverBackClr specifies a system-wide background hover color for all List Box Report Views
StdLvueHoverTextClr defines the text color when the mouse is over a row in a List Box Report View
StdFocusBackClr sets the background colors used to display currently selected items from a List Box or Drop Box and display the background color in a Multi-Line when the control has focus
StdFocusTextClr sets the text colors used to display currently selected items from a List Box or Drop Box and display the text in a Multi-Line when the control has focus

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

Excel and Word Objects

Enhanced CreateWorkSheet method to control placement of new worksheet in workbook when using Excel object
Added:

New Save As file type options (i.e. PDF, XML, HTML, etc.) to Word and Excel objects
New AddNamedRange, DeleteNamedRange and SetColumnWidth methods to Excel object
New SEP$ property to define a field delimiter in the Excel object

iNomads

New Single Port connection capability between the Web Server and the App Server

Increases security and performance
Streamlines firewall configuration

Removed the requirement to use a Shared disk directory (mapped drive/share point)

Improves security
Simplifies setup

Added:

Ability to run Report Designer in iNomads
Customizer support to iNomads
Template name to Template Configuration when maintaining an iNomads template
Support for embedded panel tab control
New capabilities for iNomads controls
Support for a new CelliNomadsClass Grid property

Enhanced IDE, NOMADS and Toolkit

Enhanced Data Classes:

Ability to create Dynamic Data Classes
New data class properties for Multi-Lines, Drop Boxes, List Boxes, Check Boxes and Radio Buttons
Ability to create Dynamic Control Properties for Multi-lines, Drop Boxes, List Boxes and Check Boxes
New Data Class on-the-fly and Data Class Maintenance for Multi-Lines, Drop Boxes, List Boxes and Check Boxes
Ability to reapply data class settings for individual Multi-Lines, Drop Boxes, List Boxes and Check Boxes on a panel

Simplified the creation of controls when using Data Classes or Data Elements functionality in all panel designers
Revamped the creation of Smart Controls for Multi-Lines, Drop Boxes, List Boxes and Grids
Improved usability and functionality of all Format Definition grids in all panel designers
Improved search in *IT to find text across line breaks when using the "Edited list" option
Added:

New Auto Advance property to Folder controls to set tabbing movement between Folder tabs
Ability to enter an expression in the Empty Value property for a Multi-Line
New EZ Load Multi-Line that self-loads its value based on another control
Middle Left, Middle Center and Middle Right alignments to Grid Align property
New HdrBackColor, HdrFont, HdrTextColor and CelliNomadsClass properties to Grid Presets
Checking of the Menu Bar attribute for a panel when saving a Menu Bar definition
New Panels Details window to all panel designers that summarizes all related panel information for a selected panel
New Suppress option to the Library Compare Utility that suppresses Tab Stop and/or Position from being compared
New "nobrowse" directive to EZWeb configuration to disable directory browsing
Ability to enter a host URL when using a Web Service in Task Definition Maintenance
Report Designer to the Web IDE
iNomads Class attribute to Image and Shape controls to allow special override conditions in iNomads
New filtering capability to Lookup Table Names dialog to enable searching by table name, table description and column name

Data Dictionary

Added:

Dynamic Data Class support to dictionary elements
Ability to Reapply Data Class settings to existing data dictionary elements
Non-Query Logic support to data dictionary elements
User Aids support to data dictionary elements

Hotlinks

Added:

Hotlink support to Report View columns and the associated executable logic when selected for drill down
Support for Hotlinks to List Box Report Views in NOMADS
Ability to create Hotlinks for columns in Query+ and Drop Query
Support for Hotlink columns in iNomads

Query+

Added new Alignment option to set alignment (Default, Left, Center, Right) for columns in Query+ and Drop Query
Ability to create Hotlinks for columns in Query + and Drop Query
Improved Query+ load performance

Embedded Panels

Added:

Ability to include embedded panels in the Tab Order Definition within a panel
Detection of duplicate control names when adding controls to a panel containing an embedded panel
Ability to view the controls on a selected Embedded Panel
Support for embedded panel controls in Dependency Definition
Support to allow User-Defined CTLs in an Embedded Panel to be carried forward to the panel
Support for embedded panel tab control in iNomads

Themes

Added:

New List Box and Report View properties
New Grid properties
New Multi-Line properties
New Color (States) category for Buttons, Check Boxes and Radio Buttons color state properties
New color tick and color sample tip to Color settings to display selected color

Visual Classes

Added:

New List Box and Report View properties
New Grid properties
New Multi-Line properties
New Color (States) category for Buttons, Check Boxes and Radio Buttons color state properties
New color tick and color sample tip to Color settings to display selected color

Customizer

Added:

New Customizer security classification for Customizer access at run time
Themes support to Customizer grid
Ability to optionally Display Custom Information in a concurrent panel
New Merge interface for selecting custom items to use from existing public/personal definitions to create a new custom definition
Ability to Exclude Panels from customization
Simplified steps, including a new Clear All button, for easier removal of customized panels and fields
Integration of Customizer into iNomads

NOMADS Export/Import Utilities

New and improved user interfaces for Export/Import Library Objects Utilities for easier object selection
Added ability to export/import all Library object types including Library Defaults

Install Windows Services

Added ability to specify SSL Certificate when installing a Simple Client Server Windows service
Added ability to exclude SSLv2, SSLv3 and TLSv1 when installing a Simple Client Server Windows service

Windows Debugging Environment Trace Window

Added new Trace If Status option that adds trace lines to any active trace file for any IF condition evaluated and its result
Added new Jump Trace option that traces every transfer of control executed within the program and displays information that identifies the location (program/line number) of the logic executed

Library Bulk Edit Utility

Added:

New Include Sub-Directories option when specifying a directory to search
Ability to access NOMADS Designer or Library Object Selection when right clicking on a panel or control in the Selected Controls tree view
Additional parameters when displaying Controls in the Selected Controls tree view
Display of variable name when hovering over a Property in the Properties to Edit grid

Utilities

Created new *web/webservice utility that can be used to display a Web service in a Windows dialog
Added:

Delete capability to *web/ftp and *web/sftp
Additional control properties to Panel Bulk Edit utility
New debug trace output capability to *web/email and *web/smtp

PxPlus SQL ODBC Driver / PxPlus SQL Server

Version 6.10 is forward compatible:

Version 6.10 of PxPlus SQL ODBC Driver only connects to Version 6.10 (or higher) of PxPlus SQL Server, and Version 6.10 of PxPlus SQL Server only allows connections from Version 6.10 (or higher) of PxPlus SQL ODBC Driver

Added:

Ability to define a Catalog to simplify and secure Client/Server configuration
FULL JOIN capability
Ability to install UNIX/Linux versions in any directory
Prefix =, * and ** substitution support to match PxPlus
Support for NULL dates when using Julian base year
Support for SQL Server 2016 and higher

Corrections and Minor Changes

Corrected Suppress_FF issue when using a channel in the PDF viewer
Improved usability when copying a panel(s) to the same library
Fixed an Error 41 when using a List Box defined with 3 lines per row and no column definitions
Resolved issue with losing color sequence when a back highlight line is removed from a List Box
Addressed issue with background colors for fonted text not displaying when using a Theme or Visual Class
Enhanced Chromium Browser (*BROWSER) to handle "mailto://" links
Fixed an Error 11 when using *tools/striplines
Resolved issue when using SSH to connect to a server in WindX
Fixed an Error 2 when attempting to read with KEY="*Table" when using [ODB] or [DB2]
Addressed LOCK( ) issue on a zip file when using Linux

iNomads

Resolved issue when using a Grid button to process a popup menu
Added full row highlight (RowHiLight) capability to Grids
Addressed issue with Signature Capture not clearing image

PxPlus SQL ODBC Driver

Enhanced PxPlus SQL ODBC Driver to always return a catalog separator
Improved PxPlus SQL ODBC Driver to properly return a NULL date
Corrected an order by optimization issue with an INNER JOIN

Other Changes for Reference

NOMADS Properties Added

%NOMADS'Custom_GenWdw is used to set a CTL value to be utilized by NOMADS to generate custom concurrent windows
%NOMADS'Custom_Wdw is used to set concurrent window display for Customized Panels
%NOMADS'Class'xxxxx is used in conjunction with Dynamic Data Classes and Dynamic Control Properties
%NOMADS'Custom_Exclude_Program$ is used to determine whether user access to the custom definition for the current panel is allowed
%NOMADS'FolderAdvance is used to set tabbing movement between Folder tabs on Folder controls

Parameters Added

'SO' system parameter to enable SELECT optimization when using Keyed or EFF file types
'IT' system parameter to enable the addition of trace lines to an active trace file for any IF condition evaluated and its result

Properties Added

HdrBackColor$ sets the background color for the Grid top row or for the List View header
HdrFont$ defines the font for the Grid top row or for the List View header
HdrTextColor$ sets the text color for the Grid top row or for the List View header
SelectBackColor$ sets the background color for a List Box, List View, Tree View, Drop Box and Variable Drop Box
SelectTextColor$ sets the text color for a List Box, List View, Tree View, Drop Box and Variable Drop Box
HoverBackColor$ sets the background color to use when hovering over a row in a List Box Report View
HotLinkColor$ sets the text color for any column marked as a Hotlink within a List Box Report View
PriorValue$ contains the value last returned when the Grid cell or Multi-Line was read