|
Recent |
The update history for Version 3.0X of QueryCalc. The dates shown below are various release dates for recent versions of QueryCalc. You can find your version date in the text at the bottom of the "Do You Need Instructions" screen. If there are features in this list that you need but are more recent than your copy, please call for an upgrade. Ideally, your QueryCalc version should never be much more than six months behind today's date.
April 14, 1998: /PRINTDB
The PRINTDB command was enhanced so that not only detail list reports could be stored to a user-named KSAM dataset, search sets can also now be similarly stored. The new command form is: /printdb !x filename, where "x" is a search set letter. Executing this new command causes a single-dataitem KSAM dataset to be created and entered in QueryCalc's dictionary for immediate retrieval. May 13, 1998: Graphics
Two new commands, /mo (memorize object) and /po (paste object), were added to the list of graphical commands. A mechanism to duplicate defined objects (lines, boxes, logos, & graphs) had been requested by a number of users. June 9, 1998: /LOAD
The /LOAD command was modified to tolerate missing databases. Previous versions of QueryCalc would abort the loading of a spreadsheet if all of the databases were not in existence at the time the spreadsheet was being loaded, causing users more problems than were necessary. July 16, 1998: UDQF
The UDQF function was modified so as to use a proper rereading list. With the advent of multiple level rereads several years before, a subtle change was put into the reread file structure that would occasionally cause the UDQF function to repeatedly read the same record over and over again. This has now been repaired. July 23, 1998: non-Y2K
The date functions in QueryCalc were modified so as to support those users with databases that are not properly being converted to a CCYYMMDD format. One common technique that is being employed by YYMMDD users is to specify a changeover date such as 1950. Any year number less than 50 would then be presumed to be in the 21st Century. Any number greater than 50 is in the 20th Century. A second model is to specify 21st Century years as A0, A1,... QueryCalc's date and day functions now automatically support both six digit Y2K workarounds without requiring the user to modify his or her reports. September 5, 1998: /SAVE
The /SAVE function was modified so that those users with SM capability may now save a QueryCalc report to any group and account on their HP3000. Similarly, those users with AM capability may save to any group within their logon account. Lesser-capability users remain restricted to saving their reports only in their current group. September 14, 1998: Y2K Julian Dates
A date parsing error was found and repaired in the Julian Date function. The error affected only the JD routine, and only for one specific date. If the input to the JD routine was "20000229", the date was declared not legitimate. All other representations of the date "February 29, 2000" however worked without error. The error has been corrected. October 20, 1998: Statistical Sampling
A problem was found when using the statistical sampling phrase ";SAMPLE=.00x" in query questions. Very small sampling rates were being ignored due to a mismatched data type error. That error has been corrected. October 26, 1998: Y2K Long Date Presentations
A few users have requested that the DAT$4 through DAT$8 functions present the year in YYYY format, rather than merely as YY. The functions themselves have always been Y2K-compliant, maintaining both century and year. The century was previously truncated by design in QueryCalc for presentation purposes. October 28, 1998: New Find Function
A new find function, /F, has been put into QueryCalc. The function begins its search from the current spreadsheet cursor location and proceeds, if necessary, in a loop through all of the pages, back to its starting position. December 4, 1998: On-line Help Updated
On-line help for QueryCalc Version 3.0 has now been made completely up to date. Several new features that have been in QueryCalc for some time, but which were previously undocumented, are now fully explained. April 8, 1999: Engineering Test
Substantial modifications were made to the internal structure of QueryCalc in preparation for the new PC Windows-based client. August 27, 1999: Check Text-writing Added
In order to provide the capacity to convert a number into English text, a new function, ENG$( ) was added to QueryCalc. This new feature is especially valuable for writing bank drafts and checks. November 22, 1999: Search Set Error & non-Y2K
A rare error that had existed in QueryCalc's search set essentially from its first codings was discovered and corrected. It was possible to obtain incorrect data if the search was: (i) composed of an I1 or I2 dataitem, (ii) contained a value where the least significant byte was equal to decimal 32 [a 1 in 256 chance], and (iii) if the search set was applied to a dataset so that it was extracting more than 25% of the dataset's records. All three conditions had to be in place to engage the error. January 4, 2000: NAM$( ) Function
A minor improvement was made to the NAM$( ) function so as to increase its intelligence in handling names that begin with "Mac". A similar improvement was added to better handle the phrase "PO Box". January 7, 2000: New Relational Operator
A new query question relational operator was added to the previously existing seven operators. The new operator is "is not between," the logical negative of the "is between" ("ib") relop and is denoted by using either the phrase "nb" or "inb" in a query question. May 30, 2000: Graphics and Macro Update
Several minor changes were made to the graphic definition pages. The most significant of these is that autoscaling in the graphs can now be turned off and the graph's y-axis maximum may now be user specified. June 29, 2000: A Typing Shortcut
The standard entry syntax for an @rereading query statement is: |