SCT_DB Omnis Application Updates SCT_DB v 4.07 15/11/99 ----------------------- Just a bug fix. Bugs Fixed ---------- The default institute name and username were computed incorrectly for institutes after Protvino on the list. Fixed the User Login window institute name field. Fixed the Shipments window sender's initials field. SCT_DB v 4.06 8/11/99 ---------------------- New dialog to open datafile when connecting to local cache. Lock the record being edited on local cache using 'SELECT ... FOR UPDATE' and 'UPDATE WHERE CURRENT OF...'. This would also work on Oracle7. Check for unique MFR + MFR_SER_NO when inserting SiDetector records + when merging. Bugs Fixed ---------- * Wship 'Send' button was not enabled sometimes. User filled in Confirmation date by hand. Disabled Confirmation date field except for Find * Integrity constraint error when merging SHIP_ITEMS records to master server during Confirm Send. There were two unconfirmed shipments. Now only SHIP_ITEMS for the current shipment are merged. * Cancelling an Edit changed the list of found records to just the one being edited. Now the list is preserved. * The Institute code list on the Persons window was occasionally not in step with the Institute name. Problems Remaining ------------------ * Need a table to hold current values of last serial number, comment number, test number etc. for multi users. * For v 5.x: Add SUBSYST to THIS_LOCN. Add TSTABCD, TSTABCDCHS, DISASSMLOGS tables and windows. Add SUBSYST to all class 1+2 tables except special tests. * No WEB_LINKS window for tests. * Links to EDMS from ITEM_DESCR, TEST_DESCR. * No report defined for Stocks. * Should define assemblies for module0. * Some PCs don't display ARIAL 8, 9, 10 fonts, only ARIAL >= 12. (Try setting Small Fonts on PC's Display Properties window.) Wassemblies/insertdetail crashes when ctype is truncated by field too small for 12 pt. font. * Selecting serial numbers with scratch pads = nn but mfr empty should return detectors with mod(ser_no,1000000)=nn. * Can't get tabs to display correctly in window fields on PCs. Neither can Omnis tech support. It is ok on Macs. * Need better multi-user access to Local Cache within an institute. Shortcuts to .df1 doesn't work any more on PCs. Trying to logon to .df1 on PC from Mac via 'Dave' causes Omnis to crash. Should keep last serial numbers, last test no., etc in a table so all multi-users see the same values. Locking the record in the 'sequence' table could be used to prevent other users Inserting or Deleting at the same time. * Need reports for special tests. * New passwords for next release. Site-dependent passwords for data entry? * Sort out definition of DISASSMLOGS before creating tables etc. What about LAST_MOD, OWNER? * No TSTABCD, TSTABCDCHS, DISASSMLOGS tables yet. SCT_DB v 4.05 25/10/99 ---------------------- Navigation menu now works for special test windows. Report available from Items and Detectors windows of serial numbers and item types for labview check. Add current database server information to window status bars. Bugs Fixed ---------- Sometimes the Items and Tests windows used the wrong default Institute name when inserting new records. Navigating from the Items window to Tests reset the Items copy of the Location list so that Editing the current Item failed. Navigating from Items to Tests now sets the item serial number as the default for an Insert in the Tests window. The Defects window was forgetting its 'last defect name' between Inserts. Also, 'Last Channel' was allowed to be less than '1st Channel'. Problems Remaining ------------------ * No report defined for Stocks. * Should define assemblies for module0. * Some PCs don't display ARIAL 8, 9, 10 fonts, only ARIAL >= 12. (Try setting Small Fonts on PC's Display Properties window.) Wassemblies/insertdetail crashes when ctype is truncated by field too small for 12 pt. font. * Wship 'Send' button not enabled sometimes. * Selecting serial numbers with scratch pads = nn but mfr empty should return detectors with mod(ser_no,1000000)=nn. * Can't get tabs to display correctly in window fields on PCs. Neither can Omnis tech support. It is ok on Macs. * Need better multi-user access to Local Cache within an institute. Shortcuts to .df1 doesn't work any more on PCs. * Need reports for special tests. * New passwords for next release. Site-dependent passwords for data entry? * Need to create Omnis TSTABCD + TSTABCDCHS tables, etc. * Sort out definition of DISASSMLOGS before creating tables etc. What about LAST_MOD, OWNER? * No TSTABCD, TSTABCDCHS, DISASSMLOGS tables yet. SCT_DB v 4.04 ---------------------- A new status bar at the bottom of data entry windows shows the number of records found and current record number. The status bar also shows the current window mode, ('normal', 'find', 'edit' or 'insert'). All main windows now have a menu bar at the top with two menus: 1. 'Reports', which replaces the 'Print Results' button. Special purpose reports will be selected here in future. 2. 'Navigate', which allows one to find related records in other windows, as well as repeat the last Find operation. Moved info about windows' table name, 'order by', report name to window class variables instead of instance variables. Use window class variable intitial values to compile a list of window names, titles, table names, and also a list of test names, windows, and tables. This will be easier to maintain than having to add to the list definition each time a new window is created. Bugs Fixed ---------- * The Detector Items window gave a large number of duplicate records when a 'Find' specified an item type. * Item description list didn't work in Wdetectors. * On Tests window, leaving SER_NO field reset TEST_NAME from last test name to NULL. Problems Remaining ------------------ * No report defined for Stocks. * Report needed for just serial numbers and ctypes for labview check. * Should define assemblies for module0. * Some PCs don't display ARIAL 8, 9, 10 fonts, only ARIAL >= 12. (Try setting Small Fonts on PC's Display Properties window.) Wassemblies/insertdetail crashes when ctype is truncated by field too small for 12 pt. font. * Wship 'Send' button not enabled sometimes. * Selecting serial numbers with scratch pads = nn but mfr empty should return detectors with mod(ser_no,1000000)=nn. * Can't get tabs to display correctly in window fields on PCs. Neither can Omnis tech support. It is ok on Macs. * Need better multi-user access to Local Cache within an institute. Shortcuts to .df1 doesn't work any more on PCs. * Need reports for special tests. * New passwords for next release. Site-dependent passwords for data entry? * Need to create Omnis TSTABCD + TSTABCDCHS tables, etc. * Sort out definition of DISASSMLOGS before creating tables etc. What about LAST_MOD, OWNER? * No TSTABCD, TSTABCDCHS, DISASSMLOGS tables yet. SCT_DB v 4.03 ---------------------- Add Help text to all Tables and Sessions menus and submenus. Add tooltips to all enabled window fields and buttons. Shipments work now. Download component ITEMS of assembly items when 'receiving' a shipment as well as the shipped ITEMS and ASSM_ITEMS records. Bugs Fixed ---------- * Trying to open a window from the Tables menu resulted in an error if the window was already open. Now it just brings the window to the front. * Added Mfr field to Wassembly. Fixed $ConfigButtons problem with Delete. * Move ivLastSerNo to two global variables: for detectors and generic items. Only call $GetLastSerNo in Witems + Wassemblies in $construct and $PostDelete. Now Delete is enabled correctly in Wassembly when items are inserted/deleted in Witems. * Wassemblies/ValidateInsert now checks serial number is in range. * C_Assemble/DisAssemble now resets OWNER, LOCN_NAME of component items as well as ASSEMBLED and LAST_MOD. (Test it!) Problems Remaining ------------------ * Can't get tabs to display correctly in window fields on PCs. Neither can Omnis tech support. It is ok on Macs. * Need better multi-user access to Local Cache within an institute. Shortcuts to .df1 doesn't work any more on PCs. * Need reports for special tests. * New passwords for next release. Site-dependent passwords for data entry? * Need a menu(?) to navigate from Witems to Wassemblies, Wtests, Wship for any item. * Need to create Omnis TSTABCD + TSTABCDCHS tables, etc. * Sort out definition of DISASSMLOGS before creating tables etc. Do we need ASSM_DATE? Should OLD_ASSM_SER_NO be part of p. key? What about LAST_MOD, OWNER? * No TSTABCD, TSTABCDCHS, DISASSMLOGS tables yet. SCT_DB v 4.02 22/6/99 ---------------------- Create Styles for windows and reports so that their appearance is uniform on different machines. Bugs Fixed ---------- * Clicking on a line of the details list (eg Comments on Items window) on main window did not change the detail window. Problems Remaining ------------------ * Can't get tabs to display corrrectly in window fields on PCs. Neither can Omnis tech support. It is ok on Macs. * Need better multi-user access to Local Cache within an institute. * Shipments still not working. * Need reports for special tests. * New passwords for next release. Site-dependent passwords for data entry? * Need a menu(?) to navigate from Witems to Wassemblies, Wtests, Wship for any item. SCT_DB v 4.01 10/6/99 ---------------------- Allow delete from Detector Items window as long as the item is owned by the user, the user's initials are the same as the one who entered it, and the record has not been merged to the master database. Put a 'Parent Assemblies' field on Detector Items window. Bugs Fixed ---------- On the Detector Items window, serial number was being reset during Find and Insert if you hit while the focus was on the Mfr field. Problems Remaining ------------------ * Need better multi-user access to Local Cache within an institute. * Shipments still not working. * Need reports for special tests. * New passwords for next release. Site-dependent passwords for data entry? * Need a menu(?) to navigate from Witems to Wassemblies, Wtests, Wship for any item. * Text on windows varies between different PCs. Sometimes the space for labels + fields is not big enough. SCT_DB v 4.00 27/5/99 ---------------------- Special tests for detectors reorganised: drop TEST_DET_BEHAVE, create TSTDETMFRS, TSTDETIVS, TSTDETOPTS. New windows created for DetIVScan, DetMfrSheet, and all 10 optional tests. Windows for optional detector tests only display part of table TSTDETOPTS. New MFR attribute for TEST_LIMITS. New DOC_ID, DOC_VER, DOC_NAME attributes for ITEM_DESCR, TEST_DESCR. ITEMS.SER_NO increased to 9 digits (2+1+6) for compatibility with ATLAS id scheme. Check local datafile vs library version numbers when starting up. Check master server vs library version numbers when connecting. New routine behind Table Utils menu to create a skeleton datafile using current Schemas. Send this to users, and then just to Merge Master-->Local to populate local cache. Should ITEM_DESCR.NO_COMPS=0 for simple components? (Yes) (with $zeroempty=kFalse). Does any assembly have just 1 component? (Possibly). Update ITEM_DESCR.NO_COMPS to 0 for simple items. Update TEST_DESCR.NO_CHANS to 0 for tests where no DEFECTS will be recorded. New entry in LOCNS for Tsukuba University. ValidateSave and ValidateInsert do checks in 2 stages: (1) Check in table class that all NONULL columns are filled, (2) Check that number + integer window fields with $zeroempty=kTrue have non-zero contents. This means that, e.g., Temperature fields should have $zeroempty=kFalse so that '0' is ok. Also check that a valid choice has been made from a list, where the field is a foreign key. Check foreign key dependencies in ValidateDelete in Wpersons and Witems. No need to do it for class 1 tables, because Delete can only be done on master server, and Oracle checks dependencies for us. Bugs Fixed * New STARTUP.$destruct method logs off from local cache, so that closing old library + opening new one also connects new version of datafile. * Fix errors which occur when closing a window while Inserting or Editing. Tried to do $ClearCols after window was closed.) * Disable control Buttons on all other windows when top window is in enter data mode. (ConfigFields) * Put Parent Assembly field back on Witems. * Decrement Stocks records when assembling non-unique components. * Fixed a problem with Witems/GetLastCmnt and Wtest/GetLastCmnt, whereby an expression like @[a] * (@[b] + 1) is evaluated by Omnis as a*b + b. Problems Remaining * Need better multi-user access to Local Cache within an institute. * Shipments still not working. * Need reports for special tests. * New passwords for next release. Site-dependent passwords for data entry? * Need a menu(?) to navigate from Witems to Wassemblies, Wtests, Wship for any item.