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
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
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