PDA

View Full Version : Major and Minor Revision


Yannick Rouat
05-02-2007, 11:45 PM
Hello all,

In ModelManager, minor rev and major rev are pseudo attribute from VERSION.

Is there a way to have only one of them (Major Rev) on the frame in Annotation.

Thanks.

Yannick

Yannick Rouat
05-09-2007, 08:26 AM
Hello

While waiting for a response of my support, I found a solution by using oracle trigger, to split the variable Version and to recopy the minor and major revision in other fields in the table MODEL_3D and DRAWING_2D.

example :
create or replace trigger major_rev_2_data1_M3d
before insert or update
on MODEL_3D
for each row
begin
:NEW.maj_rev := substr(:NEW.VERSION,1,1);
end major_rev_2_data1_M3d;
/
show errors;

create or replace trigger minor_rev_2_data2_M3d
before insert or update
on MODEL_3D
for each row
begin
:NEW.min_rev := substr(:NEW.VERSION,3,1);
end minor_rev_2_data2_M3d;
/
show errors;


Regards