thanks for all your help. But isn't in front elevation my problem. I'm trying to find a way to get the same information (BOP) that I have in front elevation, but top view (plans), because in top view we doesn't have a line to make a "dimension ordinate".
So, there is a way to have a BOP in top view?
Like always , thank you for all your help.
One of our AEs (Thanks Dag!) came up with this procedure. It's pretty involved but I think it does what you're looking for.
This is the right way. But we need to change somethings.
Create Trigger BOP_TRIGGER_INSERT2
AFTER INSERT ON PipeRunComponent
UPDATE PipeRunComponent set EL_FT=round((select "Position Z"-MatchingPipeOD/2 from EngineeringItems where PnPId = new.PNPID),0) where PNPID=new.PNPID;
Create Trigger BOP_TRIGGER_UPDATE2
AFTER UPDATE ON EngineeringItems
UPDATE PipeRunComponent set EL_FT=round(new."Position Z"-new.MatchingPipeOD/2,0) where PNPID=new.PNPID;