.312 (.31203)    INDEX (.11)

Name Value
FILE .312
NAME S
DESCRIPTION
The S index, a compound index on all fields of the Fields multiple of the
Key file, lets FileMan step through the key fields in sequence. This is
essential for prompting, returning values, as well as for the generation
of each key's uniqueness index.
SHORT DESCRIPTION Lets FileMan step through Key fields in sequence
TYPE REGULAR
EXECUTION RECORD
ACTIVITY IR
USE LOOKUP & SORTING
ROOT TYPE INDEX FILE
ROOT FILE .312
SET LOGIC S ^DD("KEY",DA(1),2,"S",X(1),X(2),X(3),DA)=""
CROSS-REFERENCE VALUES
  • ORDER NUMBER:   1
    SUBSCRIPT NUMBER:   1
    TYPE OF VALUE:   FIELD
    FILE:   .312
    FIELD:   1
  • ORDER NUMBER:   2
    SUBSCRIPT NUMBER:   2
    TYPE OF VALUE:   FIELD
    FILE:   .312
    FIELD:   .01
  • ORDER NUMBER:   3
    SUBSCRIPT NUMBER:   3
    TYPE OF VALUE:   FIELD
    FILE:   .312
    FIELD:   .02
KILL LOGIC K ^DD("KEY",DA(1),2,"S",X(1),X(2),X(3),DA)
KILL ENTIRE INDEX CODE K ^DD("KEY",DA(1),2,"S")