Hi,

I’m not sure  the strip_id and term_id and term_seq will be the same for each panel and to create sql for 50 panels might take more then to create it through the application.

The short way to do it is to click on the 30^tn terminal hold the shift key and click 40^th terminal the terminal from 30 – 40 will highlight.

Right click with the mouse and duplicate the terminals.

The first terminal  properties with term num 30 and sequence 41(term 30 ) will pop up and you should change the name to 41 click on next and you

get the next duplicate term do the same till you complete changing all the duplicate terminals and click save.

Regards

Ilan Hills

Hi,

You should replace the columns mark in color with the right ID for term_seq the term 41 should be 41 for term 42  should be 42 etc

INSERT INTO panel_strip_term VALUES (<Panel_id>,<Strip_id>,<term_id>,<proj_id>,<site_id>,0,'DBA','W',sysdate,<Term_seq>,'<Term_num>',0,0,0,0,<Area_id>,<Plant_id>,<unit_id>,' ','N',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'G',0,NULL,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL);

List of column in panel_strip_term table

            panel_id float,

            strip_id float,

            term_id float,

            proj_id float,

            site_id float,

            chg_num float,

            user_name char(30),

            chg_status char(1),

            chg_date date,

            term_seq float,

            term_num char(10),

            term_type_id float,

            term_mfr_id float,

            term_mod_id float,

            term_color_id float,

            area_id float,

            plant_id float,

            unit_id float,

            term_note char(40),

            def_flg char(1),

            channel_id float,

            term_split_flg char(1),

            term_sec_name char(10),

            udf_c01 char(40),

            udf_c02 char(40),

            udf_c03 char(40),

            udf_c04 char(40),

            udf_c05 char(40),

            udf_c06 char(40),

            udf_c07 char(40),

            udf_c08 char(40),

            udf_c09 char(40),

            udf_c10 char(40),

            udf_c11 char(40),

            udf_c12 char(40),

            udf_c13 char(40),

            udf_c14 char(40),

            udf_c15 char(40),

            udf_c16 char(40),

            udf_c17 char(40),

            udf_c18 char(40),

            udf_c19 char(40),

            udf_c20 char(40),

            hw_pos_id float,

            term_hw_flg char(1),

            term_color_right_id float,

            rev_id float,

            eng_proj_id float,

            eng_ref_id float,

            port_right_id float,

            port_left_id float,

            pin_right_id float,

            pin_left_id float,

            polarity_right char(4),

            polarity_left char(4),

            func_left char(10),

            func_right char(10),

            channel_left char(2),

            channel_right char(2));

Regards

Ilan Hills