selectduplicatesnowarning
FORMULA

The selectduplicatesnowarning 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) before attempting to select duplicates.

This example selects records with duplicate check numbers.

field «Check#»
sortup
selectduplicatesnowarning ""

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

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

To verify that the data was sorted in the correct order, use the info(“selectduplicatesortwarning”) function. This function will return true if data was not sorted in the correct order. If this function is true, it is possible that not all duplicates will have been selected (duplicates are only selected if they are adjacent to each other in the database before the operation begins, hence the need for sorting).

selectduplicatesnowarning LastName+FirstName[1,1]
if info("selectduplicatesortwarning")
    message "Warning -- some duplicates may not have been selected"
endif

The selectduplicates statement is nearly identical to this statement, except that it automatically generates a user visible notification if the data is not sorted correctly.


See Also


History

VersionStatusNotes
10.1.001NewNew in this version.