Select by Attribute not returning values from long integer field

1735
2
Jump to solution
07-26-2016 12:30 AM
PieterHoltzhausen
New Contributor III

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.

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

0 Kudos
1 Solution

Accepted Solutions
NeilAyres
MVP Alum

A long int will indeed be able to store numbers into the billions.

Did you verify that serlect query when you are finding 300001? What did it say.

I see that your id field is indexed. Has something happened to that index? Trying dropping it and building it again.

View solution in original post

2 Replies
NeilAyres
MVP Alum

A long int will indeed be able to store numbers into the billions.

Did you verify that serlect query when you are finding 300001? What did it say.

I see that your id field is indexed. Has something happened to that index? Trying dropping it and building it again.

PieterHoltzhausen
New Contributor III

Thanks Neil for the prompt response,

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

0 Kudos