Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Removing double records, math problem
Message
From
15/06/2007 15:10:13
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01233421
Message ID:
01233625
Views:
11
>Edward,
>
>I think the problem is that you might run out of records to delete from the latter tables, maybe the process should start with the tables ordered by the number of records to delete to minimize this.
>
>Ex. (r records and d records to delete)
>
>T1: 500r 30d
>T2: 100r 10d
>T3: 111r 3d && You might already run out of duplicates to delete from this table

Btw, you cannot run out of deletions completely, because the process starts with calculating how many records should be deleted in all tables together. So it might happen that the last table will get too many deletions, but never too less.
Edward Pikman
Independent Consultant
Previous
Reply
Map
View

Click here to load this message in the networking platform