HOW UPDATE A MSP_NUMBER_FIELDS ?

[OPSITI]

I update a custom field using this SQL

update MSP_NUMBER_FIELDS
set NUM_VALUE = 80
WHERE NUM_FIELD_ID = 188744706
and proj_id=1759

What this update is not visibled on project client ?
If I am update a custom field by project client it
update a field NUM_VALUE in the table MSP_NUMBER_FIELDS.

tks
henriquerudiger

 

[Rod Gill]

Hi,

You have to refer CAREFULLY to the projdb.htm file found in one of your
project folders. It will explain the flags you also need to set to have
Project recognise the database change. No flag setting: no effect.

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

 

[OPSITI]

Rod, I read a document projdb.htm
and set flags.

My code to update database is please confirm this because
this code not work correct and my project not update.

Update MSP_PROJECTS
Set PROJ_EXT_EDITED =1
Where PROJ_ID = 1429

update msp_projects
set PROJ_EXT_EDITED_NUM=1,
PROJ_EXT_EDITED_DATE=1,
PROJ_EXT_EDITED_DUR=1,
PROJ_EXT_EDITED_FLAG=1,
PROJ_EXT_EDITED_CODE=1,
PROJ_EXT_EDITED_TEXT=1
where PROJ_ID = 1429

update msp_field_attributes
set ATTRIB_EXT_EDITED =1
where attrib_FIELD_ID in
(188744699, 188744700, 188744701, 188744702,
188744703, 188744704, 188744705, 188744706,
188744707, 188744708, 188744709, 188744710)
AND PROJ_ID = 1429


update MSP_NUMBER_FIELDS
set NUM_VALUE = 77
where NUM_FIELD_ID in
(188744699, 188744700, 188744701, 188744702,
188744703, 188744704, 188744705, 188744706,
188744707, 188744708, 188744709, 188744710)
AND PROJ_ID = 1429

update msp_field_attributes
set ATTRIB_EXT_EDITED =0
where ATTRIB_FIELD_ID in
(188744699, 188744700, 188744701, 188744702,
188744703, 188744704, 188744705, 188744706,
188744707, 188744708, 188744709, 188744710)
AND PROJ_ID = 1429

select * from msp_attribute_strings

where ATTRIB_FIELD_ID in
(188744699, 188744700, 188744701, 188744702,
188744703, 188744704, 188744705, 188744706,
188744707, 188744708, 188744709, 188744710)
AND PROJ_ID = 1429
select * from msp_field_attributes

update msp_projects
set PROJ_EXT_EDITED_NUM=0,
PROJ_EXT_EDITED_DATE=0,
PROJ_EXT_EDITED_DUR=0,
PROJ_EXT_EDITED_FLAG=0,
PROJ_EXT_EDITED_CODE=0,
PROJ_EXT_EDITED_TEXT=0
where PROJ_ID = 1429

Update MSP_PROJECTS
Set PROJ_EXT_EDITED =0
Where PROJ_ID = 1429


tks Rod

 

[Rod Gill]

Hi,

Why are you clearing the flags at the end? Project clears those when the
project is next re-saved. Clearing them is one problem, suggest deleting
that last block of code.

There are only entries for number fields if a number field is edited in
Project then the project is saved, or you've added a number field yourself.
So, you have to make sure there is a number field for each task you want
set.

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

 

[OPSITI]

hi

I solve my problem with your help.

tks Rod Gill,


I update my custom fields directly in the database.
This fields using a formula to set a flag(picture) in
the webview.

Now, in the webview, this value of this fields is correct
but your picture(flag), is not update.

Why update flags, formula based, in my custom fields,
updated directly in my database ?

tks,
Henrique