CDO$HELP.HLB  —  CDO Commands, CHANGE  RECORD Command, Parameters

1  –  record-name

    Specifies the record element you are modifying.

2  –  text

    Modifies information. Within the DESCRIPTION clause, this is
    information documenting the record; within the AUDIT clause, it
    is a history list entry. Valid delimiters are /* */ or double
    quotation marks (" ").

    You can use Japanese to document comments in the DESCRIPTION or
    AUDIT clause for a field. To do this, use the SET CHARACTER_SET
    command, and set the character_set of the session to DEC_KANJI.

3  –  constraint-clause

    Adds a condition, known as a constraint, that affects adding or
    modifying data in a database table (record). Supported constraint
    types are NOT NULL, PRIMARY KEY, FOREIGN KEY, UNIQUE, and CHECK.

    Each constraint can be named and supplied with evaluation
    attributes DEFERRABLE or NOT DEFERRABLE. The default evaluation
    time for constraints in CDO is NOT DEFERRABLE (the constraint
    is evaluated at statement time). For more information, see the
    DEFINE RECORD_Constraint command.

4  –  constr-name

    Specifies the name of a constraint.

5  –  record-property

    Changes the value of an existing property or adds a new property
    in record, structure, variants, and variant definitions within
    a record element. You specify removal with the NO keyword. See
    rec-properties for the record properties CDO provides.

6  –  name

    Specifies the name of a record, structure, or field that you want
    to delete from the record.

7  –  included-name-change-clause

    Allows you to change existing field and record definitions within
    record elements. For more information, see the CHANGE
    RECORD_Included_Name_Change command.

8  –  local-field-clause

    Specifies the definition of the locally defined field. For more
    information, see the DEFINE RECORD_Local_Field command.

9  –  record-change-clause

    Adds field, record, structure, variants, and variant definitions
    within an existing record definition. For more information, see
    the CHANGE RECORD_Record_Change command.

10  –  structure-change-clause

    Allows you to change a structure definition within a record
    element. For more information, see the CHANGE
    RECORD_Structure_Change command.

11  –  variants-change-clause

    Allows you to change a variant definition, which is a set of
    two or more definitions that map to the same portion of a record
    element. For more information, see the CHANGE
    RECORD_Variants_Change command.
Close Help