Project Plan data

[AJ]

I am extracting data from multiple project plans through VB code. All the project plans somehow always store -1 as ProjectID in the database table. How can I differentiate data from one plan with another if the project ID is same for all the plans.

Basically what I do is when I run the VB application, the left list box is filled with all the available project plans. Next, the user can select any plan in the right list box and press the extract button. I extract data from Assignment, Task, Resources and AssignmentTimephasedByWeek tables and store in the database. Now the question is if the user extracted a particular file and after some time again extracted the same file, I should not load the data from the same plan twice into the table. There should be a way to delete the old information from that plan and insert the updated plan information into the database. I am not able to find a key by which I can fire a query to delete the old information from the table before inserting new. Could someone please help me urgently.

Many Thanks in advance

 

[Rod Gill]

Hi,

Every table also has a Proj_ID field which is unique for each project. You
need to read and thoroughly digest the projdb.htm file installed in one of
project's program folders.

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

I am extracting data from multiple project plans through VB code. All the

project plans somehow always store -1 as ProjectID in the database table.
How can I differentiate data from one plan with another if the project ID is
same for all the plans.

Basically what I do is when I run the VB application, the left list box is

filled with all the available project plans. Next, the user can select any
plan in the right list box and press the extract button. I extract data from
Assignment, Task, Resources and AssignmentTimephasedByWeek tables and store
in the database. Now the question is if the user extracted a particular file
and after some time again extracted the same file, I should not load the
data from the same plan twice into the table. There should be a way to
delete the old information from that plan and insert the updated plan
information into the database. I am not able to find a key by which I can
fire a query to delete the old information from the table before inserting
new. Could someone please help me urgently.