topic Re: Select by Attribute not returning values from long integer field in Data Management Questions https://community.esri.com/t5/data-management-questions/select-by-attribute-not-returning-values-from-long/m-p/701642#M39828 <HTML><HEAD></HEAD><BODY><P>A long int will indeed be able to store numbers into the billions.</P><P>Did you verify that serlect query when you are finding 300001? What did it say.</P><P>I see that your id field is indexed. Has something happened to that index? Trying dropping it and building it again.</P></BODY></HTML> Tue, 26 Jul 2016 07:41:58 GMT NeilAyres 2016-07-26T07:41:58Z Select by Attribute not returning values from long integer field https://community.esri.com/t5/data-management-questions/select-by-attribute-not-returning-values-from-long/m-p/701641#M39827 <HTML><HEAD></HEAD><BODY><P>I have a arcgis 10.3 file geodatabase feature class with 349 770 records. My ID field is of type LONG and contains values from 1 to 500 000. The strange thing is that when I do a Select by attribute on this field from arcmap 10.3, I can select any value lower or equal to 300 000, as soon as search for a value larger than 300 000, I don't get a result. </P><P>What is going on? The whole number limit should be in the millions, shouldnt it? Has anyone seen this bug before? PLEASE assist. see attached screenshots</P></BODY></HTML> Tue, 26 Jul 2016 07:30:18 GMT https://community.esri.com/t5/data-management-questions/select-by-attribute-not-returning-values-from-long/m-p/701641#M39827 PieterHoltzhausen 2016-07-26T07:30:18Z Re: Select by Attribute not returning values from long integer field https://community.esri.com/t5/data-management-questions/select-by-attribute-not-returning-values-from-long/m-p/701642#M39828 <HTML><HEAD></HEAD><BODY><P>A long int will indeed be able to store numbers into the billions.</P><P>Did you verify that serlect query when you are finding 300001? What did it say.</P><P>I see that your id field is indexed. Has something happened to that index? Trying dropping it and building it again.</P></BODY></HTML> Tue, 26 Jul 2016 07:41:58 GMT https://community.esri.com/t5/data-management-questions/select-by-attribute-not-returning-values-from-long/m-p/701642#M39828 NeilAyres 2016-07-26T07:41:58Z Re: Select by Attribute not returning values from long integer field https://community.esri.com/t5/data-management-questions/select-by-attribute-not-returning-values-from-long/m-p/701643#M39829 <HTML><HEAD></HEAD><BODY><P>Thanks Neil for the prompt response,</P><P>It seems it was indeed the Index that was causing the problem. It was an ascending index. When I added the new index, I wasn't able to add it as an ascending Index, but adding a normal index here did the trick. Thanks for the suggestion</P></BODY></HTML> Tue, 26 Jul 2016 08:10:20 GMT https://community.esri.com/t5/data-management-questions/select-by-attribute-not-returning-values-from-long/m-p/701643#M39829 PieterHoltzhausen 2016-07-26T08:10:20Z