Where is the System codes menu

[Densnij]

Who knows where i can find the System codes menu in INtools 6,

I want to add an UOM code

Kind regards,

 

[csweb]

Hello,

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);
--###################################################

hope this helps.


Carlo
CS Webservice-Online

http://www.cs-webservice.nl