.11 (.11403)    INDEX (.11)

Name Value
FILE .11
NAME F
DESCRIPTION
The F index, is a whole file compound cross-reference on two fields in the
Cross-Reference Values multiple: File (#2) and Field (#3). It lets FileMan
identify the indexes that might be affected when a field value changes.
The checking of this index is an essential step during field level
transactions in building the list of record level cross-references that
must be fired after user-driven changes to the record are finished.
SHORT DESCRIPTION Lets FileMan find the indexes affected when a field changes
TYPE REGULAR
EXECUTION RECORD
ACTIVITY IR
USE LOOKUP & SORTING
ROOT TYPE WHOLE FILE
ROOT FILE .114
SET LOGIC S ^DD("IX","F",X(1),X(2),DA(1),DA)=""
CROSS-REFERENCE VALUES
  • ORDER NUMBER:   1
    SUBSCRIPT NUMBER:   1
    TYPE OF VALUE:   FIELD
    FILE:   .114
    FIELD:   2
  • ORDER NUMBER:   2
    SUBSCRIPT NUMBER:   2
    TYPE OF VALUE:   FIELD
    FILE:   .114
    FIELD:   3
KILL LOGIC K ^DD("IX","F",X(1),X(2),DA(1),DA)
KILL ENTIRE INDEX CODE K ^DD("IX","F")