topic codevaluedomain stored in the DBMS but didn't appear in the attribute table in arcmap in Data Management Questions

codevaluedomain stored in the DBMS but didn't appear in the attribute table in arcmap

ben_abdallahmhd — Tue, 02 Aug 2011 07:21:03 GMT

good morning

i have this problem:
i have designed a table that contain CodedValueDomain with UML and and I implement it in sqlserver
when i would work with this table in arcmap the list o value in the CodeValueDomain not appear.

Some idea please

thank you

Re: codevaluedomain stored in the DBMS but didn't appear in the attribute table in ar

CraigGillgrass — Tue, 02 Aug 2011 11:47:45 GMT

A few questions:
- What release of ArcGIS are you using?
- Do the Coded Value Domains appear when you look at the domain in ArcCatalog?

Re: codevaluedomain stored in the DBMS but didn't appear in the attribute table in ar

ben_abdallahmhd — Wed, 03 Aug 2011 07:15:52 GMT

good morning
thankyou cgillgrass
i use arcgis10
yes the the Coded Value Domains appear when you look at the domain in ArcCatalog

Re: codevaluedomain stored in the DBMS but didn't appear in the attribute table in ar

CraigGillgrass — Wed, 03 Aug 2011 11:35:47 GMT

Can you confirm that the domain is associated with correct field by checking the Field tab on the Feature Class or Table property page? Can you also confirm that the field type and domain's field type
match?

Re: codevaluedomain stored in the DBMS but didn't appear in the attribute table in ar

ben_abdallahmhd — Thu, 04 Aug 2011 08:33:03 GMT

Good morning cgillgrass

No the domain is not associated with the field. the field type is long and the domain field type is entier long

When i verify the list of coded value domain in the database with the tool 'Domain Sort' the domain appear.

Re: codevaluedomain stored in the DBMS but didn't appear in the attribute table in ar

CraigGillgrass — Thu, 04 Aug 2011 11:16:37 GMT

No the domain is not associated with the field. the field type is long and the domain field type is entier long

When i verify the list of coded value domain in the database with the tool 'Domain Sort' the domain appear.

In order for the domain to appear in ArcMap, it needs to be associated with the field. Can you try manually associating the domain with the field in ArcCatalog and test if that allows you to see the domain dropdown in ArcMap?

Re: codevaluedomain stored in the DBMS but didn't appear in the attribute table in ar

ben_abdallahmhd — Thu, 04 Aug 2011 11:39:42 GMT

re good morning
i tried manually associating the domain with the field in ArcCatalog but in the dropdown list of doamin didn't work it's locked so i can't associate the field with the domain.

note i have implemented the geodatabase in the DBMS (sqlqerver) with CASETOOl
Thank you

Re: codevaluedomain stored in the DBMS but didn't appear in the attribute table in ar

CraigGillgrass — Thu, 04 Aug 2011 16:28:18 GMT

re good morning
i tried manually associating the domain with the field in ArcCatalog but in the dropdown list of doamin didn't work it's locked so i can't associate the field with the domain.

note i have implemented the geodatabase in the DBMS (sqlqerver) with CASETOOl
Thank you

Can you clarify what is locked? Is it the feature class?

Re: codevaluedomain stored in the DBMS but didn't appear in the attribute table in ar

ben_abdallahmhd — Fri, 05 Aug 2011 07:25:13 GMT

good morning cgillgrass

"" i tried manually associating the domain with the field in ArcCatalog but in the dropdown list of doamin didn't work it's locked"" :

I mean that in the tab field the list of domain didn't appear

is it clear 🙂

thank you

Re: codevaluedomain stored in the DBMS but didn't appear in the attribute table in ar

CraigGillgrass — Fri, 05 Aug 2011 17:31:13 GMT

I'm afraid at this point I can't suggest anything else without looking at your database. Please contact Technical Support so they can help you investigate this issue.

Re: codevaluedomain stored in the DBMS but didn't appear in the attribute table in ar

ben_abdallahmhd — Mon, 08 Aug 2011 07:47:02 GMT

Thank you very much cgillgrass

Re: codevaluedomain stored in the DBMS but didn't appear in the attribute table in ar

ben_abdallahmhd — Thu, 18 Aug 2011 11:20:21 GMT

good morning

"In order for the domain to appear in ArcMap, it needs to be associated with the field. Can you try manually associating the domain with the field in ArcCatalog and test if that allows you to see the domain dropdown in ArcMap? "

yes i tried associate it manually and it work.

but it didn't work on the table having subtypefield.

thank you

Re: codevaluedomain stored in the DBMS but didn't appear in the attribute table in ar

CraigGillgrass — Thu, 18 Aug 2011 12:07:25 GMT

yes i tried associate it manually and it work.

but it didn't work on the table having subtypefield.

Once you have subtypes defined, you need to make the field and domain associations on the Subtype tab.

Re: codevaluedomain stored in the DBMS but didn't appear in the attribute table in ar

ben_abdallahmhd — Wed, 24 Aug 2011 07:40:13 GMT

thank you Craig Gillgrass for your help