With the release of WIMS Client 7.8.2 a database upgrade is required. The upgrade is automatically applied when logging into a Facility Database for the first time with the WIMS 7.8.2 client.
Tech Notes:
SQL Server Scripts:
OPSROOT
No updates
FACILITY DATABASES
The LabCal Column Width, Row Height, and Font Size settings are moved from OPSROOT.GENERALSETTINGS to the Settings Table. See Facility Setup to review this settings.
- gColWidth OPSROOT.GENERALSETTING moved to Facility.SETTINGS LABCAL-COLWIDTH
- RowHeight OPSROOT.GENERLSETTING moved to Facility.SETTINGS LABCAL-ROWHEIGHT
- LabCal_FontSize OPSROOT.GENERLSETTING moved to Facility.SETTINGS LABCAL-FONTSIZE
- Facility.SETTINGS LABCAL-SAMPNUM-EDIT defaulted to OFF.
ALTER TABLE LC_SAMPLETEST ADD STARTANALYSTID [numeric](18, 0) NULL DEFAULT (NULL)
ALTER TABLE LC_RESULTS_SET ADD AISHOW [numeric](18, 0) NULL
ALTER TABLE LC_RESULTS_SET ADD AIFORMHEIGHT [numeric](18, 0) NULL
ALTER TABLE LC_RESULTS_SET ADD AIFORMWIDTH [numeric](18, 0) NULL
ALTER TABLE LC_RESULTS_SET ADD AIFORMLEFT [numeric](18, 0) NULL
ALTER TABLE LC_RESULTS_SET ADD AIFORMTOP [numeric](18, 0) NULL
ALTER TABLE LC_RESULTS_SET ADD AICOLWIDTH1 [numeric](18, 0) NULL
ALTER TABLE LC_RESULTS_SET ADD AICOLWIDTH2 [numeric](18, 0) NULL
ALTER TABLE LC_RESULTS_SET ADD COLWIDTH19 [numeric](18, 0) NULL
ALTER TABLE SPFORMS ADD EMAILONSAVE NVARCHAR(20) NOT NULL DEFAULT ('OFF')
ALTER TABLE SPFORMS ADD EMAILLIST NVARCHAR(4000) NULL DEFAULT (NULL)
ALTER TABLE SPFORMS ADD DISPLAYDATEFORMAT [numeric](18, 0) NOT NULL DEFAULT (1)
UPDATE SETTINGS SET CURVALUE='782' WHERE SETTING='DATAVERSION'
ORACLE:
OPSROOT
No updates
FACILITY DATABASES
The LabCal Column Width, Row Height, and Font Size settings are moved from OPSROOT.GENERALSETTINGS to the Settings Table. See Facility Setup to review this settings.
- gColWidth OPSROOT.GENERALSETTING moved to Facility.SETTINGS LABCAL-COLWIDTH
- RowHeight OPSROOT.GENERLSETTING moved to Facility.SETTINGS LABCAL-ROWHEIGHT
- LabCal_FontSize OPSROOT.GENERLSETTING moved to Facility.SETTINGS LABCAL-FONTSIZE
- Facility.SETTINGS LABCAL-SAMPNUM-EDIT defaulted to OFF.
ALTER TABLE LC_SAMPLETEST ADD STARTANALYSTID NUMBER DEFAULT NULL
ALTER TABLE LC_RESULTS_SET ADD AISHOW NUMBER NULL
ALTER TABLE LC_RESULTS_SET ADD AIFORMHEIGHT NUMBER NULL
ALTER TABLE LC_RESULTS_SET ADD AIFORMWIDTH NUMBER NULL
ALTER TABLE LC_RESULTS_SET ADD AIFORMLEFT NUMBER NULL
ALTER TABLE LC_RESULTS_SET ADD AIFORMTOP NUMBER NULL
ALTER TABLE LC_RESULTS_SET ADD AICOLWIDTH1 NUMBER NULL
ALTER TABLE LC_RESULTS_SET ADD AICOLWIDTH2 NUMBER NULL
ALTER TABLE LC_RESULTS_SET ADD COLWIDTH19 NUMBER NULL
ALTER TABLE SPFORMS ADD EMAILONSAVE NVARCHAR2(20) DEFAULT 'OFF' NOT NULL
ALTER TABLE SPFORMS ADD EMAILLIST NVARCHAR2(2000) DEFAULT NULL
ALTER TABLE SPFORMS ADD DISPLAYDATEFORMAT NVARCHAR2(20) DEFAULT 1 NOT NULL
UPDATE SETTINGS SET CURVALUE='782' WHERE SETTING='DATAVERSION'