Re: Index on collector tag collector unique

2016-11-28 Thread Michael Madigan
m" Sent: Monday, November 28, 2016 3:46 PM Subject: Re: Index on collector tag collector unique 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 thin

Re: Index on collector tag collector unique

2016-11-28 Thread Ted Roche
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

RE: Index on collector tag collector unique

2007-01-18 Thread Stephen the Cook
Michael Madigan <> wrote: > Yep, you're right, I should have a collector database. > This was a band-aid added quick and dirty. Turned out to be too > dirty. Why not create it via a select distinct into a table and then just normalize your data? Probably a lot of work after you hit all your in

Re: Index on collector tag collector unique

2007-01-17 Thread Michael Madigan
Yep, you're right, I should have a collector database. This was a band-aid added quick and dirty. Turned out to be too dirty. --- Eugene Vital <[EMAIL PROTECTED]> wrote: > Michael Madigan wrote: > > OK, so I have a client database and on that > database I > > have a collector ID. I have a ta

Re: Index on collector tag collector unique

2007-01-17 Thread Eugene Vital
Michael Madigan wrote: > OK, so I have a client database and on that database I > have a collector ID. I have a tag in the compound > index that is created by > > "index on collector tag collector unique". > > This gives me a list of unique collectors using the > system, each one assigned to on

RE: Index on collector tag collector unique

2007-01-17 Thread Rick Schummer
Wednesday, January 17, 2007 04:00 PM To: [EMAIL PROTECTED] Subject: RE: Index on collector tag collector unique Thanks. What do you mean by "candidate"? ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mai

Re: Index on collector tag collector unique

2007-01-17 Thread MB Software Solutions
MB Software Solutions wrote: > Michael Madigan wrote: > >> Thanks. What do you mean by "candidate"? >> >> >> > Same as a Primary index, meaning that the values in that field > (combination) are all unique, i.e., without duplicates, but that it is > not the primary index (because somet

Re: Index on collector tag collector unique

2007-01-17 Thread MB Software Solutions
Michael Madigan wrote: > Thanks. What do you mean by "candidate"? > > Same as a Primary index, meaning that the values in that field (combination) are all unique, i.e., without duplicates, but that it is not the primary index (because something else is generally). -- Michael J. Babcock, MC

RE: Index on collector tag collector unique

2007-01-17 Thread Michael Madigan
Thanks. What do you mean by "candidate"? --- Rick Schummer <[EMAIL PROTECTED]> wrote: > Unique indexes are bad and the behavior you are > observing is how they are designed. Direct from > HackFox: > > "A so-called unique index contains a key only for > the first record that has a particular k

RE: Index on collector tag collector unique

2007-01-17 Thread Rick Schummer
Unique indexes are bad and the behavior you are observing is how they are designed. Direct from HackFox: "A so-called unique index contains a key only for the first record that has a particular key value. That is, once a key value occurs, no other records with that key value get added to the in