It's not possible to add UOM codes into INtools using
INtools menu's.
To add UOM codes insert records into table [UNITS_OF_MEASURE].
read, update and execute the following script in the SQL
query analyser.
Script is made for MSSQLserver 2000
--###########################3
-- Next script will add 12 units to the table [UNIT_OF_MEASURE]
-- for use in the alarm trip list
-- C.Snoeij
-- 12-2005
-------------------------------------------------------------------
--USAGE: Run query #1 to retrieve the PROJ_ID, fill-in
--this proj_id in the script #3
--#1:
select proj_id,proj_name from project
----------------------------------------
--#2
--backup table:
select * into unit_of_measure_bak from unit_of_measure
--#3:
INSERT INTO UNIT_OF_MEASURE VALUES (
<Fill-in last row id number>,
<Fill-in proj_id number>,
<Fill-in site_id number>,
0,
'SQL_INSERT',
'W',
GETDATE(),
'<unit here e.g. mg>',
'<description of unit here e.g milligram',
'ML', --(see table UNIT_OF_MEASURE_TYPE for more info)
NULL,
NULL,
NULL,
0,
1,
'x',
'%XX',
NULL);
--###################################################
