Project 2002 - Task Duration ( work ) updation problem

[T Mathew]

We have project 2002 Server and professional setup ,running on SQL
2000 Database .Using SQL statments I was able to insert new tasks, and
assign resources to it from the enterprise resource pool. But when i
try to update the duratiion of the task , it does not get reflected on
opening the project in Microsoft project professional .
the fields that i update for duration are
MSP_TASKS.TASK_WORK and MSP_TASKS.TASK_REM_WORK

the SQL is

update MSP_TASKS SET MSP_TASKS.TASK_NAME= @task_name ,
MSP_TASKS.TASK_WORK=@pdur , MSP_TASKS.TASK_REM_WORK=@pdur
where MSP_TASKS.PROJ_ID= @pProjId and MSP_TASKS.TASK_WBS like @WBS
and MSP_TASKS.TASK_OUTLINE_LEVEL= @task_outline

execute msp_backup_task @pProjId, @task_id


what could be the problem ?

I have resources assigned to the TASKs that i am trying to update .


Thanks for Help ,

 

[Jack D.]

We have project 2002 Server and professional setup ,running on SQL
2000 Database .Using SQL statments I was able to insert new tasks, and
assign resources to it from the enterprise resource pool. But when i
try to update the duratiion of the task , it does not get reflected on
opening the project in Microsoft project professional .
the fields that i update for duration are
MSP_TASKS.TASK_WORK and MSP_TASKS.TASK_REM_WORK

the SQL is

update MSP_TASKS SET MSP_TASKS.TASK_NAME= @task_name ,
MSP_TASKS.TASK_WORK=@pdur , MSP_TASKS.TASK_REM_WORK=@pdur
where MSP_TASKS.PROJ_ID= @pProjId and MSP_TASKS.TASK_WBS like @WBS
and MSP_TASKS.TASK_OUTLINE_LEVEL= @task_outline

execute msp_backup_task @pProjId, @task_id


what could be the problem ?

I have resources assigned to the TASKs that i am trying to update .


Thanks for Help ,

You do know that work and duration are two different things right?
Updating work does not necessarily update duration.
Try updating the duration and see if the duration is updated.

--
Please try to keep replies in this group. I do check e-mail, but only
infrequently. For Macros and other things check http://masamiki.com/project

-Jack Dahlgren, Project MVP


+++++++++++++++++++