1. UNIFYBroker Forum
  2. Ideas
0
Completed

default Identity column to read only

Matthew Woolnough 11 years ago • updated by anonymous 8 years ago • 3

When creating SQL connector: If there is an IDENTITY column in schema and 'IDENTITY_INSERT' is set to 'OFF' (not sure if it is possible to query table for current IDENTITY_INSERT config), create the attribute as read only.

When it is not read only, the error below is reported.

Cannot insert explicit value for identity column in table 'FIMEmployee' when IDENTITY_INSERT is set to OFF.

Tony Sheehy 11 years ago

I agree with this, and as you mentioned not sure if it's possible to find out this information, but definitely worth looking at for 4.0.2.

Thanks.

Adam van Vliet 9 years ago

The has been fixed and will be available in the next release.

Adam van Vliet 9 years ago

Confirmed or migrated to VSO.

Customer support service by UserEcho