I tried it, it didn't work.
MyDs.MyTable.AcceptChanges()
MyDa.Update(MyDs, "MyTable")
I also noticed that GETCHANGES method does not return the modified records until record pointer is moved.
If Not MyDs.MyTable.GetChanges() Is Nothing Then
MyDa.Update(MyDs, "MyTable")
End If
>Issue AccecptChanges() before Update().
>
>>I created a typed dataset which consist of 4 related tables. I noticed that after running an update command, changes made are not saved to SQL until I move the record pointer of the dataset to another record and then run the update command.
>>WHY?