I would like to build some queries in my addin from layers in my map. I am having problems with double numeric types. esriFieldTypeDouble has 14 - 18 decimal places or more depending on the database type. That's what I get when I build a "Select by Attributes" but when using ArcObjects with .Net I only get 12 or less decimal places (System.Collections.IEnumerator) and although I can get 14 decimal places when I retrieve a value directly from iRow.value() ,converting this number to a string in any way rounds it to 12.
I am testing this on SHAPE.STLength() and SHAPE.STArea() fields (SQLServer EXPRESS) and well as SHape_Area, SHape_Length (FGDB) and the problem is that since the value actually has more than those 12 decimal places I am getting in code but the actual value has more the query will not work.
Building the query in the attribute table's "Select by Attributes" correctly displays ALL decimal places in the Unique values list
Attempting to build the same list with the same ArcObjects that are uses to obtain this list "under the hood" System.Collections.IEnumerator rounds those to 12 places.
Is this a VB .Net issue? Is there any way to get all the decimal places to string?