With the release of WIMS Client 7.8.6 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.6 client.
Tech Notes:
SQL Server Scripts:
OPSROOT
ALTER TABLE PORTALSCHEDULE ADD WHERECLAUSE NVARCHAR(2000)
ALTER TABLE PORTALSCHEDULE ALTER COLUMN Q2VLIST NVARCHAR (max) NULL
ALTER TABLE PORTALQUEUE ALTER COLUMN Q2VLIST NVARCHAR (max) NULL
ALTER TABLE CALCQUEUE ALTER COLUMN VLIST NVARCHAR (max) NULL
ALTER TABLE CALCNODEQUEUE ALTER COLUMN VLIST NVARCHAR (max) NULL
FACILITY DATABASES
ALTER TABLE CALCGRP ADD WHERECLAUSE NVARCHAR (2000) NULL
ALTER TABLE HDE ADD HEADER_HEIGHT [FLOAT] NULL
ALTER TABLE HDE ADD HEADERFONT_NAME NVARCHAR(50) NULL
ALTER TABLE HDE ADD HEADERFONT_SIZE [FLOAT] NULL
ALTER TABLE HDE ADD HEADERFONT_BOLD [numeric](18, 0) NULL
ALTER TABLE HDE ADD HEADERFONT_ITALIC [numeric](18, 0) NULL
ORACLE:
OPSROOT
ALTER TABLE PORTALSCHEDULE ADD WHERECLAUSE NVARCHAR2 (2000) NULL
FACILITY DATABASES
ALTER TABLE CALCGRP ADD WHERECLAUSE NVARCHAR2 (2000) NULL
ALTER TABLE HDE ADD HEADER_HEIGHT NUMBER NULL
ALTER TABLE HDE ADD HEADERFONT_NAME NVARCHAR2(50) NULL
ALTER TABLE HDE ADD HEADERFONT_SIZE NUMBER NULL
ALTER TABLE HDE ADD HEADERFONT_BOLD NUMBER NULL
ALTER TABLE HDE ADD HEADERFONT_ITALIC NUMBER NULL