Field Calculator does not work on fields with domain

4881
7
08-24-2012 09:00 AM
LeeMacholz
New Contributor
I am trying to update the values in a field that is controlled by a domain. The field calculator will not put ANY value into the target field regardless if it matches a valid value for the field. Then, after the field calculator fails on the domain-controlled field, it won't enter values for any other fields either until I stop the edit session and start a new edit session. I get no error message, it just simply doesn't do anything.

I am using an ArcInfo license in ArcGIS Desktop 10 SP4 on a personal geodatabase.
Tags (2)
0 Kudos
7 Replies
JeffAzevedo
New Contributor
Try some Quotes around the Domain entry.
0 Kudos
MarkYoung
Occasional Contributor
I had a similar issue. I had two Sde tables joined on [field1] which had a domain value. What I found was that a joined table will not let you edit data if that join is on any field which has a domain. Either join the table on an alternative field or remove the domain then try your edits. Almost as if the join expects an absolute/unique value instead of a choice of values perhaps..?
Mark
0 Kudos
PatrickKline
New Contributor
You could try to calculate the coded value as opposed to the descriptive value.

Patrick
0 Kudos
LeeMacholz
New Contributor
Thanks for the suggestions... Unfortunately still stumped. Adding quotes did not work, it is not a joined table, and I have tried both the coded value and the descriptive value.
0 Kudos
JeffAzevedo
New Contributor
I'm surprised the Quotes doesn't work. I generally don't use Personal FGD, but I created one for a test and it worked as I thought.

Could you try 'Selection' by 'attributes' and see how your domain reacts in the 'get unique values' part of the query.

Also I have seen problems field calculating while ArcCatalog & ArcMap are open at the same time.
0 Kudos
LarryJahn
Occasional Contributor
This is a little late, but you have to enter the domain code (e.g. AB) in quotations.  Trying to calculate by entering the domain description (e.g. As-Built) won't work.
0 Kudos
RobertBorchert
Frequent Contributor III
There is something else wrong in your system.

I do this quite often and it works without issue.

However, yes you should use the coded value and the the descriptive value.

Do this happen to all features or just this one?

You may simply need to rebuild the feature class and load data back into it to clear out the error.

Or you could select your features and then change the values en mass in the Attributes Window.
0 Kudos