Problem:
I was working on external list in SharePoint workspace. I was unable to add or
edit the identifier column in the external list.
Solution:
SQL Database:
I have created a database named Test which contains a table named Table1.
![SharePoint Workspace Table]()
Table1 has the following columns and data's.
![SharePoint Workspace Table and Data]()
External Content Type:
I have created an external content type based on the above table Table1 using
SharePoint Designer 2010.
![SharePoint Designer 2010]()
External List:
I have created an external list based on the external content type that I have
created. External list has the following data
![external content type Sharepoint]()
I have connected the above external list to SharePoint Workspace.
I was trying to add a new item to the external list in workspace, but I was
unable to edit the identifier column (Column Name ID). The column had the
default value as 0 and I was not able to change the column value.
![to change the column value Sharepoint]()
But the item has been added successfully because in my list I don't have the
item with ID value =0.
![to change the column value sharepoint]()
![to change the column value sharepoint]()
When I tried adding the next item still the ID column was showing the default
value 0 and it was throwing the following error
![ID column in sharepoint]()
![ID column1 in sharepoint]()
This is because when you create an external content type using SharePoint
Designer when you create all operations by default for the identifier column the
"Read - Only" field will be checked.
![identifier column sharepoint]()
That's why in SharePoint Workspace I was not able to edit the identifier column.
Make sure that when you create external content type using SharePoint Designer
uncheck the "Read - Only" field for the identifier then only we will be able to
add or update the column in SharePoint Workspace.
![column in SharePoint Workspace]()
![column in SharePoint Workspace]()