selectduplicates
FORMULA

The selectduplicates statement selects records containing duplicate information in the database.


Parameters

This statement has one parameter:

formula – tells Panorama what data to check for duplicates. If the formula is empty ("") Panorama will check in the current field. If the formula is not empty the formula will build the data that is actually checked for duplicates. For example to look for records where both the first name and last name are duplicated, the formula would be FirstName+" "+LastName.


Description

This statement selects records containing duplicate information in the database. To work properly, the database must be sorted according to the formula used (see the examples below).

This example selects records with duplicate check numbers.

field «Check#»
sortup
selectduplicates ""

This example selects all records with duplicate names (both first and last name must be duplicated).

field LastName
sortup
field FirstName
sortupwithin
selectduplicates LastName+", "+FirstName

Error Messages

SelectDuplicate Error: Data is out of order, please sort the data and try again. – Before using the selectduplicates statement, you must sort the data to ensure that all of the duplicate data is adjacent. As this statement looks for duplicates, it checks to make sure that the data is sorted in the correct order. If it isn’t, you’ll see this error message. Make sure that the database is sorted in the correct order before searching for duplicates.


See Also


History

VersionStatusNotes
10.0No ChangeCarried over from Panorama 6.0.