$UnqRec: Difference between revisions

From m204wiki
Jump to navigation Jump to search
(Automatically generated page update)
 
m (Mlarocca moved page $UNQREC to $UnqRec: Lower case change)
 
(No difference)

Latest revision as of 15:28, 31 July 2014

The $UNQREC function is used in conjunction with the ON FIELD CONSTRAINT CONFLICT unit and the UNIQUE field attribute.

If $UNQREC is invoked from an ON FCC unit following the detection of a uniqueness violation, it returns the record number of the record already containing the field name = value pair. At all other times, $UNQREC returns -1.

Use $UNQREC in conjunction with $UPDREC to find the record number of the unique record already stored ($UNQREC) and the record number of the non-unique record you are attempting to store ($UPDREC). The $UNQREC function takes no arguments.