============================================= T C M R E A D M E . T E X T ============================================= VERSION 2.11, BLD 2 - BUG FIX LIST ---------------------------------- - Sigh, Paul Vine found an old bug that I finally forced a fix too. Turns out that if you upgrade from SR7 or before, the bug with the REF_Reports table getting overwritten will occur. To prevent this, I renamed REF_Reports to REF_ReportList so that the old table will be deleted the second time user opens a new version database. Anyway, the Reports Wizard should no longer popup empty. - Modified Report Wizard to have Close instead of Cancel button, and Run Report instead of Finish button. - Moved Help file and all supporting images to subdirectory to reduce clutter. You should uninstall and then reinstall this build to get rid of the help file remnants still in the app directory. - Fixed Usage Report so truly picks the most recent date that user logged into the system. Turns out that use of the LAST() command in SQL does not necessarily guarantee the most recent login record in cases where stored out of order, etc. VERSION 2.11, BLD 1 - BUG FIX LIST ---------------------------------- - MAJOR bug fix for multi-user systems. It turns out that version 2.10 was broken due to a change I made where all forms were set to a record locking type of "Edited Record". This is not the default and ends up causing problems when there are 3 or more concurrent users. I reverted to "No locks" to get the better concurrent usage performance the TCM used to have. - Fixed bug where print test case button at Test Case Detail form printed nothing due to wrong report name hard-coded. - Web page links not work for Windows NT. - Bug fixed where user's test case pass or fail results were silently not stored if there was no build number yet assigned in the app. Thanks for bug find by Tim Rametta of techhealth.com. - Made button on Dictionary File builder to display English representation of text. Suggestion by Anders Eriksson of Sweden. - Give visual cue that test cases on the Test Case Detail form were inactive. Grayed out the description field only if the test case is inactive. Suggestion by Gaye Edwards of msc.ie. - Included sample project on website http://www.pb-sys.com. Suggestion by Anders Eriksson of Sweden. VERSION 2.10, BLD 2 - BUG FIX LIST ---------------------------------- - Bug where forms APP_PickDatabase and APP_ChangeDataPoint used the PropertiesLookup() function; but that function tries to call the TCM_Data.mdb file (REF_Properties table) which is not hooked up at the time, hence the call to those forms prompting user to re-establish the connection. Now, use DLookup() function to table REF_PropertiesLocal that exists for sure. Also wound up correcting in several other forms too, such as BusyBox, etc. - Error handler was incorrectly checking to see if table existed before completing the error logging. This was fine and dandy back when I used to use the table, but now log directly to a file, so no need to check for table. This is great because long standing bug occurred when could not access database, and tried to log that bug to that database...ironic huh? VERSION 2.10, BLD 1 - NEW FEATURES + BUG FIX LIST ------------------------------------------------- - The Test Case Explorer now has two tabs for Test Case Views. One you are already familiar with which is the Spec Areas Tree. The other tab is the new Filters tab. You can click a button to view all test case records at once in the right pane, you can filter by Level, Person Assigned, Execution Status, or even make your own Filters to constrain records (test cases) by. The filters are the same ones you use when viewing reports. - Made Add, Edit, Copy, and Move test cases much faster (thanks for detailed bug report Keven K.). - Now supports multiple languages. Every text box, label, command button, check box, and other control on forms and reports can have its text, font and font size assigned. All message box text is also definable. You can run the WIZ_Dictionary wizard to build your own dictionary (.dic language) file. Then, you pick a language (.dic file) in which you want to view the application. Note that for some countries you will need to have your regional settings setup so that date, time, and other items are managed by Access (this should be by default for you though). NOTE: I really want users to create dictionary files, then email them back to me (pb_sys@yahoo.com) so that I can add them to the setup for future releases and make it easier for all users (theoretically, it should only take one user per language to create and email to me for sharing with all others). - Added button to allow users to email me their dictionary files easily (just have to add .dic attachment). Did not want to add MAPI control to further automate...try to minimize controls. - Adding New Test Cases was confusing in previous builds because I consolidated the test tree and the test case buttons (add, edit, delete, copy, move) all into the same buttons. Now, there are different buttons with different icons, just in the same location to save screen real estate. If you set focus into the test case window, then those buttons are active. If you click on a tree item, then the test spec buttons are active. - Also, to further eliminate confusion, both Add buttons are always visible (test spec areas and test cases). - Date constraints at filters sucked. You were forced to pick specific or literal dates that you then had to change every time you ran a report week after week. The new date constraints start off at the top of the drop down with Now(), Now() - 7 days, and so on to give you the ability to build filters that will not change because the date parameter is built in (no longer have to use a literal, unless you want too). - Added back in record selectors on attachment window so that users can delete an attachment record if they desire. Note that you still must manually delete the attachment file yourself. Thanks for finding and reporting Lynn. - Fixed bug where attachments were not properly saving if you added one before first committing changes to new test case record. TC_ID thus had not been generated, so Access could not link child to parent with non-existent auto-number key. - If you login as someone not yet added to table REF_Person, bug used to throw you out of app, now returns you more gracefully to login form again. - One user wanted command line to force the pick database flag to popup everytime run TCM. Could just click the open database button, but decided to also give her command line option /PROMPT to open TCM via shortcut and go to dialog. Usage (it is a long one): "C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" "C:\Program Files\TCM\TCM_Loader.mdb" "/cmd /PROMPT" - Fixed New Project Cancel bug (used to crash if user hit Cancel when asked for first run of app). - A user requested ability to easily copy test case data to different bug tracking systems. Fix was a new button (Copy Test Case to Notepad) that does as its name suggests. Only resides in the Test Case Details window, and not the Explorer window. - Test Case Explorer and Test Case Detail now based off of same query, with same filter property set depending on user selections in two tabs. Note that this filter property is prominently displayed in the Explorer window at top under Test Case window subtitle. - A user requested a delete button on the Test Case Details form (as opposed to Explorer form where it now exists). - Fixed endless error loop when not connected to a database. It was some modal or popup property setting or something like that (shoot, shoulda written it down). - Renamed two existing Test Case reports to "Test Case List, Summary by Area" and "Test Case List, Detailed by All Areas" at request of a user. - Added new report named: "Test Case List, Detailed by Areas In Use" which is same as "...by All Areas", except that if no test cases in an area, then that area does not show up on the report. This is useful when filtering a report to avoide several extra pages printed with empty test areas (no test cases). - Error handler now writes to text file and no longer to table. This precludes error when database is inaccessible and endlessly loops. - The filters sucked. The UI was re-built to get rid of some of the uglier problems (moving through records, etc.). - The wizard dialogs were setup as separate pages within the same form (Access does not support all controls embedded within frames as does VB, so opted for pages). The weakness here is that users who press the tab key to move to the next step will get an ugly UI bug...the screen is caught half on one step, and half on the next step. Fix was to set form property to CurrentPage for the Cycle property of all forms. - The Test Spec Window no longer lets you expand and collapse tree branches. Instead, the tree branches are always fully expanded. The self-join query used to permit the tree-like expand and collapse became too slow when exceeding 600+ records. - The intermittent error 2105 cannot go to specified record error when moving in tree is now fixed. - Read a nifty article in one of the Access magazines and learned I have been do closing down objects incorrectly, yielding memory losses. Turns out you are never supposed to go IF IS NOTHING THEN SET = NOTHING because you instantiate another object and close the latest one down that you accidentally just opened... leaving the original object still in memory. NASTY! Bug is now fixed in all routines. - When add new dictionary, calling form is closed and re-opened to refresh with new language. VER 2.04, BLD 1 - BUG FIX LIST ------------------------------ - Added new report "Project Summary By Creation Time Sheet" to summarize tester test case creation time. Renamed the previous "Project Summary By Time" into "Project Summary By Execution Time Sheet". - Put REF_Reports table in TCM_App.mdb. Added code to TCM_UpgradPatch.mdb to remove the REF_Reports table from the TCM_Data.mdb file (all of them that as they are upgraded). - Modified sort order on Test Case Summary Report so ordered first by TC_Area, then by TC_ID. - Modified Test Case Detail Report to show Test Case Area as grouping, then sort test cases by TC_ID under every grouping listed (looks more like summary report now). - Fixed bug where first time users install TCM, then run it, then click Open Existing project, then click Cancel...only to have app blow up...now it will just gracefully quit. - Test Case Detail form now has radio buttons instead of toggle buttons for Pass and Fail flags. - Test Case Detail form Pass and Fail flags now work. Before, were always reporting untested, even though the database field (TC_ExecStatus) was false or true for failed or passed. - Used to error out when print or email reports (print preview always worked fine). Now, no more error after report printed. - Wizards now all have min/max buttons removed. - Report Wizard now stays open after every report is run, until user clicks Cancel button. Also, can now maximize print preview window without also maximizing the Report Wizard and the Test Case Explorer window. VER 2.03, BLD 1 - BUG FIX LIST ------------------------------ - Fixed bug where attachments saved in path with spaces in it would blow up on Windows NT. Put quotes around attachment filename when shelling out to it. (Thanks to Lynn Hogarth for reporting this.) - Fixed bug where clicking Print Test Case from Test Case Detail window was erroring out. (Thanks to Lynn Hogarth for reporting this.) - Added confirmation prompt to Test Case Detail when user presses escape. This prevents users from accidentally deleting all data if they press the escape key after entering a bunch of text into the details window. - Switched email back to pb_sys@yahoo.com because faster than redirecting through web host service. VER 2.02, BLD 1 - NEW FEATURES / BUG FIX LIST --------------------------------------------- - Major new feature is that the TCM Explorer and TCM Details windows are now resizable. Just drag the border to re-size to suit your needs. Got rid of the silly Screen Resolution button. - Removed the old Switchboard form. Now all oper- ations occur from the TCM Test Case Explorer form and a new menu with some additional toolbar buttons. - Fixed small bug where non-admin users could still click the Edit Reference table buttons from the Test Case Details form. Now, must be an admin user to change the reference tables. Same applies for the menu bar items. However, still have not put code in the form unload, project startup parameters, etc. to lock users out...users can still get at the tables and source code easily (by design though--could lock down with MDE, etc.). - Excellent suggestion from M Francen: added filter name selected to all reports in addition to the WHERE clause on all reports. Makes criteria selection even more apparent. - Default logon and password is now Admin (I used to be lazy and just left my matpie login in place...now I will try to remember to change that every build). - Added standard filters to the Filter drop down list for: Test Cases Passed, Test Cases Failed, and Test Cases Un-Executed. Thanks M. Francen for the suggestion. - Switched all references to http://www.angelfire.com/wa/pbsystems/ over to http://www.pb-sys.com. Also moved website to http://www.xoom.com because eliminates pop-up ads and confusing page requiring repeat link click to download (does not even work for some Netscape users). - Switched all references to matpie@email.com to tcm@pb-sys.com. - Copyright 1999, and 2000 (woo-hoo, snicker, snicker). - Revised the Help file (it was getting out-dated). But, still left some old screen shots...oh well, get them next time when not so flippin' busy (heh heh). - MDI subform for Test Case Explorer now has a caption which indicates the path to the database project file to which it is pointing. - Heh, heh: added comment to Help->About form something to the effect of "even though this is freeware, if you really like it send $ here...". - Fixed bug where TCM was 'crashing' when first load up...was due to me flipping a PopUp property so that the form covered the form below which user needed to respond to (Open Project / New Project / Cancel). - Changed all forms to thin border instead of dialog (looks better). Exception is the two re-sizable main forms. - Added New Project, and Open Project buttons to toolbar. Really quick and easy to administer project databases now (if you are an admin user...else disabled). - Fixed page footer on Usage Report. Now has standard footer text. - Bug on Windows NT4 machines where TCM_Loader.mdb would not properly load the TCM_App.mdb file. Turned out needed to wrap the path in quotes before shelling out and executing it. Same bug in Buggit app too. Special thanks to Mike Whittaker for finding this bug and sending me the fix. - Added combo box lookup at Project Database selection. New table "tbl_ProjectDatabasePath" remembers every *new* BUG_Data.mdb database that you pick. This makes it much easier to click and change project databases rather than using the [...] button to go search all over your network for different projects (by the way, I recommend getting a file server and placing all of your multiple bug databases in a central BUGGIT folder with project data folders off of that...also make the file server into a Tool Server with testing scripts, docs, freeware/shareware, etc. loaded there for easy access). VER 2.01, BLD 1 - BUG FIX LIST ------------------------------ - Bug on Windows NT4 machines where BUG_Loader.mdb would not properly load the BUG_App.mdb file. Turned out needed to wrap the path in quotes before shelling out and executing it. Same bug in Buggit app too. Special thanks to Mike Whittaker for finding this bug and sending me the fix. VER 2.00, BLD 29 - BUG FIX LIST ------------------------------- - Removed Access splash window at load-up of loader form and main app form. - Removed Access menus from all forms. - Fixed bug at Explorer window where user selects test case(s), logs results (pass/fail/clear/archive), then clicks button again. The second set of test cases logged would be shifted up one line. Fixed now. VER 2.00, BLD 28 - BUG FIX LIST ------------------------------- - Oops, at Explorer window, when user adds just one sub branch to a parent branch, then collapses the branch, the [+] would not appear (even though you could double- click to expand). There was an error in the query (> 1, but should've been >=1). VER 2.00, BLD 27 - BUG FIX LIST ------------------------------- - Added feature to upgrade database version from old to new. For this build, it did no database structure changes, just altered the version number in REF_Properties. - Fixed calculation for Area on both Project Summary Reports. Was not properly calculating. - Added this readme.txt to setup file. Added the upgrade.mdb to setup file.