PxPlus Releases

PxPlus 2016 consists of various major new features and enhancements, including a new SQL ODBC Driver, new Web-based tools, and enhanced iNomads functionality.

Major New Features

Enhanced Floating Tips (Info Tips)

• New Define Info Tip dialog to define and maintain tips
• Added URL and URL text capability to tips
• Increased display time of tip if URL exists
• Tips will be rendered in HTML when ' TC'=-2 is set
• Added customization to HTML tips using *tooltip

Enhanced IDE, NOMADS and Toolkit

• New Combine View option for IDE Launcher
• New Web-based IDE
• Added PxPlus Dashboard to Web IDE
• New Web-based Editor
• Added new Wizard Creation Wizard with progress bar capability
• Added iNomads Menu to NOMADS Panel Designer to create transactions and test panels in iNomads
• Added Designer Menu to Library Object Selection to set panel designer type prior to launching a panel
• Enhanced Install Windows Services so that more than one service can be installed for each type
• Improved Windows Services user interface so that all services can be viewed from one location
• Added iNomads Template attribute to panel header to allow the template to be overridden in iNomads
• Added iNomads Classes attribute to panel header and controls to allow special override conditions in iNomads
• Added ability to specify column and row coordinates for an Embedded Panel
• Enhanced usability in Presets tab of the Grid control by changing column order to streamline creation

Query

• Enhanced Query Header options by adding additional options for Drop Query use
• User-defined column order in the Query is now retained for any file export at run time

File Linking Utility

• New File Linking utility allows the definition and maintenance of cross-reference linkages between application data files
• Query Definitions
• Views Data Source Definitions
• Input Source Definitions
• Report Designer

Added 3 New Properties to List View Control

• 'HdrBackColor$ - Set background color for List View header
• 'HdrTextColor$ - Set color of text on the List View header
• 'HdrFont$ - Define font to use on the List View header

Enhanced Themes and Visual Classes

• Added Theme support to Visual Classes
• Added new List View properties:  Header Background Color, Header Text, Header Font, Hilight Color 1 and Hilight Color 2

Added Responsive Capabilities

• Added Substitute Panels capability allowing panels to be substituted at run time based on configurable conditions
• Enhanced Alternate Panels to automatically switch panels when resizing screen at run time
• Added Full Screen Dragging capability

Enhanced Web Services

• Added native File Maintenance Web Service based on Data Dictionary
• Added column sorting and table capability to Query Web Service
• Added new Web Services Maintenance to create and maintain Web Services
• Added new simplified method to deploy secure PxPlus Web Services in a browser and in the PxPlus Dashboard

Enhanced EZWeb Server Usability and Functionality

• Added ability to launch and save specific port numbers to Launch EZWeb Server
• Added EZWeb Server Shutdown capability to system tray
• Added new tool tips to identify EZWeb and Simple CS tasks in system tray

WindX Enhancements

• Improved handling of Start_Up for PxPlus Simple Client-Server Interface
• Enhanced WindX security by adding end-user authorization whenever the host tries to access a file or execute code on the workstation
• Added SSH support
• Added ability to have WindX support the AutoConvertUTF8 setting
• Added Client Server Host Security using system environment variable PXP_CS_OPT
• Added two new parameters, Terminal Type and Program, to TinyNet
• Improved use of BEGIN in WindX environment

UNIX Enhancements

• Added support for reading, writing, and deleting entries from an INI file to the *inifile utility when running on UNIX

Utilities

• Added SMS (Texting) capability to send texts
• Created new *web/testemail utility to test email and provide necessary *web/email commands
• Enhanced FTP performance and usability

Language Enhancements

• Added SysMenu# option to 'OPTION' mnemonic to update the System menu on-the-fly
• Added Find_Index, Next_Sibling and Prior_Sibling methods and Parent property to the *obj/xml object
• Added new HTML-based error reporting for NOMADS and iNomads
• Added new -A command line parameter when Launching PxPlus to specify the directory to contain the ACTIVATE.PVX file
• Updated msgbox.gui to Windows 10 standards
• Added new Crash Analysis to trap unexpected application failures and output key application information to the log file
• Added support for DOM= on an Associative Array element
• Added page break to LV command
• Added support of UTF-8 data in Grids that allows users who are using the 'U8' system parameter to use the Grid
• Added UTF-8 support to the PDF interface
• Enhanced the 'HP' parameter to set it to use the LibHaru library for PDF creation by default
• Added new 'TC' parameter to display HTML-based tool tips
• Improved "!" format support and NUL= options when entering values <1 to NUL$ for Grids
• Enhanced JUL and DAY_FORMAT directives error reporting
• Added Program and Prefix support for PxServer
• Added new 'XU' parameter to clear keyed file header locks prior to invoking an external DLL call or OCX object
• Added ability to switch between Portrait and Landscape modes when outputting PDF files using the 'LM' and 'PM' mnemonics

