Attrib_ID conv_string value?

[Kris R.]

For getting the "definition" of an attrib_ID (in msp_field_attributes), I am
doing this:

select @Conv_String = conv_string from msp_Conversions where conv_value =
@Attrib_ID

This usually works, returning things like "field Alias" for attrib_ID = 206,
"roll up type" for 215, etc.

But, several of my enterprise fields have an attrib_ID of 223, which is NOT
in the MSP_conversions table!

What the heck does it represent, and how do I find it?

Thanks,
Kris R.

 

[JackD]

For getting the "definition" of an attrib_ID (in msp_field_attributes), I am
doing this:

select @Conv_String = conv_string from msp_Conversions where conv_value =
@Attrib_ID

This usually works, returning things like "field Alias" for attrib_ID = 206,
"roll up type" for 215, etc.

But, several of my enterprise fields have an attrib_ID of 223, which is NOT
in the MSP_conversions table!

What the heck does it represent, and how do I find it?

Thanks,
Kris R.

MSP_FIELD_ATTRIBUTES.ATTRIB_FIELD_ID has to be in your query somewhere. It
determines whether you look in MSP_CONVERSIONS or MSP_STRING_TYPES for the
value.

Did you carefully read PROJDB.htm? If not, take a closer look at it.

-Jack Dahlgren

 

[Kris R.]

OK, thanks - I that must be what I'm missing.

I've looked at ProjDB.htm, but obviously not close enough! ;-)

Kris

 

[JackD]

It takes about 5 readings...
If I were working with the database I'd print it out and have it by my desk.

-Jack