At 04:12 PM 11/27/2014, Dr. Fritz Luettgens wrote:
Are there Getproperty commands to show all Duplicates in TabA in ColTXT as a result?
Fritz, DB Grid or Enhanced DB Grid controls are not designed nor intended to show duplicate rows in demand. Thus, no such thing. However, there are two approaches to accomplish such task at hand: Approach #1: If you only need to display duplicate rows in DB Grid or Enhanced DB Grid, use the following WHERE clause to achieve your goal. EDIT USING formname WHERE DBGrid colname IN + (SELECT colname FROM tablename GROUP BY colname HAVING COUNT(*) > 1) This will provide you with rows based on the SELECT clause above. Approach #2: Use the Database Explorer | Tables | Right-Click | Open Table Select the appropriate column | Right-Click | Calculate | Duplicates That will provide you with a list of duplicates based on selected column. Denken Sie daran, es gibt viele Möglichkeiten, um jede Aufgabe zu erfüllen! Very Best R:egards, Razzak www.rbase.com www.facebook.com/rbase -- 31 years of continuous innovation! 16 Years of R:BASE Technologies, Inc. making R:BASE what it is today! --
