after CalculateProject, Complete% is changed

[Lawrence Chen]

Greeting, those great ones.

I found "TASK_PCT_COMP","Complete%" will be changed to 0%
after "Application.CalculateProject".

I just update "TASK_PCT_COMP" in MSP_TASK table. Project
engine refresh this field as "0%" if those tasks are not
finished.

But I suppose these "Complete%" of the tasks should not be
modified.

Why ?
And how to prevent that ?

I tried to modify OptionsCalculation.
But didn't work.

retr = Application.OptionsCalculation(Automatic,
AutoTrack, SpreadPercentToStatusDate,
SpreadCostsToStatusDate, AutoCalcCosts, FixedCostAccrual,
CalcMultipleCriticalPaths, CriticalSlack, SetDefaults,
CalcInsProjLikeSummTask)

 

[Rod Gill]

Hi,

You can't just update a filed in the MSP_ tables. You must also update other
flags and sometimes fields. All is revealed in the Projdb.htm file you will
find on you C: drive. Find it, read, read it again then try again.

--
Rod Gill
Project MVP
For Microsoft Project companion projects, best practices and Project VBA
development services
visit www.projectlearning.com/