Y
Yashr
I am new to project and need some help with project server/2003.
We are trying to extract task information based on some conditions and put
it in a different database/table (Table Custom) . I have written a database
trigger in MSP_tasks table to handle this. When the data is written to Table
Custom, it creates a sequence number. I take this seq # and update Number 13
of the task filed.
I do this by using the following SQL inside the trigger.
insert into MSP_NUMBER_FIELDS values ( @proj_id , 0, @task_uid, 188743989,
@trial_no). ( say this is for TaskA)
The insert seems to work ok. However, when I open the project I do not see
this value in number 13 for Task A.
The only way I am able to get this populated is by adding another task (
Task B) with a value in number 13. Now both task A & B has values in number
13 once I close and re-open the project.
This is telling me I am missing some link while inserting to the database.
When I run this SQl the data seems to be correct.
select task_name,task_uid,task_id ,numb.*
from MSP_NUMBER_FIELDS numb, MSP_Tasks task,MSP_CONVERSIONS conv
where task.proj_id=1111
and numb.proj_id = task.proj_id
and num_ref_Uid = task.task_uid
and numb.num_field_id = conv.conv_value
and conv.conv_string like '%Number13%'
Any help/ advice is appreciated.
We are trying to extract task information based on some conditions and put
it in a different database/table (Table Custom) . I have written a database
trigger in MSP_tasks table to handle this. When the data is written to Table
Custom, it creates a sequence number. I take this seq # and update Number 13
of the task filed.
I do this by using the following SQL inside the trigger.
insert into MSP_NUMBER_FIELDS values ( @proj_id , 0, @task_uid, 188743989,
@trial_no). ( say this is for TaskA)
The insert seems to work ok. However, when I open the project I do not see
this value in number 13 for Task A.
The only way I am able to get this populated is by adding another task (
Task B) with a value in number 13. Now both task A & B has values in number
13 once I close and re-open the project.
This is telling me I am missing some link while inserting to the database.
When I run this SQl the data seems to be correct.
select task_name,task_uid,task_id ,numb.*
from MSP_NUMBER_FIELDS numb, MSP_Tasks task,MSP_CONVERSIONS conv
where task.proj_id=1111
and numb.proj_id = task.proj_id
and num_ref_Uid = task.task_uid
and numb.num_field_id = conv.conv_value
and conv.conv_string like '%Number13%'
Any help/ advice is appreciated.