U
Unites_web_developer
Help! - I'm trying to add a Hyperlink into a PWA Project and getting no
result (or error). I'm doing exactly the method described in the pjdb.htm
help file. Here are my insert/update statements verbatim:
INSERT INTO MSP_TEXT_FIELDS
(PROJ_ID,
TEXT_CATEGORY,
TEXT_REF_UID,
TEXT_FIELD_ID,
TEXT_VALUE)
VALUES
(10, -- My project ID
0, -- task category
2, -- My UID of the task
188743898, -- 'Task Hyperlink Address'
'http://myserver/default.htm')
UPDATE MSP_PROJECTS
SET PROJ_EXT_EDITED = 1,
PROJ_EXT_EDITED_TEXT = 1
WHERE proj_id = 10
I see the data inserted/updated in the table after running this, but I see
no change when I pull the Project up in PWA. I've tried this on old and new
projects I've created using PDS with no result. I've also tried this on
projects that were published by Project client with existing Hyperlinks with
no result. Am I missing something or is there some known issue with manually
inserting Hyperlinks/Text Fields into PWA Projects.
Thanks - Chad
result (or error). I'm doing exactly the method described in the pjdb.htm
help file. Here are my insert/update statements verbatim:
INSERT INTO MSP_TEXT_FIELDS
(PROJ_ID,
TEXT_CATEGORY,
TEXT_REF_UID,
TEXT_FIELD_ID,
TEXT_VALUE)
VALUES
(10, -- My project ID
0, -- task category
2, -- My UID of the task
188743898, -- 'Task Hyperlink Address'
'http://myserver/default.htm')
UPDATE MSP_PROJECTS
SET PROJ_EXT_EDITED = 1,
PROJ_EXT_EDITED_TEXT = 1
WHERE proj_id = 10
I see the data inserted/updated in the table after running this, but I see
no change when I pull the Project up in PWA. I've tried this on old and new
projects I've created using PDS with no result. I've also tried this on
projects that were published by Project client with existing Hyperlinks with
no result. Am I missing something or is there some known issue with manually
inserting Hyperlinks/Text Fields into PWA Projects.
Thanks - Chad