I think there is also a "delete duplicates" command that was implemented way back in the day. Delete duplicates from tablename (using columnlist) I have used this on occasion and found it very useful. On a large DB make sure the columns you specify are indexed or it will take forever.
Robert M. Castanaro Director, Surgical Services, Clinic and Pain Services Summa Health System Barberton Hospital 155 Fifth Street N.E. Barberton, Ohio 44203 Phone 330-615-3627 [email protected] [cid:[email protected]] From: [email protected] [mailto:[email protected]] On Behalf Of Bill Niehaus Sent: Monday, July 06, 2009 12:23 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Duplicate records I didn't recall seeing that in the menu before. Very handy. Thanks for the other tips on finding duplicates. Bill >>> Doug Hamilton <[email protected]> 7/6/2009 11:01 AM >>> Gunnar, that's two of us. :) It's a great feature. Doug A. Razzak Memon wrote: > At 11:08 AM 7/6/2009, Gunnar Ekblad wrote: > >> Thank You Razzak >> Before I was aware of tally >> Now I am also aware of duplicates >> I am just curios for how long I have missed this nice feature? > > > Gunnar, > > The requested enhancement was implemented on April 20, 2009 with > the official Update 7 (Build: 7.6.7.30420) of R:BASE 7.6, and > Update 21 (Build: 8.0.21.30420) of R:BASE Turbo V-8 for Windows. > > >> Am I having bad observation skill or do I need a new 9.0 training? >> I look forward to early September in Baden > > > I am looking forward to it! http://www.rbase.ch/ > > Very Best R:egards, > > Razzak. > > >
