Forum: Visual Basic 4 / 5 / 6 Jun 16th, 2008 |
| Replies: 4 Views: 726 Please check if the dbms supports grouping for the datatype that is used for the fingerprint column.
If it does not and there is a key in the table to identify each record, ýou may use two loops,... |
Forum: Visual Basic 4 / 5 / 6 Jun 12th, 2008 |
| Replies: 4 Views: 726 You could use a SQL statement with a GROUP BY ... HAVING clause.
Group the records by the columns that are relevant for "equality". Use HAVING COUNT(*) > 1 to return only those groups that have more... |