Has anyone ever had a problem inserting a record in to a VIEW with an IDENTITY COLUMN in SQLServer?
index 1, field 'pk_UserID', value = -1
index 2, field 'UserName', length: 6, value = 'keiarm'
index 3, field 'FirstName', length: 7, value = 'Keith 1'
index 4, field 'LastName', length: 9, value = 'Armstrong'
index 5, field 'Email', length: 26, value = 'Keith.Armstrong'
index 6, field 'DefaultTimeZone', length: 16, value = 'Europe/Stockholm'
Cannot insert explicit value for identity column in table 'User' when IDENTITY_INSERT is set to OFF.
I have a view which is just a SELECT from a table called USER. For some reason, even though I have Generation/retrieval method (table-global) set to auto-generated/identity column
and Retrieval timing (table-global) set to after row insertion, the INSERT statement is still trying to put a value in the identity column (called pk_UserID in the view).
This is the newest JDBC Driver on IDM 4.7.1.