Only submit changes to the field that change
I am trying to change only one cell of data, I when I submit, its trying to update all of the fields on the row. I am getting this error: [22001][8152] Line 1: String or binary data would be truncated., but I don't know which field it is having an issue with. Is there anyway to configure DataGrip so that only updates the cells that have changed rather than the whole record?
Please sign in to leave a comment.
Seems like there's a mismatch in value types or the value length exceeds the type range:
https://stackoverflow.com/questions/6388756/sql-server-string-or-binary-data-would-be-truncated
Are you updating the table values via Data Editor? Please specify your current IDE version and upload the following info onto the FTP https://uploads.jetbrains.com/
- table DDL and the new value you enter
- database log from Help - Show SQL Log in FIles
Provide the upload id in your reply