deleted activities shows when retrieving data from PMDB task table in excel, P6
Hi There,
I created a macro to retrieve activities of a specific project from P6 in Excel, the sql statement is like this :
"Select a.task_id, b.wbs_name, a.task_code, a.task_name, a.early_start_date,a.early_end_date, a.act_start_date, a.act_end_date, a.status_code FROM TASK a join PROJWBS b ON a.wbs_id=b.wbs_id where a.proj_id = '" + projID + "' "
It connects directly to PMDB (not SDK), however after retrieving activities, in excel I see some activities which already been deleted from the project in P6.