Objects of type sbme1newindex represent an index in a new database table associated with an SBME database file, and provide information that may be needed about the index.
Objects of type sbme1newindex have no value, and it is an error to try to get or set this value.
| Property | Type | Description |
|---|---|---|
| _ | type(*) | This property is provided for use by the user to attach any object of any type to the type in which this property is provided. |
| __ | type(*) | This property is provided for use by the user to attach any object of any type to the type in which this property is provided. It has the additional feature of being marked with the resolve keyword, so that object resolution can continue down this property. |
| algorithm | string |
Contains the name of the algorithm for this index. If this value is
the empty string ("") then the index is in order
by character value.
|
| field | sbme1newfield | Contains a reference to the first sbme1newfield object that this index is based on. Currently that is the only one. |
| next | sbme1newindex | Contains a reference to the next sbme1newindex object for the table. The sbme1newindex objects for a table form a closed loop that is linked by this property. |
| precision | integer |
For full precision this value must be .nul,
otherwise it is a positive integer value that indicates the maximum
number of characters taken from a string value, the maximum number of
bytes of data taken from the most significant end of an integer
value, or the maximum number of bytes taken from a blob when sorting.
|
| table | sbme1newtable | Contains a reference to the sbme1newtable object for the table that contains this index. |
| type | type | Specifies the sbme1newindex type object. |
| unique | boolean |
If this value is equal to .true, then the index
is guaranteed to be unique and will cause an error if an attempt is
made to save a record with a duplicate index value.
|
| Parameter | Default value | Type name | Description |
|---|---|---|---|
| error | .nul | integer |
Specifies an object that is used to output any error code
generated during the execution of the method. This parameter must
be an object, not an integer value. If error is not specified or is
.nul then any error that occurs during object
creation will halt the program. If an error object is specified
and an error occurs during execution then the error code is
output into that object and the method returns
.nul.
|



