Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Deletion of Duplicate Records
Message
From
31/10/2000 10:06:42
 
 
To
30/10/2000 22:40:01
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00435962
Message ID:
00436353
Views:
18
The changes are not necessary :(, I confused myself.

>mea culpa!
>
>
><b>set deleted on</b>
>use table in 0
>use table again alias dupes in 0
>select dupes
>set order to primarykey
>select table
>set relation to primarykey into dupes
><b>set skip to dupes</b>
>delete for recno() != recno("dupes")
>set relation to
>use in dupes
>
Previous
Reply
Map
View

Click here to load this message in the networking platform