CANDIDATE()
Contents
Purpose
Function to determine whether an index tag is a candidate index tag.
Syntax
CANDIDATE([<expN1>][,<expN2> | <expC>])
See Also
ALIAS(), INDEX, SELECT(), SEQNO(), SET UNIQUE, SYNCNUM(), TAG(), TAGCOUNT(), TAGNO(), UNIQUE()
Description
The CANDIDATE() function is used to determine whether an index tag is a candidate index tag. The number of the index tag to be examined can optionally be specified in <expN1>. If <expN1> is not specified, the CANDIDATE() function will operate on the master index tag of the currently active table. If the tag number, <expN1>, is specified, the CANDIDATE() function can be used on tables other than the currently active table by specifying either the relevant workarea number, <expN2>, or the alias name of the table, <expC>.
NOTE: A candidate index tag is an index tag that is a likely candidate to become the primary index tag as it does not contain any null or duplicate values, having been built with the UNIQUE keyword or with set unique on.
Example
if tagcount() > 0 for i = 1 to tagcount() ? "Candidate status for " + tag(i) + " is " + ltos(candidate(i)) next endif