Pretty weird. That's a bug. Or perhaps a corruption in the existing indexes.
SELECT DISTINCT collector in MyTable ORDER BY collector INTO CURSOR YourCursor can give you the same thing, real quick if you already have an index tag on collector, and even if you don't. On Mon, Nov 28, 2016 at 3:30 PM, Michael Madigan <mmadi10...@yahoo.com> wrote: > Strange behavior I've never seen before > I have a 3 character field called collector. I have many records with > collector= '31' . When I index using the command "Index on collector tag > collector unique" I get every one except collector 31. I get collector 3, > I get collector 30, but I don't get collector 31. There are over 2000 > records with collector = '31' > > I realize you have to reindex every time to make sure you have every > collector accounted for, so it's not that > > This is really odd. > > --- StripMime Report -- processed MIME parts --- > multipart/alternative > text/plain (text body -- kept) > text/html > --- > [excessive quoting removed by server] _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CACW6n4tjJ2scWrT9cavOh9a7Ngsqs=lk_ymv98cnkafjter...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
