How to set a domain for a field

Question

I am working on a code that programmatically creates a file geodb schema. I can create domains and tables using appropriate methods, but I cannot find any sample how to set a domain for a field. According to the geodb XSD, the Domain element should be of type Domain, but if I insert an XML string with a domain definition (which is ok as I can use it to create a domain) I get an XML exception and CreateTable method fails.

Could you please let me know how to set a field domain?

Thanks,
Dejan

LanceShipman · Answer

You were not able to add a domain to fields on a table created with the File Geodatabase API (NIM074135). This has been fixed in the 1.2 release, which will be available this week. With alter field working correctly you can add a domain to a field in one step and the API is operating as designed. NIM072315 is an enhancement. With the current design you can add domains to fields. NIM072315 just changes the way you have to code this.

NIM074135 slipped through because our test used an existing feature class. We have corrected this test to create the test table.

LanceShipman · Answer

An example was included in the Domains sample in the file geodatabase 1.1 release. You assign a domain to a field via table.AlterField. It is not currently possible to add a domain on table creation.

I've added an enhancement (NIM072315) to allow the association of a domain on AddField and on CreateTable.

PaulAustin · Answer

I would also like to see an example. I have tried to include a copy of the full Domain definition in the Field that I want to attach the domain to. Here is the XML table definition that I create the table using (no errors returned). \ADDRESS_RANGE ADDRESS_RANGE esriDTTable 1 false false true OBJECTID OBJECTID esriFieldTypeOID false 4 0 0 true false OBJECTID OBJECTID HOUSE_NUMBER_STRUCTURE_CODE_ID esriFieldTypeSmallInteger true 2 0 0 true HOUSE_NUMBER_STRUCTURE_CODE_ID HOUSE_NUMBER_STRUCTURE_CODE_ID HOUSE_NUMBER_STRUCTURE_CODE esriFieldTypeSmallInteger esriMPTDefaultValue esriSPTDuplicate Center 1 Even 2 Hypothetical 3 None 4 Odd 5 Special 6 FDO_OBJECTID true true OBJECTID esriFieldTypeOID false 4 0 0 true false OBJECTID OBJECTID {7A566981-C114-11D2-8A28-006097AFF44E} ADDRESS_RANGE false When I get the table definition back it is missing the xsi:type="esri:CodedValueDomain" attribute on the domain for the field. This then causes it not to be shown when you look at the field's domain in ArcCatalog. If you try and select the domain it tells you there is already an association with that domain. \ADDRESS_RANGE ADDRESS_RANGE esriDTTable 22 false false true OBJECTID OBJECTID esriFieldTypeOID false 4 0 0 true false OBJECTID OBJECTID HOUSE_NUMBER_STRUCTURE_CODE_ID esriFieldTypeSmallInteger true 2 0 0 HOUSE_NUMBER_STRUCTURE_CODE_ID HOUSE_NUMBER_STRUCTURE_CODE_ID HOUSE_NUMBER_STRUCTURE_CODE esriFieldTypeSmallInteger esriMPTDefaultValue esriSPTDuplicate Center 1 Even 2 Hypothetical 3 None 4 Odd 5 Special 6 FDO_OBJECTID true true OBJECTID esriFieldTypeOID false 4 0 0 true false OBJECTID OBJECTID {7A566981-C114-11D2-8A28-006097AFF44E} ADDRESS_RANGE false