Proj_Id that MsProject wants...

[ma.u]

Hi,
I use Project 2003 on Oracle 9 database, and I created some triggers
on
MSP_TASKS and MSP_PROJECTS for keep syncronized project data with an
another
database.
When I save sometimes Project say me to check data, but these are data
that
IT load from db and adjust (I set EXT_EDITED_??? fields); sometimes it
delete
all tasks.
Looking in msp_tasks i see that the tasks i need have another proj_id
(code of temporary project used by MSProject during save).
Why MSP change proj_id of my tasks?
Thanks

 

[Rod Gill]

Does this all work if you remove the triggers you added? Microsoft does say
that changing the schema of the database in any way can cause problems.

--
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.projectlearning.com/

 

[Huan]

Before changing information in msp_task, you have to archive the the row you
want to change (MS Provides a standard routine - check your CD) and you also
have to flag the header record (msp_projects) that you have changed something
in the project manually.