Home : Database Upgrade 832
Q14811 - INFO: Database Upgrade 832

With the release of WIMS Client 8.3.2 a database upgrade is required.  The upgrade is automatically applied when logging into a Facility Database for the first time with the WIMS 8.3.2 client. 


Tech Notes:

SQL Server Scripts:

OPSROOT

INSERT INTO SPREADFUNCTIONS (AUDITUSER, AUDITTIMESTAMP,NAME,SYNTAX, DESCRIPTION,HELPID, TAG1,TAG2, TAG3) VALUES ('UP832','2024-11-14','GRAPHBAR','GRAPHBAR(GraphId, GroupOffset/StartDate, Grouping/EndDate)', 'displays a saved Bar Graph in the cell','14793', 'SPECIAL', 'GRAPH','')

INSERT INTO SPREADFUNCTIONS (AUDITUSER, AUDITTIMESTAMP,NAME,SYNTAX, DESCRIPTION,HELPID, TAG1,TAG2, TAG3) VALUES ('UP832','2024-11-14','AVERAGE','AVERAGE(Value1, Value2, ...)', 'returns the average of the specified values','11514', 'PRIMITIVE', '','')

Facility Databases

UPDATE SETTINGS SET CURVALUE = '832' WHERE SETTING= 'DATAVERSION'

Oracle Scripts:

OPSROOT

INSERT INTO SPREADFUNCTIONS (AUDITUSER, AUDITTIMESTAMP,NAME,SYNTAX, DESCRIPTION,HELPID, TAG1,TAG2, TAG3) VALUES ('UP832','2024-11-14','GRAPHBAR','GRAPHBAR(GraphId, GroupOffset/StartDate, Grouping/EndDate)', 'displays a saved Bar Graph in the cell','14793', 'SPECIAL', 'GRAPH','')

INSERT INTO SPREADFUNCTIONS (AUDITUSER, AUDITTIMESTAMP,NAME,SYNTAX, DESCRIPTION,HELPID, TAG1,TAG2, TAG3) VALUES ('UP832','2024-11-14','AVERAGE','AVERAGE(Value1, Value2, ...)', 'returns the average of the specified values','11514', 'PRIMITIVE', '','')

Facility Databases

UPDATE SETTINGS SET CURVALUE = '832' 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 11/14/2024 10:24 AM.
Last Modified on 11/14/2024 10:29 AM.
Last Modified by Scott Dorner.
Article has been viewed 47 times.
Rated 0 out of 10 based on 0 votes.
Print Article
Email Article