D
David Wiart
Hi,
I've got a little problem with PDS. I need to update timesheetdata
using assignmentsSave and to raise these updates to the project manager
(like using the "Update All" Button in PWA ), i've put the bool
UpdateProjectManager to 1 but it not seems to raise updates to the
projectManager. So i've tried to use the
AssignmentsProjectManagerUpdate Method, but it seems to do the same
thing like the bool in AssignmentsSave...
After working around this problem, i've tried to look what those three
actions do on the ProjectServer database using the SQLProfiler. And I
remark that one query is not executed when I use PDS Methods, it's like
:
exec sp_executesql N'UPDATE "ProjectServer".."MSP_WEB_ASSIGNMENTS" SET
"WASSN_ACTUALS_PENDING"=@P1,"WASSN_RESOURCE_UPDATE"=@P2,"WASSN_REQUEST_UPDATE"=@P3,"WASSN_SEND_UPDATE_DATE"=@P4
WHERE "WASSN_ID"=@P5 AND "WASSN_ACTUALS_PENDING"=@P6 AND
"WASSN_RESOURCE_UPDATE"=@P7 AND "WASSN_REQUEST_UPDATE"=@P8 AND
"WASSN_SEND_UPDATE_DATE"=@P9', N'@P1 tinyint,@P2 tinyint,@P3
tinyint,@P4 datetime,@P5 int,@P6 tinyint,@P7 tinyint,@P8 tinyint,@P9
datetime', 1, 0, 0, 'Oct 12 2005 3:11:48:000PM', 129, 1, 0, 0, 'Oct 12
2005 12:17:24:000PM'
Does someone have any idea or the same problem ?
thanks
David
I've got a little problem with PDS. I need to update timesheetdata
using assignmentsSave and to raise these updates to the project manager
(like using the "Update All" Button in PWA ), i've put the bool
UpdateProjectManager to 1 but it not seems to raise updates to the
projectManager. So i've tried to use the
AssignmentsProjectManagerUpdate Method, but it seems to do the same
thing like the bool in AssignmentsSave...
After working around this problem, i've tried to look what those three
actions do on the ProjectServer database using the SQLProfiler. And I
remark that one query is not executed when I use PDS Methods, it's like
:
exec sp_executesql N'UPDATE "ProjectServer".."MSP_WEB_ASSIGNMENTS" SET
"WASSN_ACTUALS_PENDING"=@P1,"WASSN_RESOURCE_UPDATE"=@P2,"WASSN_REQUEST_UPDATE"=@P3,"WASSN_SEND_UPDATE_DATE"=@P4
WHERE "WASSN_ID"=@P5 AND "WASSN_ACTUALS_PENDING"=@P6 AND
"WASSN_RESOURCE_UPDATE"=@P7 AND "WASSN_REQUEST_UPDATE"=@P8 AND
"WASSN_SEND_UPDATE_DATE"=@P9', N'@P1 tinyint,@P2 tinyint,@P3
tinyint,@P4 datetime,@P5 int,@P6 tinyint,@P7 tinyint,@P8 tinyint,@P9
datetime', 1, 0, 0, 'Oct 12 2005 3:11:48:000PM', 129, 1, 0, 0, 'Oct 12
2005 12:17:24:000PM'
Does someone have any idea or the same problem ?
thanks
David