Trouble with Timephased table updates

[Braker]

I'm having trouble updating a project's early start using sql in the
timephased table. The task will update but it will shift the entire task
including the finish date. When I update using the interface in Project
professional or web access it will split the task and my finish date isn't
affected. I think my problem has something to do with the TD_Field_ID in the
MSP_Timephased_data table. I use the value "2" to update assignment actual
work. Thanks in advance for your help.

 

[Rod Gill]

If you expect the task to split, then you must have some of the time slices
values set to zero, exactly as in the usage view in Project.

Work out exactly what should happen manually, then look to duplicate that in
your code. So, if you update manually actual work daily, you need days as
the time in the timescaledata method.