SCT_DB Omnis Application Updates SCT_DB v 3.10 16/4/99 ---------------------- Add window for Shipments. Table LAST_MOD format back to 'DD/MM/YYYY HH:MI:SS' on Master Server and local cache. Add THIS_LOCN.VERSION_NO attribute on Master Server. Index table LAST_MODs on Master Server and local cache. New Tables.BuildSkeletonDB method do drop most tables except LOCNS, recreate + index them. Then user populates tables from master server when he installs new library. Bugs Fixed Problems Remaining * No report defined for TEST_DET_BEHAVE. * Need better multi-user access to Local Cache within an institute. * Need a system for updating data structure in local caches. * Need to distinguish between '0' and NULL for numeric fields * Use W_TEST_DET_BEHAVE version of $IsComplete in W_DE_Simple and W_DE_Detail. * Shipments not working properly. SCT_DB v 3.00 19/3/99 ---------------------- Add window for Test raw data. Add window for stocks. Add user option 'Maintain Stocks'. Decrement Stocks quantity of batch items when they are assembled, but do nothing when disassembled. Bugs Fixed * Disable Insert button on Special test window. Fix enable/disable of Delete button on Special test window. * Enable Edit button on detail windows correctly. * Change data type of TEST_RAWDATA.RAWDATA to binary in local cache, so it translates correctly to LONG RAW on Oracle. Problems Remaining * No Shipment window for now. * No report defined for TEST_DET_BEHAVE. * Need better multi-user access to Local Cache within an institute. * Need a system for updating data structure in local caches. * Table.LAST_MODS are not indexed yet. * Really ought to have LAST_MOD format='DD/MM/YYYY HH:MI:SS'. Otherwise new class 2 records get Merged local-->master, then merged master-->local immediately, and finally master-->local again at some date > date of 1st merge. SCT_DB v 2.32 (Never released) ---------------------- All table.LAST_MODs will be indexed on Master Server, so MAX(table.LAST_MOD) quickly gives LAST_MOD for that table and remote LAST_MOD.LAST_MOD can be ignored. Master table.LAST_MODs record only DD/MM/YYYY, not HH:MI:SS, so C_Sessions/UpdateLocalTables is changed to look for (Master table.LAST_MOD) >= (Local LAST_MOD.LAST_MOD), and (Local LAST_MOD.LAST_MOD) is updated with SYSDATE rather than (Master table.LAST_MOD). Wildcard Find implemented. There is a new USER_PREFS attribute (WILDCARDS), settable from the Sessions/Options menu. Add permanent logging of Local<-->Master merge in text file MergeLog.txt. New entity MFRS.MFR_NO for ensuring serial number unicity for detectors labeled by manufacturers. New window for detector items with active 'scratch pads' for inserting/finding serial numbers. Bugs Fixed * Remove IS_UNIQUE from definition of lists lAllTypes, lAssmTypes. It prevented Finds on IS_UNIQUE from working properly when the focus was on CTYPE or DESCRIPTION field in WitemDescr. Problems Remaining * Inserting Detector Behaviour records should only be done by first inserting a new record in the GENERIC TESTS window. Never use the 'Insert' button on the Detector Behaviour window. This will be fixed later. * No Shipment window for now. * No Stocks window for now. * No report defined for TEST_DET_BEHAVE. * No TEST_RAWDATA window yet. * Need better multi-user access to Local Cache within an institute. * Need a system for updating data structure in local caches. SCT_DB v 2.31 12/2/99 ---------------------- Make Items, Assembly Description, Assemblies, Tests, Si Detector Behaviour windows resizable, with Comments/Components/Defects subwindow size following main window. Bugs Fixed * Remove REQUIRED field from Test Description window/report and add it to Test List window/report. * Add DOSE_RATE_UNIT field to Si Detector Test window/report. * Test Comments were not associated with the correct tests. * Reports for Tests were not working. * Deleting a record in the Generic Tests window now deletes the corresponding special test first. * If you Find some records in a special test window, the corresponding generic test information is now updated in the generic test window. * Merging Local Cache <--> Master server seems to work now. More tests! Problems Remaining * Inserting Detector Behaviour records should only be done by first inserting a new record in the GENERIC TESTS window. Never use the 'Insert' button on the Detector Behaviour window. This will be fixed later. * No Shipment window for now. * LAST_MOD attribute only stored with DD/MM/YYY info on master server. Should also include HH/MI/SS, to get latest update on any day. * No report defined for TEST_DET_BEHAVE. * No TEST_RAWDATA window yet. * Need better multi-user access to Local Cache within at institute. SCT_DB v 2.30 29/1/99 ---------------------- The LOCAL_CACHE datafile was rebuilt to conform to the format of the V 2.3 Oracle Master datafile at University of Geneva. Affected indices were re-created. Connection to Master server via new access scheme works now. Bugs Fixed * The default Username was not updated when the identity of the local institute was changed in the 'Where am I?' window. This resulted in some class 2 entries (e.g. People) not being editable by their owners. * Component types in Assembly description detail window were sometimes truncated to 16 characters. Problems Remaining * Deleting a record in the Tests window still does not delete the corresponding Detector Behaviour Test and Defects records. * Inserting Detector Behaviour records should only be done by first inserting a new record in the GENERIC TESTS window. Never use the 'Insert' button on the Detector Behaviour window. This will be fixed later. * No Shipment window for now. * Merging Local Cache <--> Master Server disabled for now.