O
Omar
Hello All,
I am trying to develop a trigger which is fired when a user tries to
modify
a custom field in Microsoft Project Professional. I identified the
involved
fields as, I did a trace and found that the actual value of the custom
field
is stored in MSP_TEXT_FIELDS and MSP_WEB_WORKGROUP_FIELDS. So I put a
trigger on these tables not to allow the value to be changed. These
triggers
successfully prevented unwanted values from being inserted, (based on
what I saw in the
table contents during testing). However, I realised that when the user
closes
and re-opens the project, the value which they wanted to insert is
still
there!!!
Is it possible to programmatically change the value of custom_files
using
this approach? I am aware of the PDS kit but this is a simple
requirement
which we believe does not need the PDS. Please correct me if am wrong.
I even removed the trigger and tried to update the fields using isqlw,
but
the values were not reflected.
(I verified that there was only one row in each table which has the
value
'omar', so pardon my dangerous statement )
original value of text_value and varchar_val fields , 'omar'
executed these via isqlw(query analyszer)
update msp_text_fields set text_value = 'notomar' where text_value =
'omar'
update msp_web_workgroup_fields set varchar_val = 'notomar' where
varchar_val = 'omar'
value after statement in both columns, 'notomar'
I closed and re-opened the project several times. The value in the
custom
field is still 'omar'. Save it and publish, and the value in the fields
becomes 'omar' again.
Is there another table that am missing? Or how does MS Project
Professional
retrive the values? I tried the same approach with RBS codes and it
works
fine when i directly change the WRES_RBS_UID field.
Using : Project Server 2003 with SP2, SQL Server 2000, Windows Server
2003
Regards and thanks in advance,
Omar
I am trying to develop a trigger which is fired when a user tries to
modify
a custom field in Microsoft Project Professional. I identified the
involved
fields as, I did a trace and found that the actual value of the custom
field
is stored in MSP_TEXT_FIELDS and MSP_WEB_WORKGROUP_FIELDS. So I put a
trigger on these tables not to allow the value to be changed. These
triggers
successfully prevented unwanted values from being inserted, (based on
what I saw in the
table contents during testing). However, I realised that when the user
closes
and re-opens the project, the value which they wanted to insert is
still
there!!!
Is it possible to programmatically change the value of custom_files
using
this approach? I am aware of the PDS kit but this is a simple
requirement
which we believe does not need the PDS. Please correct me if am wrong.
I even removed the trigger and tried to update the fields using isqlw,
but
the values were not reflected.
(I verified that there was only one row in each table which has the
value
'omar', so pardon my dangerous statement )
original value of text_value and varchar_val fields , 'omar'
executed these via isqlw(query analyszer)
update msp_text_fields set text_value = 'notomar' where text_value =
'omar'
update msp_web_workgroup_fields set varchar_val = 'notomar' where
varchar_val = 'omar'
value after statement in both columns, 'notomar'
I closed and re-opened the project several times. The value in the
custom
field is still 'omar'. Save it and publish, and the value in the fields
becomes 'omar' again.
Is there another table that am missing? Or how does MS Project
Professional
retrive the values? I tried the same approach with RBS codes and it
works
fine when i directly change the WRES_RBS_UID field.
Using : Project Server 2003 with SP2, SQL Server 2000, Windows Server
2003
Regards and thanks in advance,
Omar