# 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