# 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/Changed

- 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
- FocusBackColor$ can also be applied to a List Box, List View, Tree View, Drop Box and Variable Drop Box to set the background color when the control has focus
- FocusTextColor$ can also be applied to a List Box, List View, Tree View, Drop Box and Variable Drop Box to set the text color
- 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