Functions

• Added [LCL] and [WDX] support to PTH function
• Enhanced CRC function to add support for calculating 32-bit cyclic redundancy checksum
• Added SysMenu# option to FIN function to update the System menu on-the-fly
• Added System_Jrnl option to FIN function to return pathname of System Journal if open
• Added new DIM(CLASS array$) function to retrieve the element type from an array

Directives

• Added support for TRY WITH ERROR_HANDLER directive that will leave the error handler enabled during the execution of the TRY logic
• Added new CREATE FILE directive to create copy/backup of a file
• Added new LOAD DATA TO directive to load an associative array from variables or an IOLIST
• Added new LOAD DATA FROM directive to load variables from an associative array or an IOLIST
• Added new DIM CLASS directive to set an elements-type flag
• Added new READ WINDOW DATA directive that will receive data from another session
• Added new WRITE WINDOW DATA directive that will send data to another sessions
• Added new EXTRACT FILE directive to decompress a specified file in the ZIP archive
• Added new INSERT FILE directive to compress a specified file and append it to the ZIP archive

iNomads Enhancements

• Enhanced display and screen performance by reducing screen redraw
• Added iFrame popup style windows
• Improved usability and functionality of all iNomads setup programs
• Added Template Designer Wizard to create new templates
• Enhanced usability and functionality of Template Designer
• Added Menu Generation Interface to Template Designer to generate menus at run time
• Enhanced usability and functionality of Transaction Maintenance
• Added Test buttons to Template Designer and Transaction Maintenance to quickly verify design of template and transaction
• Added quick launch of Admin setup in iNomads Application Launchpad
• Added circle and lines support
• Improved handling of a non-existing panel/library when running an iNomads transaction
• Added Theme and Visual Classes support to iNomads
• Added support for Drop Query to template
• Added Hamburger-style Menu support to template for panel menus
• Added List Box right-click functionality when clicking outside of row display
• Added support for HSL colors
• Enhanced Admin and IDE Templates styling
• Added Embedded Query buttons support
• Added iNomads Classes to handle display of controls and List Box/Grid presentation options
• Added all PxPlus 2014 bitmaps and images
• Added Folder Go to tab support
• Enhanced List Box and Grid pagination
• Improved handling of fonts within Grids and resetting of 'string' properties
• Added handling of MOUSE down/drag/up for CTL events for non-NOMADS
• Enhanced Calendar and Calculator controls

Enhanced PxPlus SQL ODBC Driver

• Rebrand to PxPlus SQL ODBC Driver and PxPlus SQL Server
• Enhanced escape syntax for joins, scalar functions and dates to be optional
• Added SQL Block Comments /* */ capability and --  Line Comment support
• Added date comparison optimization for increased date filtering performance
• Improved performance for independent sub-selects
• Added support for SQL CAST scalar function
• Enhanced SQL CONVERT scalar function to handle more data types
• Added support for SQL CASE syntax
• Added support for SQL UNION and UNION ALL syntax
• Added support for RIGHT OUTER JOIN
• Added support for alternate syntax for 3+ table joins
• Added support for SQL HINT
• Added support for NULL string and NULL numeric fields that are the same as "" or 0 respectively
• Added support to treat a string number as a numeric
• Enhanced SQL Command Line Client to return column names
• Added LIST tablename option to output column information to SQL Command Line
• Enhanced SQL Command Line error reporting and help message
• Added support for OLE DB ODBC and .NET ODBC providers
• Added capability to test schema to DSN setup that tests whether tables and/or views are accessible
• Added link to documentation to DSN setup
• Added UNIX/Linux support using unixODBC for 32-bit and 64-bit versions
• Added PxPlus SQL Server support for 64-bit UNIX/Linux
• Corrected issue with PxPlus SQL Server when dealing with keys larger than 127 bytes
• Addressed a stability issue caused by certain error messages
• Resolved and issue with doing an UPDATE that modifies the current key
• Resolved an issue with ODBC returning different KEF( ) values

