cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Windchill new CREO item Name=Number=File Name

WayneBeck
1-Newbie

Windchill new CREO item Name=Number=File Name

Has anyone found a way to set Name and Number equal to File Name for new Creo items? In our old windchill install we had triggers in the data base that did this. I know this did not come from PTC, I asked. I would think there should be a way to do this with attributes. For anyone that would like to know what the triggers are here you go.


create or replace
TRIGGER EPM_RENAME
BEFORE UPDATE OR INSERT ON EPMDOCUMENTMASTER
FOR EACH ROW
begin
:new.name := lower(:new.cadname);
:new.documentnumber := upper(:new.cadname);
end;

create or replace
TRIGGER DOC_RENAME
BEFORE UPDATE OR INSERT ON WTDOCUMENTMASTER
FOR EACH ROW
begin
:new.wtdocumentnumber := upper(:new.name);
update applicationdata set filename =:new.name where filename =:old.name;
update wtdocument set title =:new.name where title =:old.name;
end;

0 REPLIES 0
Announcements