Skip to main content

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

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

Data Dictionary

Hotlinks

  • Added:

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

Visual Classes

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

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:

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

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