D
Dmitry
Hi all.
I try to progarammatically make modifications to data in Project Server 2003
database using PDS and DB access. Will you explain me the correct sequence
of operations to, for example, create project and modify project data? As
far as I understood from PDS reference the operations sequence to modify
project data is as follows:
1) check out the project
2) make DB connection and get SPID (connection stays open)
3) call ProjectsAccess and pass SPID
4..N) call PDS methods and perform DB operations
N+1) call ProjectsAccessCompleted
N+2) close the DB connection
then steps 2 - N+2 may be performed several times with some pauses between
them (for user interaction)
N+3) check in the project
Am I correct in this assumption?
The second question is: how to make all this work transactional? Can I do
something like "undo chackout" to leave all the data just as it was when I
checked out the project? As far as I see now it is absolutely impossible...
And what about server crash while I perform some modifications to data? For
example, I checked out a project, made some modifications to its data
(calling PDS and updating DB) and in the middle of these operations DB
server (or Project Server) crashes. The data stays inconsistent. How do you
solve such problems?
Hope you will help. Thanks in advance.
I try to progarammatically make modifications to data in Project Server 2003
database using PDS and DB access. Will you explain me the correct sequence
of operations to, for example, create project and modify project data? As
far as I understood from PDS reference the operations sequence to modify
project data is as follows:
1) check out the project
2) make DB connection and get SPID (connection stays open)
3) call ProjectsAccess and pass SPID
4..N) call PDS methods and perform DB operations
N+1) call ProjectsAccessCompleted
N+2) close the DB connection
then steps 2 - N+2 may be performed several times with some pauses between
them (for user interaction)
N+3) check in the project
Am I correct in this assumption?
The second question is: how to make all this work transactional? Can I do
something like "undo chackout" to leave all the data just as it was when I
checked out the project? As far as I see now it is absolutely impossible...
And what about server crash while I perform some modifications to data? For
example, I checked out a project, made some modifications to its data
(calling PDS and updating DB) and in the middle of these operations DB
server (or Project Server) crashes. The data stays inconsistent. How do you
solve such problems?
Hope you will help. Thanks in advance.