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.
Table1 has the following columns and data's. External Content Type:
I have created an external content type based on the above table Table1 using
SharePoint Designer 2010.
I have created an external list based on the external content type that I have
created. External list has the following data
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.
But the item has been added successfully because in my list I don't have the
item with ID value =0.
When I tried adding the next item still the ID column was showing the default
value 0 and it was throwing the following error
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.
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.
Programmatically configure Location based metadata defaults in SharePoint 2010
Benefits of SharePoint 2010 Service Pack 1
I have created an external list using sharepoint designer. Primary key in the table is not autogenereted. So, I removed readonly option for the identifier. when I tried to edit an item it is showing an error
"The Field named 'RoleID' contains an Identifier which is not read only. The Update operation requires a corresponding PreUpdaterField for this Field ."
Please let me know how to edit an item when primary key is not autogenerated.