K
Kris R.
***Project Server 2000***
I'm trying to delete 2 enterprise project-level custom fields (one date, one
number). The SQL I'm using is this:
--delete ProjectEnterpriseDate1 (Deadline) from date fields table
DELETE FROM ProjectServer.dbo.MSP_Date_Fields where Proj_ID = @Proj_ID AND
Date_Field_ID = 188744539
--delete ProjectEnterpriseNumber1 (Warning) from number fields table
DELETE FROM ProjectServer.dbo.MSP_Number_Fields where Proj_ID = @Proj_ID AND
Num_Field_ID = 188744690
--delete both from view table
Update ProjectServer.dbo.MSP_View_Proj_Projects_Ent set
ProjectEnterpriseDate1 = null, ProjectEnterpriseNumber1 = null
WHERE Ent_ProjectUniqueID = @Proj_ID
--flip externally edited bits
Update ProjectServer.dbo.MSP_Projects SET Proj_Ext_Edited_Date = 1,
Proj_Ext_Edited_Num = 1, Proj_Ext_Edited = 1
WHERE Proj_ID = @Proj_ID
After executing this, the values are indeed gone from the specified tables.
BUT, when I open the project in Pro, and open the "Project Information"
window, these values are still present. I tried forcing calculations, but
the values are still there.
What am I missing in the delete?
Thanks,
Kris R.
I'm trying to delete 2 enterprise project-level custom fields (one date, one
number). The SQL I'm using is this:
--delete ProjectEnterpriseDate1 (Deadline) from date fields table
DELETE FROM ProjectServer.dbo.MSP_Date_Fields where Proj_ID = @Proj_ID AND
Date_Field_ID = 188744539
--delete ProjectEnterpriseNumber1 (Warning) from number fields table
DELETE FROM ProjectServer.dbo.MSP_Number_Fields where Proj_ID = @Proj_ID AND
Num_Field_ID = 188744690
--delete both from view table
Update ProjectServer.dbo.MSP_View_Proj_Projects_Ent set
ProjectEnterpriseDate1 = null, ProjectEnterpriseNumber1 = null
WHERE Ent_ProjectUniqueID = @Proj_ID
--flip externally edited bits
Update ProjectServer.dbo.MSP_Projects SET Proj_Ext_Edited_Date = 1,
Proj_Ext_Edited_Num = 1, Proj_Ext_Edited = 1
WHERE Proj_ID = @Proj_ID
After executing this, the values are indeed gone from the specified tables.
BUT, when I open the project in Pro, and open the "Project Information"
window, these values are still present. I tried forcing calculations, but
the values are still there.
What am I missing in the delete?
Thanks,
Kris R.