Maintenance Releases Here you will find information outlining revisions made in each maintenance release of the Quality Window 5 Product. Should you have any questions concerning a change, contact Busitech Tech Support directly. The latest version of Quality Window is 5.0.819 Build No. Details of Changes to Quality Window 5.0.0.819March 15, 2019 Bug Fix QWUpdate 5.0.0.426 Variable to store security information was not being saved properly when more than one user editing the same record. The last editing user should e persist. QWAdmin 5.0.0.165 Fixed data corruption bug. Saving structure changes, make more structure changes, and save again without closing the application may lead to data curruption. 5.0.0.818February 27, 2019 Bug Fix QWUpdate 5.0.0.425 Autosizing of editor grid column widths has been updated to ensure data entry column is always visible Variables automatically updated will now properly trigger internal change flag. Bug applied to IO files and variable to store security information. QWReport 5.0.0.199 Summary stats have been updated with new logical rules for: Total % in Ppk Total % in Cpk Total % in Sigma Total % In CrTzCpk Total % in CrTzPpk Numerator T = Sum of variables with Ppk > 1.33 ORSD-Pop <= 0.0001 And Observed N OSL = 0 Denominator V = Sum of variables with Ppk <> N/A ORSD-Pop <= 0.0001 And Observed N OSL = 0 Numerator T = Sum of variables with Cpk > 1.33 ORSD-Pop <= 0.0001 And Observed N OSL = 0 Denominator V = Sum of variables with Cpk <> N/A ORSD-Pop <= 0.0001 And Observed N OSL = 0 Numerator T = Sum of variables with Sigma >= 6 ORSD-Pop <= 0.0001 And Observed N OSL = 0 Denominator V = Sum of variables with Sigma <> N/A ORSD-Pop <= 0.0001 And Observed N OSL = 0 5.0.0.816November 28, 2018 Bug Fix QW5SharedConfig.exe 5.0.0.23 Fixed runtime error 429 ‘ActiveX component can’t create object.’ QWXLtoQW.exe 5.0.0.45 Fixed runtime error not being able to detect loaded copy of Microsoft Excel Added retry counter for connecting to Microsoft Excel. Will try 30 times before displaying error message. QWUtilities.exe 5.0.0.57 Export. Added additional error description in error trap message Export. XLS and MDB now have option to include schema and stats as separate worksheet or tables QWAdmin.exe 5.0.0.163 Fixed improper validation of the Variable to Range pointer for Range type variables. 5.0.0.812 October 12, 2018 Bug Fix QWAdd.exe 5.0.0.32 Trap scripting error. QWSumStat.exe 5.0.0.82 Program would crash if a View no longer existed. QWUpdate.ocx 5.0.0.418 Edited values would not be saved to the current record under certain conditions. QWLaunch.dll 5.0.0.12 & QWLaunchTray.exe 5.0.0.43 Use default configuration if existing configuration is corrupted. 5.0.0.812 September 27, 2018 QW.exe 5.0.0.812 Changed the Edit screen to display the current variable values when a record has been updated by another user or process. More information. QWLaunchTray.exe 5.0.0.42 Installer no longer overwrites QWLaunchTray.IQW QWFilePack 5.0.0.30 Corrected network error where network drive was no longer available Added QWVersion.TXT containing current version information to all File Pack zip files Removed square brackets and replaced underscore characters with hyphens for package file name QWUtilities 5.0.0.52 Resolved errors when exporting to .XLS. Reference Excel 8.0 instead of Excel 5.0. 5.0.0.807 August 7, 2018 Recompile for version number upgrade Fixed Runtime error ‘can’t show modal form’ when auto refresh triggers and modal dialog window is active Fixed runtime error “invalid procedure call or argument” when auto refresh triggers and modal dialog window is active QWDLG.DLL v5.0.0.245 Resolved bug with directory file access flag (read/write) not being passed to QW QWAppConfig.DLL v5.0.0.19 Revert shareable file paths to default if missing in configuration file QW5SharedConfig.exe v5.0.0.20 Allow changing of source file path in copy dialog Allow changing the installation path value QWVarInfo.ocx v5.0.0.112 Validate popup file exists prior to saving changes Prevent saving of application data if validation failed QWUtilities.exe v5.0.0.50 Fixed runtime automation error in Export QWTool.dll v5.0.0.311 Added new objects for writing change logs and message logs QWUpdate.ocx v5.0.0.392 Fixed runtime error after Popup field validation 5.0.0.806 August 17, 2017 Recompile for version number upgrade QWMerge.exe 5.0.0.58 Changed help link to QWMerge.CHM from QWMerge.HLP Minor user interface updates QWUtilities.exe 5.0.0.48 Recompile for version number upgrade QWAccess.dll 5.0.0.456 Extended support for file write caching. Write caching is enabled by default. QWSelect.dll 5.0.0.476 Ensure file write caching is disabled for data integrity Recompile for new QWAccess.dll QWUpdate.ocx 5.0.0.388 Ensure file write caching is disabled for data integrity Recompile for new QWAccess.dll 5.0.0.805 June 22, 2017 Improvements to auto refresh and error trapping Do not display progress window if main window is not the active window. Fixes “can’t show non-modal form” errors. Main window is disabled during refresh until data objects are fully synchronized. Fixes runtime object errors. Fixed subscript out of range error on Prioritize if template x-axis field is not defined QWAccess.dll Added retry counter method to reset broken file handles Added flag to force write through of data to server based data files Added LastError and LastErrorMessage properties QWUpdate.ocx Implemented the QWAccess retry counter method for broken file handles on Save QWUtilities.exe Fixed file handles not being released after export 5.0.0.804 May 16, 2017 QWSQLWiz Added support for IBM AS/400 SQL Database (no brackets for Table and Column names) QWTool Changed SetQWlimitsFromRecordset so that all instances of the same XREF will get the same specs and targets QWCharts Ensure first Trieto column width does not exceed the actual client width of the control QWLogView Improve performance on loading log files 5.0.0.803 February 17, 2017 QWTool subprogram QWRS232 Modified so that it works in locales where comma is used as decimal QWAdmin.exe (QWAppl,QWGlobal,QWPopup) Handle issue where security file is on server and network is down Allow Grid View to support locales with commas in numbers QWUtilities Modified QWAccess so that a change in structure does not recalc Popups and Lookups providing a substantial speed increase, plus added a ReCalcRecordSlow routine if needed 5.0.0.802 October 6, 2016 Restore update tab caption to “Add” after failed or cancelled security validation QWDLG.dll Resolved application crash in QWMerge while calling the InputDialog module. QWLogView.dll Add Expand All/Collapse All functionality to the grid QWScript.qwx View Audit Trail macro: Set the form caption and print footer to the application title QWAdmin.exe Fixed warning message on Security User Identification from max 50 to 20 characters Allow more than one QWADMIN and ADMIN userids (ie QWADMIN2, QWADMIN3) QW5SharedConfig.exe Fixed copy dialog to respect the copy source and backup destination checkbox options Changed backup labels on import and export dialogs to me more consistent with other dialogs Refer to Shared Configuration Manager Documentation for details. Expanded the Security capabilities to allow for individual User Id’s to have separate capabilities. Refer to Enhanced Security options in build 801 and higher for details. 5.0.0.801 July 5, 2016 Removed dependencies on System Registry and System32 folder files in all modules Import old settings from registry if application configuration file does not exist Ensure proper default values for all settings that do not exist in configuration file More user interface and functional settings are now being stored in configuration file Startup test for system files now uses paths returned from shared configuration Read and write all configuration settings to application specific configuration file QWAppConfig.dll New module for managing application and shared configuration settings QWRep.DLL Use path to statistics file from shared configuration settings QWDlg.dll Deprecate all writing to Windows Registry Import old settings from registry if application configuration file does not exist Read and write all settings and recent file list to application configuration file QWSQL.DLL Fixed issue with duplicate keys (mixed case) using Transpose function 5.0.0.800 March 15, 2016 Improved error handling for network connectivity issues Updated Samples Database scripts so that they look for QW install folder Updated Process Monitoring to support new COA for Excel Updated the COA Excel macro so that it supports $SUMMARY 5.0.0.785 January 5, 2016 Improved error trapping in auto refresh when querying file date and time and network unavailable. Allow QWAdmin Applications Grid View to display Limits/Min/Max with trailing zeroes based on decimal places. Add checkbox in QWCheck to skip corrupted records instead of attempting to repair them. 5.0.0.784 June 16, 2015 Variables with @POP and @XBAR calculations now use same method for determining range statistics. This change effects banding on range chart and other dependent statistics. Allow Windows 10 installations. 5.0.0.783 March 17, 2015 In order to become inline with textbook definitions for our statistics, we have revised our Cpk and Ppk calculations as follows: Ppk will now reflect what we used to display as Cpk, in that it uses population SD. Cpk will now use the Average Range SD in its calculation. Pp will now reflect what we used to display as Cp, in that it uses the population SD. Cp will now use the Average Range SD in its calculation. We have also added some new statistics such as Cpu, Cpl, Ppu and Ppl. The Prioritize screen will now display Ppk instead of Cpk for the Hatchart and Six Sigma screens. Any scripts, reports or macros that were using the Cpk statistic may need to be manually changed to the Ppk statistic. Changed statistical references from Cpk to Ppk (Hat Chart and Six Sigma on Prioritize) Fixed issue with deleting Source Field Fixed issue with dBase class GetTableValues, PutTableValues Fixed issue with working with MHT files Update code to support new functions in ChilkatMHT Changed Hat Chart control to use Ppk instead of Cpk Close popups immediately after opening it to release locks on Add screen Upgrade to new version of ChilKatMHT.dll Added support for PPK and @MPPK QWAdmin.exe updated Added Total % in Ppk and Total % in CrTzPpk statistics Continue reading IO files on Add screen even if one does not exist Updated new statistics and defaults 5.0.0.781 August 20, 2014 Allow for more than 676 columns (ie beyond column AAA) in QWXLtoQW Allow for more than 676 columns (ie beyond column AAA) in QWXLtoQW Allow Seat Demo licenses and longer demo days Copy/Paste a single blank cell in Grid View would crash in QWAdmin Display_MSEXCEL_Form now supports $REPEATROW and $REPEATCOL in scripts in order to archive multiple rows or columns based on the number of records in the Logsheet Was not properly displaying deleted records in some cases in QWLogView Allow popup filenames to be saved with more than 8 characters 5.0.0.780 May 9, 2014 Changed default Prioritize screen to be Cr/Tz/Cpk (HatChart) Resolved log sheet not being properly cleared before loading a View Set default auto refresh to 5 seconds (new installs only) If during an Add, last record is null, then delete record instead of displaying the 2019 Date error Min and Max limits were not carried over from current view Remove restriction that QW Date/Time format must be yyyy-mm-dd hh:mm:ss in QWMerge Clicking on Popup data would crash if clipboard contained invalid data QWAdmin AutoNumber pointer not moved properly when variable inserted before it Allow Security Database edit screen to be sorted on columns Don’t allow Copy Selected Variable on V1-Date or V2-Time Don’t store path information in QWAcrhive Added new Excel Addin for Real Time Data to QWDataHub 5.0.0.778 August 6, 2013 Added support for new Range Rule Violations Remove 40 character restriction from XREF Preview in QW button now works in QWXLtoQW Allow for non-US locales in QWComSrv Allow for non-US locals in QWAdd Added support for new Range Rule Violations in QWAccess Added support for new Range Rule Violations in QWAdmin Removed 3 character Rule code restriction in QWAdmin Fixed Copy Variable in Applications to better naming convention in QWAdmin 5.0.0.775 May 21, 2013 Display message and exit if invalid file name on command line Disable file open if valid file name passed via command line Display message and exit if wildcard character in directory file name on command line returns zero files Enable file open if directory file count greater than zero on command line Maintain open dialog state between file open invocations Do not allow, show or open file name from command line if leading “$” character is found Do not show file names with leading “$” character in existing files tab Remove file names with leading “$” character from recent files list Remove file names with leading “$” character from directory file Added support for displaying multiple directory files in a tab interface when directory file contains wildcard character (*, ?) Only invoke file open if double click on list item Add Audit File (if available) to archive backup during Save and delete original Rename log file if structure change and no archive Hide temporary files that begin with ‘$’ Issue with Edit Server and Save, corrupting settings in QWDataClient.exe Issue with double-clicking in hierarchy mode in QWDataClient.exe Disallow changing checkbox on protected field on Add screen in QWUpdate.ocx Allow quotation marks on commandline in QWMerge Add QWN autonumber file to archive in QWAdmin modules Add QWN autonumber file to archive in QWFilePack Allow for Timeout error with TCP input files in QWComSrv Stop further Input File processing if Cancel pressed in QWUpdate More debug statements during Save in QWUpdate 5.0.0.774 January 17, 2013 Added support for save and restore of window size and position for multiple monitor configurations Replaced old folder tree control with new folder tree control Allow commas in command line filename if surrounded by double-quotes in QWAdd Allow hierarchical or flat views of templates to QWDataClient Added new Cryptography class to QWTool Added an ‘Apply to All’ to QWMerge when changed templates are detected Fixed OBS PPM for variables with A# report type. Formatted display value was correct. Raw value was in error Removing last file on DIR screen would caused a crash in QWAdmin Center Views Manager on screen More robust method of finding System folder in 64-bit Prevent negative decimals in QWAdmin Added ShowOpen and ShowSave Dialog screens for scripting Fix issue with moving Where clause variable in saving views Added new COA macros for Word and Excel 5.0.0.771 April 19, 2012 Changed to address font character set Allow CopyTemplate function to be used with scripting Now using API GetFileSizeEx to determine RecordCount Changes to QWSumStat Trap error if QW template is invalid or wrong version Made QWDataHubAppGen compatible with latest version of QWDataHub Updated Summary and Prioritize screens to perform a sub sort on the variable index Variable sorting on Summary and Prioritize screens synchronized Resolved log file not being saved in QWDebug Resolved bug in DisplayAllControlCharts method Changes to QWAdmin dialog messages 5.0.0.767 October 13, 2011 Corrected ‘Subscript out of range’ on Summary Screen where repository axis field property was set to zero (0) Corrected log sheet cell coloring Clicking Views/Options/Defaults now sets ‘Screen to go to after View is loaded’ dropdown to Logsheet Added further traps for blank and invalid characters in Date and Time on Add and Edit screens Added calculation examples of Cr, Tz, Cpk, %CV and T-Dev to QW5.CHM. 5.0.0.765 May 24, 2011 QWAdmin now replaces QWSetup due to Windows Vista & Windows 7 UAC (User Account Control) QWFileSyncAdmin now replaces QWFileSyncSetup due to Windows Vista & Windows 7 UAC (User Account Control) QWRS232Admin now replaces QWQWRS232Setup due to Windows Vista & Windows 7 UAC (User Account Control) Changed references from QWSetup to QWAdmin in QWXLtoQW QWCheckForUpdates now displays version numbers even if up to date QWComSrv now has Write support for HUB:, TCP:, and FIX: tags Added full product version number to main window title Added more error handling in QWDataClient Fixed issue in data interpolation for relationship chart Corrected typo on the Application Properties File Usage tab where the current application was being reported as not in use Report footers were not being displayed in MHT and PDF formats Variable Info now allows http names for Help Filenames Resolved crash if Popup did not exist when using a UNC specified path (Example: \\MyDataDrive\c\Team) Corrected error if Add pressed and QWT had changed by another process Added Append to Existing QWT to QWXLtoQW Added QWDataHubAppGen Added error trap for “Out of Memory” including message box notification on error. Current application will be set to read only. 5.0.0.761 December 17, 2010 New Applications Properties tabbed dialog for General information, File System information, and File Usage information Removed warning message when closing Quality Window except when on the Add screen Allow changing license number if invalid server license entered Improved OPC reads Allow support for Intellution iFix Scada (FIX:TagName) Allow Constant text for input file in QWComSrv (ie CON:LINE 1) Allow commas in Filtering Values (ie Comment = ‘One, Two, Three’ Do not convert textual numbers in Filtering Values for Text fields (ie Comment = ‘001’ used to save as ‘1’) Added dBase/Popup processing class to QWTool.DLL Added MultiSelection class in QWTool (for selecting multiple items in a script) Added QWCheck (used for data integrity and, if possible, repair) Updates to installation and documentation for QWDataServer Corrected formatting of date and time when displayed on the X-Axis and Annotation sections of the control chart Allow for null X-Axis and Annotations fields for an application Corrected @POP and @XBAR calculation if calculation contained a single variable followed by a variable range Changed location of Report footer lines to span across cells Changes to QWSetup Changes to QWUtilities Changes to QWSQLWizard Changes to QWSchedule 5.0.0.760 July 5, 2010 Installation now copies existing .QWX and .SYS files to \Busitech\QW50\BackupPrevVersion# prior to copying new files New Help file format with F1 access from each screen Added Display as Web Document (PDF) Added ability to enter dates manually on the calendar on Views Filter screen Added key sequence to enable/disable F9 key on Add screen. Contact Busitech for the key sequence Added copyright notice to the status bar Changes to QWSumStat Corrected show/hide option of Interval chart on Trieto screen Corrected Options | ‘Exclude variables with no data’ = True, and no records returned Corrected Selecting Date or Time in columns 2 or 3 on the trieto screen Corrected display on Name and Company Name in Help | About and display server license number if applicable Corrected issue with grey scale option Corrected statistics for Obs N OSL for variables with Report Types A# in QWSumStat Modified formulas for OBS % OSL, Obs N OSL, and OBS PPM OSL for A# variables Modified function for F-Table to return 0 (zero) if both input parameters are less than 1. Modified function for Calc UCI to test for zero value return from F-Table function (caused a div zero error). Prints n/a if zero. 5.0.0.747 January 15, 2010 Rounding now uses Symmetric Arithmetic Rounding Added new current limits statistics Added export of charts as .JPG Corrected retrieval of stats sys file Corrected right mouse click on Open dialogue screen Corrected CHECKBOX[] functionality Corrected Average Type fields not being cleared after Save Corrected saving report statistics when loading a view Corrected copying MIN and LSL values on ‘Import View’ Position of splitter bar on Open dialogue screen now preserved Changes to QWScript.QWX Added Display_All_Control_Charts Added Display_Current_Limits Changes to QWFilePack Prompt for path and display completion message when called from QWSetup Changes to QWRS232Setup Corrected switching from Absolute to relative mode Help now points to a PDF document Changes to QWSetup Decrease the likelihood of crashes with invalid Dates and Times when modifying itemplates Changes to QWSQLWiz Help button now points to PDF document Changes to QWSumStat Respect comment on $INCLUDE statements Clicking off the grid in the default report would launch the first application Changes to QWTool Added a Sort method to the Collection class Corrected Misc.ExcelLookup for Office 2007 Changed RS232 class to fix problem with hitting Spacebar to Get data 5.0.0.745 August 5, 2009 Corrected Popup creation 5.0.0.744 July 8, 2009 Added masked input on a Text variable via Units field – ie Units = FORMAT[mask] where mask can contain the following: 0 – digit9 – digit or space# – digit or signL – letter ? – letter or spaceA – letter or digita – letter, digit, or space & any character . – localized decimal separator, – localized thousand separator: – localized time separator/ – localized date separator \ – Escape (treat next character as is) Examples: Postal Code: FORMAT[L0L 0L0] IP Address: FORMAT[000\.000\.000\.000] License Number: FORMAT[000-0000000000-000] Phone Number: FORMAT[(000) 000-0000] Changes to: QWSumStat Script will now search for any files like ‘QWSumStat_*.QWX’ and append the code to the main QWX file at run time QWSQLWIZ Remove hard reference to QWTool QWSetup Remove reference to ADO Rewrote Password check for ‘QWSETUP’ userid QWDataClient Corrected Deleting of a server Added a Connect button to explicitly connect to a server (can also be used as a Refresh function) 5.0.0.743 May 21, 2009 Improved Popup handling (no MDAC/DAO required) added Option to Show/Not Show Popup key on Add, Edit & Log Sheet added support for Checkbox on Add/Edit using Unit of Measure Format: CHECKBOX[TrueValue,FalseValue] Examples: CHECKBOX[Yes,No] CHECKBOX[0,1] CHECKBOX[On,Off] CHECKBOX[Blue,Green] 5.0.0.741 April 7, 2009 Return zero instead of null for Count on Pivot and Summarize Removed check on IP address to allow for entry of Domain Name for QWLicense Changed default View on the Begin screen to be Details instead of Icons Name of variable added to message boxes on user help On File / Application Properties screen File Usage information set to Off by default. Changed QWLaunch to QWLaunchTray as some anti-virus programs were reporting false positives because of other software programs with the same filename. Changed QWXLTOQW to allow more than 16000 rows in an Excel Spreadsheet 5.0.0.736 November 26, 2008 Changes to QWRS232Setup, QWRS232, QWPopup & QWSumStat 5.0.0.734 September 19, 2008 Added Update dropdown menu Added Save View as Quality Window XML (.QWXML) Changed calculated fields to do calculations to 20 decimal places internally Resolve XRefs at the View level instead of the base template level Allow back/forward n records for a time period (i.e. End of Previous Month Back 25 records) Changes to QWSQLWiz & QWSumStat Updates for Auto Refresh, includes: Refresh button on toolbar Refresh Now menu item If external SQL view Refresh rate set to at least 1 minute Demo license timer now shows days remaining 5.0.0.727 January 16, 2008 corrected subscript out of range in QWVarInfo (blank entry at end of QWUnits.SYS) 5.0.0.726 October 18, 2007 corrected F9 (Prev Value) key when in Edit mode added a Selection class to QWTool default to application path for IO files specified in a Filter statement allow update of Output files when blank 5.0.0.724 August 23, 2007 added a choice to archive Application when changes saved in QWSetup – save X-Axis Label option to the registry check for same record length and number of fields when importing a View make Prev Value Button invisible on Add screen, but still allow F9 corrected writing Deletes to transaction log when Security turned on at Template and transaction levels corrected number of decimal places on histogram labels corrected printing log sheet in portrait/landscape mode corrected backspace in field edit mode from deleting entire field instead of only last character corrected deleting the view file when a View was deleted corrected looping problem if security is turned on but no security file found corrected format of “D” records in transaction log file corrected type mismatch under QWSetup Directory Files for non-English versions of Windows corrected type mismatch in QWFilePack if PreProcess or PostProcess defined with mixed paths corrected QWFilePack commandline for all templates in a folder corrected problem with Relationship Report where variables were listed out of order on dropdown. 5.0.0.718 January 8, 2007 Changed environment variable name to QW50PATH for global location of the following files: QWRULES.SYS QWSTATS.SYS QWUNITS.SYS To set a QW50PATH Environment Variable: right mouse click My Computer select Properties click the Advanced tab click Environment Variables under System Variable click Add enter QW50PATH in the Variable name field enter the full network path where your QWRULES.SYS, QWSTATS.SYS and QWUNITS.SYS files are located If the files are not found in the folder specified by the QW50PATH environment variable a message will be displayed. 5.0.0.716 December 12, 2006 resolved deletion of Popup fields and popup data Import from Excel in QWSetup 5.0.0.713 November 16, 2006 added QWSumStat to calculate and display summary statistics across multiple templates added support for MHT (portable HTML) output on open reconcile .QWI and .QWA files to maintain QW compatibility added a space between Application Title and View Name in QW.HTM corrected pressing two keys at once added QWSQL Wizard for connection to SQL driven databases corrected loop if no chartable variables found added environment variable support for QWRULES.SYS and QWSTATS.SYS files using the QWPATH environment variable corrected loop if downtime timer script cancelled during an Add corrected problem with Brazil Portuguese locale and I/O files Summarized Views now inherit limits when Average chosen to summarize by Options / Statistics disabled if QWSTATS.SYS is Read Only show current application file name if read-only & limit method on Status Bar corrected loading the wrong filename when referencing existing files after switching directories added variable formatting using the Unit of Measure field for variables containing date & time, other than V1&V2.The Units of Measure table in QWSetup should contain the following entries in order to make use of this feature:Copy and paste the following 13 lines into the top of QWUNITS.SYS in your Systems folder using NotePad. *** Do Not Change ***,[*** Date Formats Follow ***] 2006-06-31,Date[yyyy-mm-dd] 2006-Jan-31,Date[yyyy-mmm-dd] 2006-January-31,Date[yyyy-mmmm-dd] 01-31-2006,Date[mm-dd-yyyy] Jan-31-2006,Date[mmm-dd-yyyy] January-31-2006,Date[mmmm-dd-yyyy] 31-01-2006,Date[dd-mm-yyyy] 31-Jan-2006,Date[dd-mmm-yyyy] 31-January-2006,Date[dd-mmmm-yyyy] *** Do Not Change ***,[*** Time Formats Follow ***] 15:34:26,Time[hh:mm:ss] 5:34:26am,Time[hh:mm:ssa] the following calculated functions now support the use of variables containing date & time formatting:@TIMEDIFF[V3,V4,V1,V2] = second between V3-V4 & V1-V2@DOW[V3] = the day of the week number (1 to 7) from V3@DAY[V3] = the day of the month from V3@MONTH[V3] = the month (1 to 12) from V3@YEAR[V3] = the year from V3@JULIAN[V3] = the Julian date for V3 5.0.0.687 March 13, 2006 Corrected commandline opening of a template View 5.0.0.684 February 10, 2006 corrected File / Save View As corrected Save Image As corrected display of Hat Chart on Prioritize screen if RULE statistic turned off added new Statistics to Help file show Summary screen after and Add or update if RULE statistic turned off corrected navigation by arrow up/down/left/right, page up/down, End and Home keys corrected Median calculation re-aligned default statistics 5.0.0.672 January 9, 2006 Corrected position in popup if entry no longer exists 5.0.0.670 December 5, 2005 Corrected recalculation after Edit Corrected landscape print from icon 5.0.0.668 November 7, 2005 Added Upper Confidence Interval Observed PPM (UCIoPPM) statistic Added Upper Confidence Interval Calculated PPM (UCIcPPM) statistic Added QWFilePack to collect & ZIP template & associated files Increased speed at which popups are processed Added Home Directory icon to open dialogue: If Home Directory is set, open dialogue will display the Existing Files tab pointing to the Home Directory If no Home Directory is set, open dialogue will display the Recent Files tab If there are no recent files, open dialogue will display the existing files tab pointing to the working folder Right-click on any item now shows a Clear Home Directory menu. If no Home Directory is set, this menu is disabled The Home icon on the Existing Tab toolbar, when clicked, will jump to the Home Directory folder The Home icon now shows a tooltip indicating the Home Directory path Statistics Selection interface improved: now shows Available and Selected columns both columns supports selecting multiple items (click and drag, shift key, control key) Available column list sorted alphabetically Selected column listed in user defined order Allow F10 Save when on right side of Edit screen Don’t allow Open, Views, Filter, etc… when in Add/Edit mode Allow Output files to be saved if filename greater than 128 characters Added option in Views to Exclude variables with no data Allow Date & Time to be entered in Filter criteria Added Relationship Report Added Default View setting in Views 5.0.0.645 July 14, 2005 Compare chart can now show different variables at the same time Corrected reference to grid module 5.0.0.628 May 3, 2005 added Interval chart to Trieto screen enhanced memory management now using binary search for faster data retrieval control Chart cursor bar removed during print. Reset after print. added filtering on Trieto screen F9/backspace not allowed on Protected variables disabled Save during Save (to prevent double clicks) added Display as Web Document from File Menu added QWReport output to SCREEN commandline option added Clear Filter button added Classic & Color to Options for Log Sheet added Date & Time formats to Options menu improved printing added .DIR commandline support (QWSetup creates .DIR) added QWVersion for customer support enhanced install for PocketQW added new Zoom icon for all tibbed charts (Options/Zoom) added server based licensing support enhanced QWLaunch for shortcuts from QW added font options for Add & Edit screens (Options/Fonts) added X-axis Labels for Control Chart (Options/Control Chart) added Save Image as (.BMP or .JPG) to File menu disabled Open button and File/Open if application opened via commandline added @FRACTION added properties of template in use in QWSetup added properties of template in use in Quality Window.View how to configure DCOM for this option. added the following statistics Observed > USL % Observed > USL ppm Observed > USL n Observed > UCL % Observed > UCL ppm Observed > UCL n Observed > UWL % Observed > UWL ppm Observed > UWL n Observed < TGT % Observed < TGT ppm Observed < TGT n Observed > TGT % Observed > TGT ppm Observed > TGT n Observed < LWL % Observed < LWL ppm Observed < LWL n Observed < LCL % Observed < LCL ppm Observed < LCL n Observed < LSL % Observed < LSL ppm Observed < LSL n Calculated > USL % Calculated > USL ppm Calculated > USL n Calculated > UCL % Calculated > UCL ppm Calculated > UCL n Calculated > UWL % Calculated > UWL ppm Calculated > UWL n Calculated < TGT % Calculated < TGT ppm Calculated < TGT n Calculated > TGT % Calculated > TGT ppm Calculated > TGT n Calculated < LWL % Calculated < LWL ppm Calculated < LWL n Calculated < LCL % Calculated < LCL ppm Calculated < LCL n Calculated < LSL % Calculated < LSL ppm Calculated < LSL n 5.0.0.531 October 25, 2004 Made changes to: QWSchedule QWAdd QWTrigger Corrected data formatting on control chart axis for Summary & Prioritize 5.0.0.530 September 10, 2004 Files opened via command line are no longer added to the recent files list Fixed Rule violation if insufficient data for all Rules 5.0.0.527 July 29, 2004 Fixed drawing of icons on Summary screen Fixed chart banding for Target based on Target Method Fixed the Required flag for AVG type variables 5.0.0.511 April 30, 2004 Fixed sort by Records and Size on Open Application dialogue Histogram average line corrected Added QWSchedule QWAdd QWTrigger QWLogView QWUtilities (Export & ReOrg) 5.0.0.510 April 15, 2004 Fixed double click on log sheet for Edit Fixed international decimal (, vs .) place holder in Views Fixed international issue when writing QWStats.SYS file 5.0.0.508 March 30, 2004 Fixed row height problem on log sheet 5.0.0.505 March 3, 2004 Added Calculated Target to Log Sheet Fixed error when loading an application with no variables 5.0.0.501 February 26, 2004 Added Target Value to Log Sheet Fixed Range Chart Options menu Fixed Prioritize statistic triggers for Hat Chart Fixed Font property on all charts 5.0.0.500 January 26, 2004 New open dialogue @RULE calculation corrected @MPREV calculation corrected Transaction log viewer added 5.0.0.448 April 25, 2003 Corrected %CV when SD is null Corrected Delete Record cancellation Corrected long Text field processing Corrected Popup field processing if Input file used 5.0.0.447 April 18, 2003 Corrected use of international decimal symbol Now allow adding data if only Filtering applied in Views Corrected Invalid Procedure Call on Report tab 5.0.0.446 April 11, 2003 Corrected Text variable formatting 5.0.0.440 April 4, 2003 Corrected minimize error on Begin screen Synchronized components 5.0.0.435 March 27, 2003 Improved precision Activation of tooltips on log sheet Corrected division by zero in Views Now handles Text fields over 500 characters 5.0.0.431 March 24, 2003 Implemented security for Views Manager 5.0.0.421 February 28, 2003 Added Trieto functionality for Event Analysis Added Refresh button to Toolbar 5.0.0.413 February 12, 2003 Commandline file association enhanced 5.0.0.412 February 7, 2003 Improved Views naming (ButtonMenu) 5.0.0.411 November 7, 2002 Fixed minor problem in Auto Refresh Auto Refresh fires on current screen. Does not change current screen. Added CTRL N to Options/Refresh/Never menu. Variables with all Blank limits not added to chart items Fixed DBCS support for Security Added test for Scripting installed Added HTML control with print capability Added Misc funciton to handle Get T&F under Scripting Fixed command line parameters with long filenames Display actual parameters used in Filter Summary report Added Clipboard class Now using uppercase string compares for Sort Distincts 5.0.0.408 October 15, 2002 Remove Refresh button from toolbar. Improved functionality with Auto Refresh Added display functions to Summary and Prioritize from Options menu. Moved prioritize tab after Compare and before Report. 5.0.0.386 October 3, 2002 Added Summary Screen Removed extension from incoming filename Added Macro Menu 55.0.0.382 September 30, 2002 Added Copy Log Sheet function from the Edit menu. Read/Write of Font Options 5.0.0.368 September 10, 2002 Implemented the Create Desktop Shortcut function from the File menu. 5.0.0.344 August 26, 2002 Added Save Report As… menu item under the File menu. Added auto refresh functionality. 5.0.0.334 August 20, 2002 Added new menu entries under Options. Prioritize Rule Violations Hat Chart (CrTz) Automatic setting of Rule Violations on Prioritize screen 5.0.0.333 August 8, 2002 Fixed highlighting on histogram bar on mouseover. QW Setup The following information details changes to the QW Setup program. Build No. Details of Changes to QW Setup 5.0.0.116 May 9, 2007 changes to Applications & Global programs 5.0.0.104 November 7, 2006 resolved deletion of Popup fields and popup data Import from Excel in QWSetup 5.0.0.101 November 7, 2006 Application Grid View was not supporting Report Type of A30 Added support for modifying templates containing QW SQL parameters 5.0.0.086 March 27, 2006 Changed Grid View paste to selectively convert to UPPER case in specific columns instead of all 5.0.0.085 March 23, 2006 corrected QWI/QWA update 5.0.0.084 March 6, 2006 Added DIO prefix support for Input/Output File 5.0.0.083 February 1, 2006 corrected popup Export for older versions of Excel® 5.0.0.081 January 9, 2006 Security data editor enhanced 5.0.0.079 December 5, 2005 corrected maintaining focus in popup data editor when scrolled to the right allow deletion of a calculated variable when calculated using itself Rules update corrected if moved off record before saving corrected Popup data import of numeric data with many decimal places corrected Number of Value to Average for Average type variables corrected Popup data export for single level popups corrected variable name change corrected file lock if there was no data in a new template corrected record out of sequence repair corrected Average type variable if Number of Values to Average not entered corrected Applications / Save As if no structure changes made allow adding multiple template to .DIR file 5.0.0.072 July 8, 2005 Added Popup data export/import capability 5.0.0.064 May 3, 2005 added Application Properties information showing where template is in use changed temp file name to be $templatefilename$ corrected file access rights error use of : in Input/Output Filenames added output DDE and OPC clipboard support and validation corrected paste from Excel® added @Fraction calculation added .DIR option 5.0.0.052 August 12, 2004 Resolved data lock warning when empty template data first opened in QW 5.0.0.048 April 30, 2004 Added “Template in Use” message if template open in another program Put Cancel & OK buttons back on ‘Apply to Multiple’ form 5.0.0.047 April 20, 2004 Added cross-folder Popup selection Fixed Save application when no changes were made Fixed international decimal (, vs .) place holder 5.0.0.045 February 27, 2004 Fixed Copy Selected variable calculation Changed Control Chart Axis settings Text Fixed tab order and focus on Rules Changed clone variable function to work with new open dialogue 5.0.0.39 April 7, 2003 Popup selection list now sorted Allow Required & Sampling Plan change in Views 5.0.0.37 March 11, 2003 QWA file resolved for QW compatibility Security Level Input enhanced Implemented security for Views Manager 5.0.0.35 February 25, 2003 Temporary files now being renamed 5.0.0.34 February 3, 2003 Resizing algorithm enhanced Application grid enhanced To reflect changes to QWAccess & QWSelect 5.0.0.33 January 31, 2003 New resizing algorithm Security Login enhanced Registry path corrected Corrected historical dates for Views Corrected refresh midnight rollover 5.0.0.33 December 5, 2002 New resizing algorithm Security Login enhanced Registry path corrected 5.0.0.32 November 4, 2002 QWSetup DBCS Character Set Read/Write corrected QWSetup / Applications Interval Setting Display corrected QWSetup / Popups Levels change corrected 5.0.0.28 September 3, 2002 Window state changed 5.0.0.24 July 23, 2002 Help enabled Average, Length & Calculation validation enabled 5.0.0.22 July 22, 2002 Calendar read issue resolved 5.0.0.21 July 18, 2002 Date Picker now available for Security Expiry date Pacifier centered 5.0.0.20 July 16, 2002 Updated Multiple Variable Change Forms Script Menu Issue Fixed Grid Validation Problem Fixed Replace Feature added on grid Windows Cut/Copy/Paste enabled 5.0.0.19 July 9, 2002 Default script now available Delete message now prompts before item deletion 5.0.0.18 June 19, 2002 Close click now saves Application Settings Limit value resolved an both Variable and Grid Mode Formating Limits can both be blank now Limit validation has been updated to be more robust All Limtis now conform to international language Settings Modify QWD now incorporates new value specifications Variable Used for AutoNumber added Added Delete Applications and Popups Added Rename Applications and Popups Calculation editor updated Grid now supports Multiple variable changes on variable details menu Download the latest version of QW5