[<<Previous Entry] [^^Up^^] [Next Entry>>] [Menu] [About The Guide]
SET UNIQUE

    SET UNIQUE determines whether all records with the same key value are
    included in the index file.

Syntax

    SET UNIQUE on/OFF/(<expL>)

Usage

    When you INDEX with UNIQUE ON, Clipper creates an index with uniqueness
    as an attribute.  As indexing proceeds and two or more records have the
    same key value, Clipper includes only the first record in the index.
    Whenever the unique index is updated, REINDEXed, or PACKed, only unique
    records are added.  This happens without regard to the current UNIQUE
    SETting.

    Note that this differs from previous versions of Clipper where UNIQUE
    was a global SETting and applied to the creation and updating of all
    open indexes.

See Also: FIND INDEX REINDEX SEEK SET INDEX USE
This page created by ng2html v1.05, the Norton guide to HTML conversion utility. Written by Dave Pearson