Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Eliminating duplicates
Message
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00516123
Message ID:
00516359
Views:
10
>>>If you need to remove the entirely identical records then what is wrong with :
>>>
>>>select * dist into newtable
>>>then rename and reindex?
>>
>>That's an interesting idea. Few fields in the table should not be checked (RecNum is one for example). I can select into cursor, zap the original table and append from this cursor.
>>
>>I'll think about it.
>
>You would not be able to delete any records whose PK is referenced from another table if you have defined any persistent relations [RI]

Thanks, Mark. We don't have persistent relations, so we should be OK. I'm also thinking about doing this elimination at the prior step, so select distinct * would work. Originally I was thinking about doing it in De-Duper, that would be much harder.

Thanks to you and Yuri.
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform