Inserting data into Number_fileds table via database

[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.

 

[yashr]

I think I can get this to work if I update
MSP_tasks - EXT_EDIT_REF_DATA = 1
and
MSP_PROJECTS - PROJ_EXT_EDITED = 1.
However, I need to close and open the project for it to be displayed.

 

[yashr]

for number_fields you also have to update

MSP_PROJECTS.PROJ_EXT_EDITED_NUM = 1