Insert with Complex PK including identity field

Author	Message
Lukasz Kustusz	Lukasz Kustusz posted 14 Years Ago Topic Details Share Topic
Group: Forum Members Posts: 29, Visits: 125	Hello, I'm running into problems trying to insert a record into a BO which has multi-field PK, where one of the fields is identity. Initially I was getting the error as in post http://forum.strataframe.net/Topic26039.aspx. Problem is that when I set PrimaryKeyIsUpdable=False PrimaryKeyIsAutoIncremented=True I get the following error: "Cannot create INSERT command because a business object with PrimaryKeyIsAutoIncremented = True must have exactly 1 primary key field." What else should I try?
	Reply Like 0
Lukasz Kustusz	Lukasz Kustusz posted 14 Years Ago Post Details Share Post
Group: Forum Members Posts: 29, Visits: 125	OK, never mind. I recreated the key to include only the identity field (the other two fields were redundant) and it all worked fine.
	Reply Like 0
Greg McGuffey	Greg McGuffey posted 14 Years Ago Post Details Share Post
Group: Forum Members Posts: 2K, Visits: 6.6K	Glad you got is working. There are times when I have both an identity field (which I make the PK as you ended up doing) and also another multi-field unique key, which is more business rule related. If this is the case, then I just make a unique index on the other key, which enforces the business rule at the DB level.
	Reply Like 0