DevForce Community Forum : Modify Primary Key Value http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2009 : Modify Primary Key Value Tue, 28 Apr 2026 08:07:15 -700 Sun, 17 May 2009 17:43:50 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=1261 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Modify Primary Key Value : Arethere any plans to make Primary... http://www.ideablade.com/forum/forum_posts.asp?TID=1261&PID=4550#4550 Author: Markh
Subject: 1261
Posted: 17-May-2009 at 5:43pm

Are there any plans to make Primary Keys updatable within DevForce WinClient ?
 
 
]]> Sun, 17 May 2009 17:43:50 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1261&PID=4550#4550 Modify Primary Key Value : Well, now that I think about it,... http://www.ideablade.com/forum/forum_posts.asp?TID=1261&PID=4547#4547 Author: GregD
Subject: 1261
Posted: 15-May-2009 at 6:00pm

Well, now that I think about it, I can see how that would create a problem. We can only find the OrderDetail record we want to update in the database by its primary key value, but there's almost certainly no OrderDetail record that matches the primary key value that our local record now has.

With the database as designed, our only recourse is to create a new OrderDetail record (with the Product we want), copy other property values from the existing record, then delete the existing record.

One more reason why I personally avoid composite keys like the plague.

I'll change the Learning Unit solution to make the Product property read-only.

Greg Dunn
Training & Docs Mgr
]]> Fri, 15 May 2009 18:00:17 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1261&PID=4547#4547 Modify Primary Key Value : Just using the Learning Units\WinClient-Only\200... http://www.ideablade.com/forum/forum_posts.asp?TID=1261&PID=4541#4541 Author: Markh
Subject: 1261
Posted: 14-May-2009 at 11:03pm

Just using the Learning Units\WinClient-Only\200 Intermediate\Adding and Deleting Entities Example
When I change an order detail (ie Change the Product) and try to save the following exception occurs
 
A referential integrity constraint violation occurred: The property values that define the referential constraints are not consistent between principal and dependent objects in the relationship
 
Is this saying that once a primary key has been created you can not change any of the primary key values!
 
How can you change the OrderDetail to allow the Product to be changed ?
 
]]> Thu, 14 May 2009 23:03:11 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1261&PID=4541#4541