|
|
|
|
|
- "Null" value supported in key items
NullableIndex (Property) In french: NullIndexé
The NullIableIndex property determines if a key item supports the "Null" value. You can: - Determine if a key item supports the "Null" value.
- Allow or disallow the use of "Null" values in a key item (only when defining the data file programmatically).
Note: This property is equivalent to the "Allow NULL values in indexes (the data file will be compatible only with version 28 and later)" option in the "Details" tab of the data file description window, in the data model editor. Note: Data files with the "Allow NULL values in indexes" option are only compatible with applications in version 28 or later. AFile is File Description
AnItem is Item Description
AFile.Name = "CUSTOMER"
AFile.Type = hFileNormal
AFile.NullableIndex = True
AnItem.Name = "Message"
AnItem.Type = hItemText
AnItem.Size = 40
HDescribeItem(AFile, AnItem)
HDescribeFile(AFile)
Syntax
Determining if a key item supports the "Null" value Hide the details
<Result> = <Data file>.NullableIndex
<Result>: Boolean - True if the data file is configured to support "Null" values in a key item,
- False otherwise.
<Data file>: Character string Name of the data file used. This name was defined in the data model editor or with the File Description type.
Allowing or disallowing the use of "Null" values in a key item (data file defined programmatically) Hide the details
<Data file>.NullableIndex = <NULL value supported>
<Data file>: Character string Name of the data file used. This name is defined with the File Description type. <NULL value supported>: Boolean - True if the data file should be configured to support "Null" values in a key item,
- False otherwise.
Remarks "Null" value supported in key items If the keys in the data file support the "Null" value: - You can use search functions including the "Null" value.
- Several keys in the data file can contain the "Null" value.
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|