On 20 Jul 2006 19:49:09 -0000, [EMAIL PROTECTED]
<[EMAIL PROTECTED]> wrote:
Having a discussion with other developers and I found an index on a free table that was
UNIQUE. Perhaps it's left over from Fox 2.x days, but I'm trying to remember why I've
got this memory that it was a "no-no" and to be avoided? I'm trying to find a
copy of HackFox but thought I'd post here in the meanwhile...
tia!
--Michael
"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 index. There's no
mechanism to enforce uniqueness here, just a way to find one of each.
However, unique indexes are not properly maintained. If you delete a
record that's represented in the index, FoxPro does not add the next
record in the table that has the same key value. Don't ever use
"unique" indexes—there's always a better way to do it."
Hackers 7
A+
jml
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
** 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.
