column / table in draft database that flags project object as atemplate

[anovak]

Anyone know of data I can check for this? I've got a VBA running
that scans through all the rows in MSP_Projects, opens the project,
sets the value of a custom field, saves, and checks in.

Problem is, a couple of templates are included in the list and the VBA
stops on the save because you have to give it a project name.

I want to skip these rows in the SQL statement.

Thanks
Andy Novak
UNT

 

[Chak]

Hi Andy,

Microsoft advice not to update project information through SQL. Please
keep this in mind.

Anyhow, answer to your question, include where statement as below:

SELECT * from dbo.MSP_PROJECTS
WHERE PROJ_TYPE <> 1

Proj_Type value is 1 for templates.

Thanks
Chak
http://www.epmcentral.com

 

[anovak]

Hi Andy,

Microsoft advice not to update project information through SQL. Please
keep this in mind.

Anyhow, answer to your question, include where statement as below:

SELECT * from dbo.MSP_PROJECTS
WHERE PROJ_TYPE <> 1

Proj_Type value is 1 for templates.

Thanks
Chakhttp://www.epmcentral.com

Heavens no I'm not updating the database with SQL, just picking up the
project names with SQL then looping through with VBA opening each
project at a time through macros.

Thanks for the info!
Andy