NAME |
MAG KEY VALIDATE |
TAG |
KVAL |
ROUTINE |
MAGQBUT4 |
RETURN VALUE TYPE |
SINGLE VALUE |
AVAILABILITY |
RESTRICTED |
INACTIVE |
ACTIVE |
DESCRIPTION |
This is a an interface to the Database Server (DBS) utility:
Key Validator
The Key Validator extrinsic function verifies that new values contained
in the FDA do not produce an invalid key. All keys in which any field in
the FDA participates are checked. If the value for a field in a key being
checked is not present in the FDA, the value used to verify the key is
obtained from the previously filed data.
|
INPUT PARAMETER |
-
- FLAGS
- PARAMETER TYPE: LITERAL
- MAXIMUM DATA LENGTH: 9
- REQUIRED: NO
- SEQUENCE NUMBER: 1
- DESCRIPTION:
(Optional) Flags to control processing. The possible values are:
Q Quit when the first problem in the FDA is encountered.
-
- FDA
- PARAMETER TYPE: LIST
- MAXIMUM DATA LENGTH: 99
- REQUIRED: YES
- SEQUENCE NUMBER: 2
- DESCRIPTION:
The root of the FDA that contains the data to be checked. The array can
be a local or global one. See the Database Server Introduction for
details of the structure of the FDA.
The value of fields in the FDA must be the internal value. Do not pass
external (e.g., unresolved pointer values, non-FileMan dates) in the FDA.
No action is taken on fields in the referenced FDA if those fields do not
participate in a Key defined in the KEY file.
|
RETURN PARAMETER DESCRIPTION |
This Boolean function returns a 1 if key integrity is not violated by any
value in the FDA and a -1 followed by a carat delimiter and an error
message describing the nature of an invalid key that was produced by any
of the values.
740 A duplicate key is produced by a field's new value.
742 A value for a field in a key is being deleted.
744 Not all fields in a key have a value.
|