Unique Not Null Not Updating

[Mark]

Hi All!

I have an editable RadGrid with a SQL Server 2008 back end.  I can successfully update values except when updating one field that is UNIQUE NOT NULL. 

When I insert a new item I can populate this field with no issue.

I have checked the update script in SQL Server Management Studio, and it updated the entry correctly.

Can anyone please advise me?

Thanks,
Mark

[Mark]

OK, it's definitely not the fact that that column is NOT NULL UNIQUE.

I do, on RadGrid_InsertCommand, intercept the value entered by the User, and if it is "" I enter in a temporary value, but that should have nothing to do with the update functionality . . . hmm . . .

[Mark]

Huh, it would appear that the reason I cannot update that field is because it is the MasterKeyField.  It is also in the DataKeyNames.

[Mark]

Figured it out!

In RadGrid_UpdateCommand I set RadGrid.MasterTableView.DataKeyNames = null.  In RadGrid_ItemUpdated I reset it.