New topic: Clearing out similar records?
<http://forums.realsoftware.com/viewtopic.php?t=32199> Page 1 of 1 [ 3 posts ] Previous topic | Next topic Author Message Cartwright Post subject: Clearing out similar records?Posted: Tue Jan 26, 2010 7:45 pm Joined: Fri Oct 28, 2005 1:03 pm Posts: 221 I have a database with a few thousand records. Some of these are duplicative, with the exception of a different rowID. Is there any easy way to sort through the records and delete those that are essentially the same? Thanks. _________________ RB2008r1 on Windows XP Top npalardy Post subject: Re: Clearing out similar records?Posted: Tue Jan 26, 2010 9:37 pm Joined: Sat Dec 24, 2005 8:18 pm Posts: 5591 Location: Canada, Alberta, Near Red Deer probably the quickest is to pull out all the distinct records into a temporary table, clean out the original table, put the distinct ones back in to the original _________________ My web site Great White Software RBLibrary.com REALbasic learning Top brisance Post subject: Re: Clearing out similar records?Posted: Tue Jan 26, 2010 9:39 pm Joined: Tue Oct 06, 2009 2:38 am Posts: 126 Probably use a SELECT DISTINCT. But if you're inserting duplicate rows that means you may have a problem in the database design. _________________ HOWTO: RB Feedback Utility Top Display posts from previous: All posts1 day7 days2 weeks1 month3 months6 months1 year Sort by AuthorPost timeSubject AscendingDescending Page 1 of 1 [ 3 posts ] -- Over 1500 classes with 29000 functions in one REALbasic plug-in collection. The Monkeybread Software Realbasic Plugin v9.3. http://www.monkeybreadsoftware.de/realbasic/plugins.shtml [email protected]
