If I run a SQL statement and just clear the TASK_ACT_START field from the SQL Server, that seems to work. However, when I set the Constraint after that, it doesn't seem that the task is always moving with the Constraint.
Using the TaskRow method SetTaskActStartNull() does set the field to null in the DataRow, but it doesn't seem to have any effect on the that task on the Server when I run the QueueUpdateProject and QueuePublish publish methods for the project. The TASK_ACT_START does not change on the server.
Are these Set...Null() methods only for the Nulling the DataRow field, but the Null value is not actually pushed up to the project on the server? I did notice that when I took the project dataset and used the GetXml() method and then looked at the xml for the dataset that when you use the Set..Null() method for any task that the field that you are setting to Null does not show up in the xml. Being that the field is not in the xml, I would assume that there is no update to the field in SQL when project makes the updates.  |