AnsweredAssumed Answered

Get unique values in Select by Attributes different than data

Question asked by Kcmuma on Mar 3, 2015
Latest reply on Mar 4, 2015 by jayanta.poddar

I have an oracle dataset with a Double column set to scale of 8 (don't know why it is set that way). Values that I can see in the data are 0.1, 0.35, 0.4, 0.65.  When I do a select by attribute and use the "get unique values" button, there is no 0.1. Instead I see in the list 0.10000000000000001. Which is more than a scale of 8.  If I choose this as the value to select by there is nothing in the selection. If I manually type in 0.1 instead of using the Get Unique Values button then the selection works, and selects the elements I expect it to select.

What is going on here!  I need to figure this out and fix it. My first thought is to set up a domain to constrain entry (don't know why there wasn't one already) . So far everything I have tried hasn't changed anything. This weird number persists in the Select by Attributes dialog when using the get Unique Values button.  I have never seen this before.

Anyone seen this and know how to get rid of this odd value and replace it with the correct one?

Outcomes