Check the wiki for comments on unique indexes. I don't know if this 100% describes your problem but it or some variation might be causing the results you're getting.
http://fox.wikis.com/wc.dll?Wiki~VFPMisusedAndAbused rk -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Ken Kixmoeller f/h Sent: Monday, March 08, 2010 1:33 AM To: [email protected] Subject: Re: Unique Indexes = "not so much" That is exactly what I was trying to do -- use it in the old-fashioned way. I was de-dupping a non-normalized table. (The old database had addresses -- the same addresses -- in 3 places -- I'm trying to eliminate the dups and create new PKs for the new tables. Yes, I know what "unique" means in a FP context -- it isn't a primary or candidate key. But f you look at my note again, it was *not* always selecting the "first instance of an index and skip the other records" -- it selected #91 and #93, but it skipped right over #92. I just wondered if anyone else had experienced such a strange behavior. OTOH, probably nobody (else) uses those old techniques any more. Ken _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/df1eef11e586a64fb54a97f22a8bd044066e9cf...@ackbwddqh1.artfact.local ** 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.
