Ken, >> Using old-fashioned Fox, I do the expedient thing and create a unique index on *just that value* spin through the table, and populate the new structures.<<
When you note "unique" indexes I have to think you are referring to the old 2.6 concept of unique indexes, not primary or candidate keys. It is by design and documented that the old unique indexes only record the first instance of an index and skip the other records that eventually are duplicates. FoxPro unique indexes are not. Rick White Light Computing, Inc. www.whitelightcomputing.com www.swfox.net www.rickschummer.com _______________________________________________ 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/005b01cabe70$4042e1a0$c0c8a4...@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.
