Refreshing a View that had extra spaces in a Filter or Calculated Column would cause a "Not Responding" state in GridView 8.1A.
8.1A (20070827) - Sept' 07
Compatible with Windows® VistaT.
Compatible with Adagio Lankpaks 8.1A. Lanpaks must be 8.1A for all Adagio 8.1A modules.
Adagio download files, installs, workstation installs, all workstation install (\softrak\allwkst\allwkst.exe), and the Adagio Check System utility (chksys.exe) are now signed with a digital certificate using VeriSign to allow you to verify the Publisher is Softrak Systems Inc.
Vista does not support the old style Windows Help (.HLP files). All .HLP files were converted to compiled HTML help (.CHM files), which are supported by Vista.
For security reasons Windows does not permit .CHM help files to be run from a network drive. This is true in XP as well as Vista. The .CHM files must be run from a local drive. Adagio 8.1A installs all .CHM help files to your local hard drive and loads them from there. The workstation install also copies .CHM files to the local drive.
When switching window/task in Vista with Alt-Tab or the new Flip 3D (Windows-Tab) an image of the current Adagio screen is shown rather than just the icon of the Adagio program.
The formatting of dates and text sent to Excel has been improved.
Updated @Z80C. Added *IC Item Loc w IC Item ( @Z80C206 ), IC Item Location ( @Z80CILO ) linked to IC Item - Selected ( @Z80CICM ). Added missing index to *OE Ord Detail w Head, Head Ext so that extended information shows.
New function ToWords that returns the text representation of numbers or amounts. For example 914.38 returns "Nine Hundred Fourteen Point Three Eight" and $914.38 returns "Nine Hundred Fourteen Dollars and Thirty Eight Cents".
New function RecordNumber that returns the physical record number in a "flat" or "index random" file. The record number can be useful for a developer when attempting to track down a problem with selected data. The value returned for a "idt" file is undefined.
New header / footer codes have been added:
$L prints the Filter name
$V prints the Filter expression
$Y prints the Table name
$Z prints the Table description
Date format MM/DD/YYYY has been added.
Added 'Regional Number' and 'Regional Currency' formatting.
8.0E (20061017) - Oct' 06
Named Sort Sequences have been added and are used in conjunction with Filters.
You can now have a "negative link" between two Views. Negative links display all records that do not contain the linked field.
You can now "Join" one link with another. This allows a link to search within the row set already displayed in the link View.
Recently used lists have been added to Dictionary and Table selection.
Named Item file may contain [Include] section which will help when defining repetitive entries.
Selecting "Refresh on Open" in the defaults dialog, automatically selects "Save without data".
Added command line parameter '/?' to display a short help screen of the available command line parameters and Server Code.
Users without Edit permission on the command line ( /C ) can no longer disable Filters to get a View of the entire contents of a table.
Users without Edit permission on the command line ( /C ) are allowed to change column order.
Allow /S to connect, without stopping, when only one server is active and Company, User ID and User Password are provided.
Allow fully qualified server, company, user name and password to skip login dialog.
/S without a server name will display a list of available servers.
Corrected handling of comments inside strings.
The Sort function now uses the collation sequence of the language the user is running.
8.0D (20050914) - Sep '05
Support for Adagio GridView Server added.
Hints pop up when the mouse cursor hovers over column titles. The field name and link are shown for data fields; formula text for calculated columns.
Fixed problems in GridView 8.0C experienced when run on Windows 98.
8.0C (20050705) - Jul '05
Now supports multiple, named filters into a table.
You can now have GridView read all files that match a wildcard specification.
A new menu choice allows you to set the "Run date" for a View.
You can now import or export named filters or calculated columns for use in other Views.
You can now multi-select items in a linked view, and see the results of all of the selected items in the link.
New Query functions have been added: =DATAFILENAME() and =FILTERNAME().
A new function "=LIKE(S1,S2) has been added.
New pattern matching functions have been added to locate records.
The summary state of a view is remembered, even when it is refreshed. Formatting is preserved on the summary view.
You can have GridView automatically translate "coded fields" in a view, without requiring a formula.
Formatting is preserved on totals when a view is summarized. The formatting of numbers has been improved to prevent (0.00) display.
You can see the properties of fields displayed in the View.
Only user "SYS" is entitled to see encrypted data fields.
ExcelDirect no longer sends hidden rows and columns to the spreadsheet.
You can now only delete a computed column if no other columns refer to it.
Error reporting has been improved.
The "Edit" Menu is now accessible if "/C" is not specified on the command line.
8.0B (20040830) - Aug '04
A composite table "Adagio {Composite Tables 6.8B}" is installed with this version of GridView. This table can be used to define views that incorporate fields from related tables.
Added 3 new views to illustrate use of composite tables: AR Transactions with Customer Name.gv, GL Posted Transactions w Account Description.gv, and AP Transactions with Vendor Name.gv.
The Toolbar requires resetting in this release.
Refresh of linked views will be much quicker in most cases.
Excel Direct has been improved.
Columns can now be formatted, renamed, deleted and hidden from the View by using the Right Button on the Column Title.
"Save Workspace As..." and "Save All" options have been added to the File menu.
"Named Items" have been added which, when used in conjunction with the GetNamedItem function, provides greater flexibility when defining a View.
Column Minimum, Maximum and Average have been added to Total and each have a different "highlight" style.
Linked Views will attempt to match on "Column Name" if no other "index" was found.
An optional parameter, to provide the initial value, has been added to QueryString, QueryNumber and QueryDate.
QueryString, QueryNumber and QueryDate will remember the last value entered and use that as the default value.
The Calendar used in QueryDate has been updated.
A new DateString function has been added to give greater flexibility when formatting dates.
Date formatting for MM/DD/YY has been fixed.
Excel direct now transfers column and row formatting.
The number of decimals defined in the dictionary is now used when displaying numeric fields.
Integer type fields such as Fiscal Period can now be used for summarizing.
Using the Right Button on a Column Title now allows for complete control over the format of the column. The formatting information is now saved with the View.
View by rows now hides the underlying grid.
Previously, if you cancelled a refresh and kept the records the Row and Column formatting was not performed, this has been fixed.
The "View by Rows" has been added to the view definition.
Improvements have been made to the reporting of errors.
Corrections were made to the functions Day(), Month(), and Year() which would sometimes return unexpected values.
8.0A (20030515) - May '03
The toolbar requires resetting in this release.
A summarize View has been added\.
A toolbar button has been added to enable and disable a Filter attached to a View.
A Sort toolbar button has been added.
Columns that make up the Sort Order are now highlighted with a color at the top of the column title.
A Refresh toolbar button has been added. The View can also be refreshed by pressing either F5 or F9.
"Tile Vertical" has been added as a Window option.
Beginmonth(), Beginweek(), Beginyear(), FiscalStart(), are available Date functions for defining formulas and filters with "floating" date ranges.
QUERYDATE("prompt"), QUERYNUMBER("prompt"), QUERYSTRING("prompt") are available to ask the user a question and have the result stored or used in a View.
Calculated columns can be used in Filters.
Calculated columns can be used in later defined calculated columns.
Lines beginning "//" are treated as comments in filters and formulas.
You can now save a View without any data.
Columns may be "Frozen" in position to allow easy scrolling of data.
Added dictionaries for ACCPAC Plus Accounts Receivable V7.0A, General Ledger V7.0A and Inventory Control V7.0A.
Highlighting a previously used file on the File menu displays the full path of the file on the status bar. Submenus have been added for Recent Workspaces and Recent Files.
ExcelDirect functionality has been improved in speed and formatting. Transfers can now be aborted by pressing the Escape key.
Sorting a large number of rows is now significantly faster.
The arguments and returned values from the string functions Find(), Mid(), Replace() and Choose() have been made consistent.
Data elements that contained a "\" character did not display properly. This has been fixed.
Sometimes the calculated value displayed on a right button click from a selection of entries would be incorrect. This has been fixed.
The install and workstation install now check to be sure the Windows user has administrator rights to the local machine.
The install now checks for Adagio programs in use by other workstations on a network.
6.8A (20021015) - Oct '02
Improved method of creating and modifying Filters and Calculated Columns. Views are automatically converted when they are first accessed. converted Views can not be opened by previous versions of GridView.
Filter definitions may use Calculated Columns.
Calculated Columns may be used when Linking Views.
Added Excel Direct to Export To menu and to the File Menu bar.
Help has been modified to reflect the improved method of defining Filters and Calculated Columns.
6.8A (20020910) - Sept '02
GridView stopped working 60 days after its initial use, even if you had registered and licensed the product.
In some cases, the Criteria was not saved and therefore the result was incorrect.
Some context Help links have been corrected.
When you defined a link and browsed for the View to link to, the listed files also included the workspace files (*.GVS). If you chose a workspace file, an error resulted. Only View files (*.GV) are shown now.
In rare cases, the link on some fields did not return the correct information.