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;
