Percent complete divided by duration

[ma.u]

Hi.
I have a Project db on an Oracle, and I have a procedure that update
TASK_PCT_COMP field (percent complete) and other fields in MSP_TASKS.
Somtimes it work correctly, but sometimes, when Project loads an
updated project, the percentage appers to be divided by duration of
the task (in days).
Why does it appen?

Thanks.

 

[Rod Gill]

Have you set all flags as per instructions in projdb.htm? This file is in
one of project's program folders and the Project CD.

--
For VBA posts, please use the public.project.developer group.
For any version of Project use public.project
For any version of Project Server use public. project.server

Rod Gill
Project MVP
For Microsoft Project companion projects, best practices and Project VBA
development services
visit www.project-systems.co.nz/
Email rodg AT project-systems DOT co DOT nz

 

[ma.u]

Yes, I set MSP_PROJECTS.PROJ_EXT_EDITED=1 and MSP_TASKS.EXT_EDIT_REF_DATA=1
Any other ideas?
Thank you for the response and sorry for OT.

 

[Lars Hammarberg]

If you don't supply the old values for ext_edit_ref_data in msp_tasks, but
simply pass in a '1', you're telling project that you've created a new task
and not modified an existing task. Run the backup storedprocedures first,
then change the pctcompl data.

/Lars Hammarberg
www.camako.se

 

[ma.u]

How can I supply old values? In an other table?
And what are the backup storedprocedures?

 

[Lars Hammarberg]

Check out the documentation that comes with Project/ProjectServer - it's in
the folder DOCS on the CD - specifically, check out the PJDB.HTM file and
look under the the heading "Adding and Changing Rows in the Database" as
well as the "Ensuring data integrity" paragraphs.

The old values should go into the EXT_EDIT_REF_DATA field as a
comma-separarated string, where you have to be very careful of the order of
the data supplied - use the stored procedures provided for simplicity.

The stored procedures are called (from memory, should be something like)
MSP_TASKS_BACKUP or MSP_BACKUP_TASK for the task data... can't remember
right now - shouldn't be difficult to find, though!

/Lars Hammarberg
www.camako.se
MSProject Premier Partner

 

[ma.u]

There was a lot of things that does not works.
Now I understand why.
And I have to fix a lot of wrong code.
Thank you.