creating a task w/SQL code?

M

Mark Byington

I'm doing a project to update a specific project schedule using a standard
external file input and either updating exisiting tasks or creating new ones.

The EPM install disk DOC, PJDB.HTM provides en example for creating a new
task:

Insert into MSP_TASKS (
PROJ_ID,
TASK_UID,
TASK_ID,
TASK_NAME,

TASK_DUR,
TASK_OUTLINE_LEVEL,
EXT_EDIT_REF_DATA )
values (
3,
23,
8,
'my task',
4800,
1,
'1' )

I altered it for my test project schedule, and ran it. When I query the
table, the new task is there. When I open the project in Proj. Pro. it's not
there. I must need to do something more. When perusing the DOC, nothing
jumps out at me.

Can someone point me in the right direction?

Thanks...
 
K

Kevin W Flanagan

Somewhere in the documentation there's a reference to setting a flag when
updating project information outside of the application. I believe the flag
informs the application that there is an update pending. If it is not set,
the data is not picked up.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top