topic SQL query builder shows strange double values in ArcGIS Pro Questions https://community.esri.com/t5/arcgis-pro-questions/sql-query-builder-shows-strange-double-values/m-p/330965#M14439 <HTML><HEAD></HEAD><BODY><P>I'm trying to perform a select by attribute in ArcGIS Pro on a field of type double. The problem I have is that there are strange values in the list of possible values. Ex: rather than showing 60.3, the list of possible values contains 60.300000000000004. Of course, if a try the select with this strange value, I get no results.</P><P><IMG __jive_id="488994" alt="" class="jive-emoji image-1 jive-image" height="432" src="https://community.esri.com/legacyfs/online/488994_whereClause.png" width="396" /></P><P></P><P>I looked into the attribute table and the value is really 60.3. I even looked into my Oracle tables directly and found that the stored value is also 60.3. So everything seems fine, on the data side.</P><P></P><P>The only way to make the select work is to switch to the SQL view and manually type in 60.3.</P><P><IMG __jive_id="488995" alt="" class="jive-emoji jive-image image-2 j-img-original" src="https://community.esri.com/legacyfs/online/488995_whereClause_SQL.png" /></P><P></P><P>Any idea what could be wrong with the SQL query builder?</P></BODY></HTML> Thu, 16 Apr 2020 22:32:16 GMT PatrickCote 2020-04-16T22:32:16Z SQL query builder shows strange double values https://community.esri.com/t5/arcgis-pro-questions/sql-query-builder-shows-strange-double-values/m-p/330965#M14439 <HTML><HEAD></HEAD><BODY><P>I'm trying to perform a select by attribute in ArcGIS Pro on a field of type double. The problem I have is that there are strange values in the list of possible values. Ex: rather than showing 60.3, the list of possible values contains 60.300000000000004. Of course, if a try the select with this strange value, I get no results.</P><P><IMG __jive_id="488994" alt="" class="jive-emoji image-1 jive-image" height="432" src="https://community.esri.com/legacyfs/online/488994_whereClause.png" width="396" /></P><P></P><P>I looked into the attribute table and the value is really 60.3. I even looked into my Oracle tables directly and found that the stored value is also 60.3. So everything seems fine, on the data side.</P><P></P><P>The only way to make the select work is to switch to the SQL view and manually type in 60.3.</P><P><IMG __jive_id="488995" alt="" class="jive-emoji jive-image image-2 j-img-original" src="https://community.esri.com/legacyfs/online/488995_whereClause_SQL.png" /></P><P></P><P>Any idea what could be wrong with the SQL query builder?</P></BODY></HTML> Thu, 16 Apr 2020 22:32:16 GMT https://community.esri.com/t5/arcgis-pro-questions/sql-query-builder-shows-strange-double-values/m-p/330965#M14439 PatrickCote 2020-04-16T22:32:16Z Re: Test question https://community.esri.com/t5/arcgis-pro-questions/sql-query-builder-shows-strange-double-values/m-p/330966#M14440 <HTML><HEAD></HEAD><BODY><P>Yes?!&nbsp; How many we help?</P><P>Test successful!</P></BODY></HTML> Thu, 16 Apr 2020 22:34:44 GMT https://community.esri.com/t5/arcgis-pro-questions/sql-query-builder-shows-strange-double-values/m-p/330966#M14440 KoryKramer 2020-04-16T22:34:44Z