Basically, this is a note to myself, but it may help you anyway. So, I publish it here.
Creating a little more complex query today, I got the error message "Insufficient key column information for updating or refreshing" when trying to apply changes to the data set.
Solution: Set CursorLocation to clUseServer and CursorType to ctKeySet.
Technology: ADO, SQL Server
The opinions expressed herein are my own personal opinions and do not represent my employer's view in any way.
Theme design by Jelle Druyts