Home : Database Upgrade 7.8.2
Q14566 - INFO: Database Upgrade 7.8.2
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'

 

Related Articles
No Related Articles Available.

Article Attachments
No Attachments Available.

Related External Links
No Related Links Available.
Help us improve this article...
What did you think of this article?

poor 
1
2
3
4
5
6
7
8
9
10

 excellent
Tell us why you rated the content this way. (optional)
 
Approved Comments...
No user comments available for this article.
Created on 1/13/2020 4:19 PM.
Last Modified on 1/27/2020 11:54 AM.
Last Modified by Scott Dorner.
Article has been viewed 359 times.
Rated 0 out of 10 based on 0 votes.
Print Article
Email Article