User Tools

Site Tools


dup_allow_duplicate_key_entries_.htm
Navigation:  Language Reference > 5 - Declaration Attributes > Variable and Entity Attributes >====== DUP (allow duplicate KEY entries) ====== Previous pageReturn to chapter overviewNext page

DUP

blk2blue.jpg

The DUP attribute (PROP:DUP) of a KEY declaration allows multiple records with the same key values to occur in a FILE. If the DUP attribute is omitted, attempting to ADD or PUT records with duplicate key values will generate the “Creates Duplicate Key” error, and the record will not be written to the file. During sequential processing using the KEY, records with duplicate key values are accessed in the physical order their entries appear in the KEY. The GET and SET statements generally access the first record in a set of duplicates.

The DUP attribute is unnecessary on INDEX declarations because an INDEX always allows duplicate entries.

Example:

Names   FILE,DRIVER('Clarion'),PRE(Nam)

NameKey  KEY(Nam:Name),DUP       !Declare name key, allow duplicate names

NbrKey   KEY(Nam:Number)         !Declare number key, no duplicates allowed

Rec      RECORD

Name      STRING(20)

Number    SHORT

        END

       END

See Also:

KEY

GET

SET

dup_allow_duplicate_key_entries_.htm.txt · Last modified: 2021/04/15 15:57 (external edit)