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
vBulletin® v3.8.4, Copyright ©2000-2024, Jelsoft Enterprises Ltd.