Corrections and Minor Changes

• Updated ZIP File processing to report an Error 17 when the file is corrupt instead of Error 12
• Corrected WindX plugin and opening a PDF viewer with "[LCL]*viewer* issue
• Improved Drop Box handling in Grid Preset tab
• Addressed a memory management issue that caused memory file access to be slow under certain conditions
• Corrected system to return a proper error message when using SELECT and REFILE when HFN returns -1
• Fixed an Error 14 when adding an Menu item to a Popup Menu under certain conditions
• Resolved a KEF not returning the correct key when using ODBC
• Added support for FREECTL FIN call on UNIX when using iNomads
• Addressed issues with binary blob and blob fields being treated as text string fields incorrectly when using MYSQL
• Resolved issue with parsing the INI file for column info with ODBC
• Corrected issue with a defined TINYINT NOT NULL column not creating table entries
• Corrected pxpado.dll to properly process a stored procedure
• Addressed issue with Button colors when used in conjunction with 4D border style
• Added logic to *plus/cs/host to allow forced programs to spawn sessions
• Added ability to store Apache Webserver Cookie
• Corrected an issue with 'CIRCLE' PDF output and Windows graphical drawing when the aspect ratio <=0
• Fixed an issue with System Journaling when updating a file in the Data Dictionary
• New COM Wrapper with Events example
• Corrected problem with Visual Classes when a global variable for color is used
• Add logic to prevent a panel from being deleted when in use
• Fixed an Error 61 in Query Link File definition
• Addressed issue with Tree View performance in Views definition
• Corrected resizing issue with side bar Folders
• Corrected an issue with Data Dictionary file copy when the name exceeded 30 characters
• Resolved a resizing issue with Folders that contained a preserved control
• Addressed a key corruption issue with a negative numeric field that was part of the key
• Corrected Scripting issue returning extra information during a Query
• Fixed problem with WindX launcher repeating application name when using SSL
• Improved the journalization functionality to correctly reset the journal number when the apply is stopped
• Correct issue with List Views not properly changing focus on start of drag
• Added logic to *ufac, *ufar, *gui/ufac.w, and *gui/ufar.w to return messages that split files, multi-segmented files and files > 2GB are not supported
• Resolved issue with multiple PDF channels open at the same time
• Corrected issue when Spellchecker is used on a control that does not have focus
• Added new Save capability when testing a report in Report Writer
• Addressed an Error 29 in NOMADS when creating a panel whose caption is too long
• Added logic in Data Dictionary Key Definition to prevent issues with partial fields and offsets
• Corrected problem with Hover, Focus and Disabled Background Colors applied to Buttons with 4D border
• Added a new %NOMADS'Shifted_Query property to address an issue with a Signal on Exit Multi-Line
• Resolved RGraph chart issue passing numeric arguments to setOption( ) function
• Improved display of vertical grid bars on RGraph Scatter chart

iNomads

• Corrected problem with using a 'POP' from a non-NOMADS application when using popup windows
• Added support for non-NOMADS applications to handle input timers
• Changed logic to dynamically update the field length of a Multi-Line as opposed to redrawing the control from a non-NOMADS application
• Corrected the dynamic creation logic to handle the LEN= option from a non-NOMADS application
• Added support for dynamic creation of VARDROP_BOX controls from a non-NOMADS application
• Corrected issue with images not displaying in a Report View List Box
• Addressed issues with text justification display on a Button
• Corrected Grid cell handling so that ENTER will properly start entry/edit mode
• Fixed issue with dependency definitions generating an error when used with Folders
• Corrected logic to handle expressions that contain internal commas and square brackets with Grid titles
• Resolved issues with the Chart control
• Addressed a Grid font issue where a font was set for the entire Grid

Additional Help Changes

• Enhanced iNomads documentation with additional information for iNomads Setup, Configuration, Classes, Transactions and Templates
• Enhanced PxPlus Dashboard documentation with Examples of Widgets created for different Web Service types
• Updated IT Program Editor documentation with information on the Function/Edit keys, Menu Bar options and Tool Bar options
• Added documentation for File View and File Update utilities
• Enhanced SQL ODBC Driver documentation with more Examples and a new Frequently Asked Questions page
• Incorporated Visual Dictionary Utility documentation into the PxPlus Help
• Improved PxPlus Help usability by adding more links, refining the Help tree view structure and enhancing page formatting