Viewpoint

July 2019

Version 10.19.202
Enhancements
  • The Script Designer has better message when there is an unmatched IF/DO and END and will not allow script to be saved in that state.
  • In the Expression Editor using *SEQUEL syntax, the CONTAINS function was added.
  • Incorporated new version of Newtonsoft JSON for improved compatibility with other products like Visual Studio.

SQL Parser Improvements:

  • Significant improvements to the SQL Parser to better handle native SQL including these specific examples:
    • Date Expressions using YEAR an MONTH on the WHERE clause are handled better.
    • Better handling expressions on GROUP BY clause.
    • WHERE clause with similar file correlation names in a sub-query.
    • View Builder views with multiple join types.
    • Quoted field names mixed with numeric Order By.
    • A Fetch First clause over 32,000 characters.
    • Expressions in the Group By clause and quoted field names.

    View Builder:

    • Join tab removed and consolodated to simplify the design process.
    • *Localsys *Server view, editing an expression to show as currency does not add the edit code to the SQL.
    • Removing a field from the SELECT clause did not remove it from other clauses like the GROUP BY or ORDER BY.
    • View with excessive parenthesis gave error "Filter Parentheses Not Correctly Balanced".

    Excel Plug-in:

    • In Repository Mode, the path for the view object will now support both upper and lower case letters. Previously only lower case was allowed.
    • Excel Add-id returns Ribbon Class Error (getRange2Shift) when many more records are returned than previously.
    • Cell formatting was reset when view data is refreshed when using an ADS connection (requires host).
    • When refreshing view(s) in Excel, if Automatic Calculation option is set to on, disable it for the refresh. Once complete it, enable it and force Calculate Now.
    Other Fixes
    • View Designer won’t change the ORDER BY to use field names when field number was specified. This is especially important when sorting by JDE UDC fields that require quotes.
    • In View Design, a *SEQUEL view erroneously issues the error " Parser expected search condition" when the WHERE clause had a space between ‘IN’ and ‘(‘.
    • In Administrator using Repository Mode, the Maintain Host Entries now has a Test Connection button.
    • In Administrator, a local host entry for the IBM I can now be created using the same name for the server name entry for Iseries or DB2 type.

    November 2018

    Version 10.18.312
    Enhancements
    • Administrator option for Advanced Database Security now has additional options for ADS and JDE configuration.
    • When setting query variables, if user is in the middle of editing the value or has not tabbed over or pressed enter to accept changes, buttons function(s) will be disable, plus user message will display.
    • Excel Add-in now supports Set Query Variable which allows the variable to be set and then when refreshed will upate the variable in as many places as it is used in the spreadsheet.
    • View Builder should allow searching for a file in *USRLIBL
    • In Repository mode, added right-click option for the user to Create/Delete/Rename folder, as well as Copy and Paste folder(s).
    • In Repository mode, added new button to the SaveAs form/screen to create new folder in the current repository when saving an object.
    • Added ability to change repository name in the Excel Add-in References, if for any reason SWS server and/or name of the repository changed, preventing it from refreshing a view in a worksheet.
    • Improve Templates for *SERVER syntax that allow variables, grouping functions and a back option.
    Updates
    • Repository mode will now allow shortcuts with extensions in both upper and lower case (i.e. VPTVIEW and vptview) to run.
    • In Repository mode when saving a Script or Application, the extension for the saved object will automatically be set.
    • In Repository mode error at connection to Repository Error message CPF4101 appeared during OPEN for the file SWIUSERDFT.
    • In Repository Mode deleting an object from the Explorer no longer requires a license for SWI.
    • Repository mode when a user is not allowed to log in to the Repository, they should be prompted to enter new information.
    • Repository mode will now remember the last used JDE Environment and Role.
    • In Repository mode Save As on an existing view with uppercase letters in the original name has all lower case in the new name.
    • In Repository mode, open a view in View Designer, Click the yellow "Open" folder icon just left of the "Save" icon. This opens a list of repository folders. Click cancel and you get Run-time error '0'
    • Excel Add-in Canceling from a variable prompt gave: Object reference not set to an instance of an object .
    • Excel Add-in improperly re-formats a field when it is character field that contains only numeric characters with 4 leading zeroes.
    • Excel Add-in will now wrap column headings.
    • Excel Add-in Repository mode ERROR: Ribbon ViewPoint - RunSelectedObj: Object reference not set to an instance of an object when adding extendable areas.
    • Silent Installed failed on initial install.
    • View Designer corrupting SQL statement when field name ends with _1.
    • View Designer does not recognize the AS keyword in an SQL statement.
    • View Designer corrupts SQL statement that references a quoted file name.
    • In View Designer, Display option is grayed out if another option is chosen and then canceled.
    • Script run from a shortcut or DOS command fails with -2147023170 Automation error The remote procedure call failed.
    • Script Designer fails to run script and gives error CPD0018 Message String ' "DISPLAY ' contains a character that is not valid when Viewpoint is current and host software is very old.
    • View Builder and View Designer improved to quote schema names with underscore characters.
    • View Builder gives error ShowExtended Dialog, class not registered msstdfmt.dll when another dialogue box like Expression Editor is opened.
    • In View Builder with an ADS or JDE connection, you could only delete the last field in the list regardless of which one was chosen.
    • In View Builder edit drop down is disabled for Binary fields from SQLSERVER
    • From View Builder and View Designer the Expression Editor had invalid date functions listed like SCSERVER10CYYDD.
    • From Explorer focus of scrolling improved after keying in a library name, object list will scroll.

    June 2018

    Version 10.18.159
    Enhancement
    • In Repository mode the JDE connection will not be recycled if the Environment and Role have not been changed in Viewpoint repository mode. This will help in performance after the first connection to a server.�
    • In Repository Mode, Import Query has been added.
    • Improved performance for JDE JDE connections if the role and environment have not been changed in ViewPoint repository mode.
    • From the view results, Export to Excel produces error 'Application-defined error' when fields used edit words.
    • Improved message in Repository Mode when user excluded from IFS directory.
    Other Fix
    • Logging in to SWS Repository Mode from the Excel Addin, user is prompted for the wrong repository.
    • In Repository Mode with a JDE connection and a variable using a DBLIST, will now show the corresponding UDC field values and not just showing the code field values.
    • In Repository Mode, Dashboard designer will now allow a Script View to be used.
    • Silent Install will check for locks and prevent the install from running if the product is in use.
    • Opening a very large Warehouse Builder definition or script in Viewpoint results in an error CPD0074 Value 'EXECUTE SQ' for COMMAND exceeds 5000 characters.
    • When view results are display, and "Close & Reprompt" is selected, the prompt screen should redisplay, and the variable values should default to those previously selected. Since updating to VP 11.18.046, if a DBList variable had a default value, and the view is run with that default value still present, when "Close & Reprompt" is selected, there will be no value displayed for that variable
    • In Host Mode Dashboard designer, Save To the Repository was unavailable.
    • In the View Designer using five or more files with the Viewpoint Universal Driver (JDE and ADS connections), Viewpoint wasn't building the joins correctly.
    • In the View Designer, with a *Localsys/*Server view, if a specific length is specified on an expression, going to the F&F tab and making a change to the column heading removes the specified length from the SQL.
    • In View Builder, choosing an expression column and then Edit brings the wrong column into the edit window when there are many fields and the expression is in the middle.
    • In View Builder, choosing a file that is not in the specified Group of Favorites causes Runtime Error 0.
    • In the Script Designer, a MONMSG command was mistakenly converted to SCMONMSG command.
    • From the Script Designer, selecting a line in a script, then click on Edit/Delete produces Runtime Error 0.
    • From Script Designer, creating a Script or Script View in Viewpoint Host mode and saving to repository fails.
    • DBList on a variable shows all fields with name of RENAMED when fields have names longer than 10 characters.
    • Designing a *Localsys/*Sequel view, when you hide a column (WDATA) the type and length are changed to the values of the following field. Un-hiding the length does not change back.
    • Excel Add-in drops decimals with some zoned numeric fields. When the problem happens, the integer part to the left of the decimal is correct while the fractional part to the right of the decimal is dropped.

    February 2018

    Version 10.18.046

    Updates:

    • The Script Designer was changed to handle command strings greater than 2000 characters (Host version 10.10/11.10 also required).
    • The install will now detect where the OS is Windows 10 and if .NET 3.5 is not installed/enabled and automatically enable it.
    • Exporting view results to Excel produces error 'Application-defined error' if there are any numeric fields that have an edit word or an edits code that places non-numeric characters in the field (such as / or -).
    • Gauges do not appear on a dashboard that also includes a website.
    • Dashboard that consist of nothing but text and Action Buttons display nothing when launched.
    • On the Files and Fields tab of the Viewpoint Designer, there is a "file" cell in the Fields Section that indicates what file the given field is selected from. That "file" cell is no longer editable, and will not show a dropdown list showing all files referenced in the view.
    • Once CRO has been saved, attempts to do a Print Preview or Preview Sample end in error.
    • In the View Designer, when clicking on the Files and Fields tab, User sees message box with yellow triangle alert with exclamation point, ‘Graphical Design Interface, There is a problem with the SQL and/or variables. Fix the SQL then try again.’ This error happens on a view using field sequence number from SELECT clause on the ORDER BY.
    • In the Dashboard Designer when a hidden view that returns no records, saving the dashboard deletes all other Sequel objects.
    • In repository mode should only show SWS data sources that the user has authority to use.
    • The View Designer might hang when using SERVER(*LOCALSYS) SYNTAX(*SERVER) under these conditions:
      • The Order By used field numbers, not names, and the view contained variables.
      • Using the WHERE button to go to the Expression Editor.
      • Resorting columns on the Files & Fields tab.
      • Changing column headings or edit codes/words on the Files & Fields tab.
    • In Repository Mode using Assistance Level 1, the Save Option on the Actions tab now brings you directly to save to the repository.
    • The View Designer was changing a non-equal comparisons on the WHERE clause to an equal sign when using SERVER(*LOCALSYS) SYNTAX(*SERVER) as it was treating it as JOIN criteria.
    • View Builder was adding CAST to grouping function unnecessarily and creating an invalid expression.
    • In Repository mode, an error ‘The data source with key {0} does not exist’ would appear if the SWS connection timed out.

    Excel Add-in:

    • When refreshing data if the results set contains only a single row, if the number of columns in the worksheet doesn't equal the number of columns in the embedded view, and if there is an extendable data area defined.
    • When adding prompted view & unchecking “Refresh data” option on the Add View form – we get message “no records available”.
    • Opening the workbook when a column heading had a slash character(/) caused error, ‘Ribbon ViewPoint (Loading Data) Index was outside the bounds of the array.

    Enhancements:

    • Dashboard support added to Repository mode.

    December 2017

    Version 10.17.348

    Updates:

    • View Designer and View Builder in Repository mode will list the datasources rather than SEQUELHOST entries for server connections. Dependent on host version M09.
    • The View Designer with SERVER(*LOCALSYS) and SYNTAX(*SERVER) was erroneously removing field to field comparisons on the WHERE clause like custmast.CSTTE<>custmast.DFTWH.
    • View Designer was erroneously removing the DATE function from GROUP BY views when the derived field using MONTH, YEAR or other date function was also used on the GROUP BY clause using *LOCALSYS *SERVER.
    • Views using Common Table Expressions did not run from repository mode.
    • Shortcut created to email a Client Table or Client Report as Excel sent file with .txt file extension.
    • Save existing CRO to repository with a different name modifies the current *USRSPC.
    • Viewpoint Administration creation of host entries will copy Driver and Connection strings from corresponding type template.
    • From Administrator, the creation of host entries will copy Driver and Connection strings from corresponding type template.
    • From the properties of a host report, adding a jpg image to a pdf overlay gave error Run-time error '35600': Index out of bounds".
    • When using Viewpoint to run a view with email recipient and specifying CSV format, some view names generate an email attachment with .txt suffix rather than .csv, so the file does not open in Excel.
    • When emailing from Viewpoint, if the attachment file name was less than 12 characters the file was created in tmp and then cleaned up. Otherwise, file went to the home directory or to root and remained. Now all files will be created in tmp and cleaned up.
    • The Google Map Wizard has been removed.
    • Changes were made to enable Viewpoint to offer better support of Advanced Database Security when libraries and files reside on an independent auxiliary storage pool (iAsp).
    • In Repository mode, improved error message when trying to refresh embedded views in an Excel worksheet when the repository hasn’t been defined.
    • In Repository Mode, inability to open underlying View of .VPTREPORT (CRO Report) has been fixed.
    • In Repository Mode, non-Administrator profiles will be able to retrieve a list of Datasources.

    Enhancements:

    • Applications now support using a Script View as the start object to easily allow a work file to be created for drill down purposes.
    • From the Administrator Advanced Database Security window, there is now a setting under Options -> Default Object List with two choices: Expanded or Collapsed. Performance can be improved for very large lists by selecting Collapsed.
    • View Builder Edit Filter with BETWEEN will name variables uniquely.

    October 2017

    Version 10.17.292

    Updates:

    • Unable to create Client Report over view with a variable using a Values List Integrity test with no default value.
    • ViewPoint won't include any select fields that don't have a field reference
    • (literals/numbers) in the GROUP BY.
    • With Auto Join turned on, after importing a query and adding additional files,no joins are established for the new files.
    • From Client Table results, highlight any of the values or the entire column on the Total column on the right, click on the Graph option, and nothing happens.
    • From the results of a prompted view, turn on subtotals. If you then choose to re-prompt the view, the values in the subtotal boxes were missing.
    • From view results of a SERVER(*LOCALSYS) SYNTAX(*SEQUEL) view, Regrouping and show details will now include the file.field qualification to accommodate ambiguous field names.
    • A view run in a script may use the default value rather than the value passed in the SETVAR when the view had a variable with a *ALL default value, an integrity test of a DBList or values list, and the presence of a *NOPROMPT variable.
    • In Dynamic Drill Down, O type fields (DBCS) are not recognized as character so the values are not quoted which caused a syntax error.
    • Dynamic Drill Down options will be not available for views with SERVER(*LOCALSYS) SYNTAX(*SEQUEL) that use WDATA function.
    • In the Administrator>Database Security, the Select by Object became inactive when switching from tab to tab.
    • From Viewpoint Explorer, when right clicking on a Host Report Display Results in PDF, no results are displayed.
    • From the View Designer, after making any kind of change on the Files & Fields tab, if you click on the SQL tab, the group by clause was removed.
    • View Builder will allow AltNames for derived fields that are longer than 10 characters, mixed case, and surrounded by quotes.
    • In the View Designer Files & Fields tab, when the view uses the same file twice an error ‘column or global variable not found’ when any field attribute is changed because the correlation name was dropped.
    • In the View Designer Files & Fields tab, when a view references greater than 10 files, and 1 is removed, the numeric file qualifiers were not adjusted properly.
    • The WHERE Expression Editor in View Designer and View Builder will not include CONTAINS for views with SERVER(*Localsys) SYNTAX(*Server.
    • In the Dashboard designers, moving a view results window changed the size of the data.
    • In the Dashboard designer, toolbar windows were sometimes left on window. All Viewpoint windows inside Dashboards will now force the menu to close when mouse moves off of the form.
    • On a dashboard, the total on a vertical gauge could overlay the chart.
    • In the Dashboard designer, use the Right Click/Insert to add either a text box or an action button. The initial box or button does not automatically snap to grid. You must move the item for it to then snap to grid size.
    • A Dashboard with a Script View gives error ‘Object NOKEYPATH in library QTEMP not found’ when refreshing the data.
    • Dashboard refresh skips views that return no records on first pass.
    • Using the Import/Query in Viewpoint, the view is created as *Sequel/*Sequel. It does not use the Users Sequel Default choices.
    • Custom formatting for values in digital and radial gauges is lost when any other changes are made.
    • Better message handling when view results or Excel Add-in results surpass the 2,000 character limit.
    • In the Excel Add-In, adding columns to a worksheet forces you to wait while the column information. Now a ‘wait’ cursor will be shown.
    • Using the Excel Add-in will now the characters & and > in the description of the view.
    • Excel Add-in: JDE User prompted twice for Environment/Role when adding a View to a new worksheet.
    • Excel Plugin for 64 bit Excel could not add in a Script View object,
    • On a new Viewpoint install, the default for field list found in tools>ViewPoint Options>Design Tab will be changed to 'position'.
    • Silent Install was not properly loading Client Reports.
    • View subtotals are lost when view is saved to the repository (both Host and Repository modes).
    • Using DATE function in *LOCALSYS View - ViewPoint automatically adds CAST function, causing runtime error.

    Repository Mode:

    • Excel plugin 64 bit- Login windows for Repository mode using SWS had the login hidden behind the Excel workbook.
    • Excel Add-in Repository mode should not require Repository signon if SWS authentication is an Iseries user.
    • In Repository mode for a Host Report, if a title was specified during the wizard, the title will now be saved with the report.
    • Script Designer in Repository mode now checks that the script has a valid name without slashes.
    • In REPOSITORY mode, File >Save As on Existing object will now default to existing name/folder.
    • In Repository mode when using JDE credentials plugin not connecting to selected repository.
    • Attempt to save CRO to repository using Viewpoint Repository mode results in CPD0104 ‘Expression not allowed for parameter REPORT’.
    • A migrated View and Excel workbook, opened in Repository Mode when refreshed, gave error ‘Index was out of range. Must be non-negative and less than the size of the collection’ after logging into the Repository

    Enhancement:

    • Emailing from Viewpoint as PDF will now allow you to change to attachment name.
    • Email dialogue window in Viewpoint will now provide a box for the email Subject.

    June 2017

    Version 10.17.163

    Fixes

    • The Excel Add-in in version 10.17.104 of Viewpoint did not work with spreadsheets created with earlier versions of Viewpoint.
    • View Designer could end in error when editing some GROUP BY views.
    • View Designer was not correctly omitting literals and constants from GROUP BY Clause.

    April 2017

    Version 10.17.104

    The following Enhancements are included in this version:

    • Dashboards now have a setting for Default Font.
    • The Viewpoint log now includes the date and time in the filename like so: VPlog_02242017_113011.txt. Files older than 7 days will automatically be deleted.
    • New command line switch added to allow logging to be turned on without the warning message to the user /z:q

    The following Updates are included in this version:

    • View Designer (with server connection of remote—not *LOCALSYS or *SEQUEL) displays error ‘SQ9999 Error occurred in SQL Call Level Interface’ when switching to the Files & Fields and there is an alias field used mixed as “SumLval70”.
    • View Designer (using SERVER(*LOCALSYS) SYNTAX(*SEQUEL)) removed the GROUP BY clause when switching to the Files & Field tab and view contained a WDATA on the SELECT clause.
    • In View Designer Files & Fields tab (for *LOCALSYS views only) derived fields that result in a DATE data type will now apply a type of DATE in the TYPE field.
    • In View Designer (using SERVER(*LOCALSYS) SYNTAX(*SEQUEL)) the Expression Editor to build the WHERE clause should use the AltName of an expression, not the expression itself.
    • In a *LOCALSYS view, when building conditions in the WHERE clause Expression Editor, file identifiers are included when you select fields from files and not variable names.
    • Opening a view in View Builder when files are not library qualified on FROM clause displays error 'A library is required for selection'.
    • Application open in design will now detect any changes made to the view.
    • Temporary files created by the Viewpoint OLE DB Provider will now be deleted.
    • Emailing IBM i joblog from Viewpoint when there is a single apostrophe in the message text, failed to deliver email.
    • When saving a client report over a view with either a numeric or an expression type variable (with no default value), will return an error that the value is not a valid numeric value for the numeric variable, or a syntax error for the expression type variable.
    • Running a dashboard from a Viewpoint shortcut (.vpt) multiple times could produce a ‘runtime automation’ error message. Problem introduced in VP 11.16.294.
    • Viewpoint is buffering data from a view when run in a dashboard, even though charts are designed beyond the initial records.
    • The ability to provide custom edit masks on 7 segment digital gauges has been restored and improved by extending the supported mask from 6 characters to 20 characters.
    • In Dashboard designer, resizing gauges very often causes the gauge to shrink or disappear.
    • Running a client report from a script using the REPORT command to email displays the error MCH1210 ‘Receiver value too small to hold result’.
    • Saving a client report when the view had an Expression (EXPR) variable, without a Default Value, would fail.
    • In the Script Designer on Windows 10, prompting a second command did not show the command prompter, but the log showed the error ‘there was a problem with DLL: cwbunapi.dll’.
    • From the Excel Add-in, Refresh All was not working with two views from two different hosts.
    • From the Excel Add-in, when refreshing data if a prompted view returns no records, the current data is not blanked out.
    • From the Excel Add-in, when refreshing all variables, even if from different views, will combine into one prompt.
    • Dynamic Drill Down and Show Details option display syntax errors when the view used WDATA.
    • Viewpoint Administrator will now all you to delete a remote server entry.
    • A .vpt shortcut to create PC file without /D switch should prompt for path information.
    • The Import > Query option will now use the SERVER and SYNTAX settings from the User’s defaults.

    October 2016

    Version 10.16.294

    The following enhancements are included in this version:

    • Text size on many objects (views, host table, client tables, Client Reports, Scripts, Script Views, and Applications) was increased from 50 to 128 characters.
    • View Builder and View Designer will support ‘Fetch First’ with a *LOCALSYS or *LOCAL connection and *SERVER syntax.
    • Allow library name to be specified when saving Viewpoint object to Repository.
    • In the Script Designer Variable tab, grid columns will match the view designer to make more readable.
    • Excel Add-in now supports 64 bit Excel.

    Dashboards

    • The 2 dimensional chart options were added to menu dropdown.
    • Copy/Paste actions added for text boxes, action button and graphics.
    • New option for Web Preview to see an HTML preview.
    • Snap to grid for easy alignment of text, action button, and result windows.

    The following updates are included in this version:

    • In Administrator, the copy defaults option was using the default user—not the selected user.
    • From Administrator, Set Defaults option, copying a current user defaults to a new user profile causes a
    • View Builder and View Designer give error that file cannot be found when the datasource is another *ISERIES connection.
    • View Builder did not allow creation of multiple derived fields.
    • In Warehouse Builder from ViewPoint Explorer, caused error due to parameters not being passed.
    • Script View run in Viewpoint Explorer runs the body of the script twice.
    • Prompted Script that runs from a Viewpoint shortcut results in the following error MCH1202 unmonitored by VPTJMSG at Statement *N, instruction X'0011'.
    • Option to schedule an email as PDF failed when using the IBM Job Scheduler.
    • Email request from Viewpoint as PDF ends abnormally, error in print command, when host version is less than R11M04 (for Sequel) or R10M04 (for Showcase).
    • From View Designer, file in FROM clause specified with *LIBL does not send message when library is not on the library list of Viewpoint job.
    • From the View Designer Files & Fields tab, when designing a DATABASE(*LOCALSYS) SYNTAX(*SEQUEL) View, use of EDTCDE(L) on a numeric field will be dropped when moving to/from the Files and Fields tab.
    • View Designer should omit literals and constants from GROUP BY Clause.
    • View Designer not handling French à character in FILE names with SERVER(*SEQUEL)
    • From the View Designer, displaying view result after stepping in to a SELECT statement of a UNION view causes and unwanted ORDER BY to be added to the full SQL Statement.
    • Once a DISPLAY returns no records, the script ends without running the remaining steps.
    • When a user has assistance level set to 1 or 2 and View Builder is enabled, the setting renders the CRO (User based license) design window in a small frame and it cannot be resized.
    • When two DATE variables used a default value and the second variable was *NOPROMPT, the first variable used the wrong default value.
    • Unable to enter date of 12/31/9999 in date variable when run in ViewPoint.
    • Dynamic Drill Down (Regroup or Show Details) fails with a *LOCALSYS view with file qualified fields.
    • Creating a shortcut from a view display that also includes a chart produces a .vptchart file type instead of .vpt.
    • Expression Editor better handles field names with double quotes.
    • Subtotals in view results did not show if the ORDER BY fields used a field with an alias name.

    Dashboards

    • A dashboard with an Action Button set to Autorun fails to run a prompted object successfully when the variable is passed using /SETVAR.
    • Chart title should be consistent at design time and run time.
    • When the Dynamic Drill Down List file (SEQUEL/VPTDYNFLTR) contains a list of fields, only those fields are available for dynamic drilldown. If the file contains fields, but no fields that exist in the files that a grouping view references, then the option to view the complete list should appear in SWI, as it does in ViewPoint and SWS.
    • Reprompting from a dashboard with a graph for new choice and receiving less records, produces an Overflow error.
    • Digital gauge custom mask entries, like a $ sign, don’t display correctly.
    • Inserting a view that returned no records cause the Designer to hang.
    • Variable prompt windows often show behind the dashboard and cannot be seen.
    • After adding chart, right click for Properties caused Properties window to come up behind designer window.

    April 2016

    Version 10.16.098

    The following updates are included in this version:

    General

    • From the ViewPoint Explorer, clicking on an object and cut, the paste action gives error CPD0043 ‘Keyword OBJTYPE not valid for this command’.
    • From Script Designer, unable to save a script if changes were made after saving it
    • If a Client Table is opened for design, but the only changes made are in the Group Footer Editor, the warning message "Do you want to save changes to this Client Table" was not issued.
    • Using *SERVER syntax with a Grouping view with expressions for columns, Drill-Down/Show Details creates invalid SQL syntax.
    • Runtime SQL conversion when using SERVER(*LOCALSYS) and SYNTAX(*SEQUEL) will convert inner join to WHERE condition with an additional pair of parentheses.
    • Runtime SQL conversion when using SERVER(*LOCALSYS) and SYNTAX(*SEQUEL) failed when a UDF name is schema qaulified (i.e. select sequel.valid_date(2150101,''*CYMD'')).
    • VALID_DATE function loops in rare circumstances.
    • ViewPoint option for Field Sorting will now default to position, not alphabetic, for new installs.
    • Import Query/400 option will now default to a view, not a report.
    • Creating a Host Table over a view using the ViewPoint Universal Driver (JDE or *ADS connection) caused an error.
    • From View Designer Files & Field tab, removing any files except the last file caused ViewPoint to hang.
    • Application Builder can now create drill to option for Client Reports.
    • Silent Install now supports the Excel Add-in install.
    • Dashboard Action Button to Email View Results was not sending view text for subject line for PDF attachments.
    • ViewPoint is unable to save view containing a WITH predicate.
    • From the Variables tab of View Builder or View Designer, in the Integrity Test for DBLIST, the ‘View List’ button di not return records when the view name was specified.
    • The Expression Editor of both View Builder and View Designer now has multiple entries for the DATE function.

    Dashboards

    • Default background color changed to white.
    • Default font changed to Verdana size 11 for text and Verdana size 9 for Action Buttons.
    • Default chart colors changed to 128 Pastels.
    • After bringing a chart to the front or back, it will now be sizable.
    • Text in text boxes will now be centered.
    • Gauge using the COUNT function that returns a single record with now work correctly.
    • Gauges did not work correctly when PC region setting did not match IBM I setting.
    • Background image size changes on mouse click.
    • When closing a dashboard using the X, the save option will now give you option to save as pc object as well as IBM i object.
    • If a chart is built over a Client Table, the hide data option will work.

    Excel Add-in

    • Able to add View columns to non-contiguous columns in Excel therefore allowing blank columns in the spreadsheet.
    • Spreadsheet containing a view with a name that contains a special character (such as @), did not have the add-in available.
    • Add-in would freeze if using a prompted view, choose Refresh, Click Cancel on prompt window, and close the spreadsheet.
    • Choosing View References and then columns causes error Cannot find column[viewname] Line 0 in some instances.
    • Using a view with hidden columns (WDATA) showed incorrect fields in Choosing Columns list.
    • View that returns one record will not refresh when the second requests has more than one record.
    • On the 22nd refresh, the add-in would hang.
    • Extendable area not automatically resizing when a prompted view is used.
    • When the view contained a grand total and a calculation was added to the extendable area that is a percent of total, when the refresh returned different amounts of data, the calculated field was wrong.
    • Improved control on Column Selection window.
    • The Add-in will now use brings data into the spreadsheet, columns should be formatted as specified in the view.
    • Add-in is now supported for Excel 2016 32-bit.
    • System Default will use Default Sever from ViewPoint Options.

    View Builder

    • The Files tab will use the ViewPoint Options to include or exclude logical files in the list.
    • Creating a new view with SYNTAX(*SERVER) with a left outer join corrupts the SQL statements and causes ViewPoint to hang.
    • View Builder will now use the ViewPoint option for Field Sorting on the Field tab.
    • The File tab will now have *FAVORITES in the Group pull down to use the favorite list of files from ViewPoint Options.
    • View Builder hung on the Join tab when the same file was added more than once.
    • Sort tab will now show list of fields when SELECT * is used.
    • Sort tab now allows properties for Ascending or Descending and Absolute value sorting.
    • The Field tab will now use the ViewPoint option for Field Sorting.
    • On the File tab, resequencing the files did not actually change their order on the FROM clause.
    • On the Field tab * for all fields is now removed when fields are selected.
    • Expression Editor of Filter tab now has a third combo box for field comparisons.
    • File tab will provide Member list for multiple member files when using SYNTAX(*SEQUEL).
    • Filter tab will now support derived fields when using SERVER(*LOCALSYS).

    The following enhancements are included in this version:

    • The Auto-join process has been updated to support views with SYNTAX(*SERVER) when the join criteria appears on the WHERE clause.
    • The Edit User Library list option and be restricted by setting Allow Command Line to No in the user defaults.
    • Dynamic Drill Down (details and regroup) is now supported with a datasource of *EXCEL or *ACCESS.

    November 2015

    Version 10.15.317

    The following enhancements are included in this version:

    • Silent Install now supports modular switches to control installation of Client Report, Administrator, and Excel Plug-in.
    • In the email to download the Client Table Viewer, the link was updated.
    • New Excel Plug-in with the following:
      • Extendable area to allow Excel calculations based on dynamic data
      • Field/Column selection
      • Limit and modify number of row returned
      • Add multiple views to the same sheet
      • Add multiple views to different sheets
      • Selectively re-prompt or re-prompt all
      • Jump function to move easily through the spreadsheet to any extendible area or view

    May 2015

    Version 10.15.167

    The following updates are included in this version:

    • On a French language PC, from the results of a view or host table, the option for Format Layout gave an unstable error.
    • On PC with language settings that use the comma instead of the decimal point, opening ViewPoint gave an unstable warning message.
    • View Builder was removing the WHERE clause if it contained a NULL comparison.
    • In View Builder, creating a CVTDATE expression erroneously assigned an edit code M.
    • In View Builder, the File drop down list did not render a list based on the file name filter if you keyed in a library name first.
    • Editing the User Defaults using a drop list to the set one of the library values cause the user defaults to become corrupt and would cause errors about invalid parameter values.
    • View Builder Fields Tab, creating expressions without assigning a name results in the builder creating invalid names, such as 1 & 12.
    • View Builder Fields Tab, editing a field creating an expression, if you choose Cancel the original field is deleted. If you choose Done to finish, the field/expression is moved to the bottom of the field list.
    • From view or host table results, selecting Format\Layout on a French language PC caused a runtime error.
    • ViewPoint not handling French accent character in library names.
    • Decimal conversion error on product version when opening ViewPoint when PC setting used decimal instead of period like on a French language PC.
    • From the embedded Client Report designer, Display Results failed if report is built over a prompted Script View.
    • In View Builder, selecting a field and choosing the Edit (Pencil) button, then clicking on the Editor button, if you click Cancel at this point, the field is no longer being deleted from the list.
    • In View Builder when creating an expression, if you click on Done before entering in an alternate name, you now get a message that requires you to enter in a name before completing.
    • Improved message handling in View Designer when the SQL statement is not valid before re-entry into View Builder allowed.
    • Improved message handling in View Designer assistance level 3, when entering View Builder with a blank SQL statement.

     

    Back to Product Index

     

    Copyright © HelpSystems, LLC.
    All trademarks and registered trademarks are the property of their respective owners.
    Last Published: 201912051020