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? Am I having bad observation skill or do I need a new 9.0 training? I look forward to early September in Baden
Gunnar Ekblad Kontema IT AB Hästholmsvägen 32 131 30 Nacka Sweden -----Ursprungligt meddelande----- Från: [email protected] [mailto:[email protected]] För A. Razzak Memon Skickat: den 6 juli 2009 16:42 Till: RBASE-L Mailing List Ämne: [RBASE-L] - Re: Duplicate records At 10:14 AM 7/6/2009, Bill Niehaus wrote: >I am trying to remember the syntax for finding duplicate >records in a table based on a specific column. > >Does someone recall the select command to do such a task? Bill, Did you know that you can use the "Duplicates ..." option to find the duplicates while browsing/editing the data in Data Browser/Editor? Here's how: 01. Start RBG76, RBG8, or RBG90 02. CONNECT RRBYW14, RRBYW15, or RRBYW16 03. Database Explorer | Tables ... 04. Double-click on the desired table to open Data Browser 05. Select/highlight the appropriate column 06. Right-click for speed menu and select Calculate ... Click on "Duplicates..." to find duplicates, if any. That's all there is to it! Very Best R:egards, Razzak.
