Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Unique Index no longer PC
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00561396
Message ID:
00561445
Views:
21
Hi Chuck

>Are you using unique indexes? I have to say I haven't used one in my 7+ years of using FoxPro and VFP.

The only reason I use unique indexes is to remove dublicates from the table and it doesn't matter which of the dublicates remain.

1. Create a (temporary) unique index on the expression that should be unique.
2. Delete all records and recall only the record that are used in the unique index.
3. Drop the unique index

Regards,
Frank Camp
Previous
Reply
Map
View

Click here to load this message in the networking platform