Locking the identifying fields

Posts   
 
    
llbluser
User
Posts: 2
Joined: 21-Jul-2011
# Posted on: 21-Jul-2011 16:09:37   

I have changed the identifying fields for an entity in the designer (v3.1). But every time I refresh relational model data from the database the identifying fields get reset with the following message in the refresh results window: "The field 'entityfield' is no longer part of the identifying fields."

Is there any way to lock the identifying fields in the designer, so that I don't have to change it every time I refresh the DB?

MTrinder
User
Posts: 1461
Joined: 08-Oct-2008
# Posted on: 21-Jul-2011 18:55:58   

Why are you changing the identifing field in the designer without reflecting the change back into the database ? The behaviour you are seeing is by design - if you change the model in the designer this change needs to be moved back to the database.

Matt

llbluser
User
Posts: 2
Joined: 21-Jul-2011
# Posted on: 21-Jul-2011 19:21:27   

Thanks for the quick response, Matt. Unfortunately I am working with a legacy table, and other [legacy] teams and applications are using it.. No worries, guess I'll take the pain till other teams catch up with ORMs..