Hi All,
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 AssignmentTimephasedBy Week 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
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 AssignmentTimephasedBy Week 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