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
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
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
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
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
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
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
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
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
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
10 matches
Mail list logo