class Index
Topic group Related topics Example
An object representing an index from a non-local table
Syntax
[<oRef>]=new Index( )
<oRef>
A variable or property in which to store a reference to the newly created Index object.
Properties
The following tables list the properties of the Index class. No events or methods are associated with this class. For details on each property, click on the property below.
|
Property |
Default |
Description |
|
INDEX |
Identifies the object as an instance of the Index class | |
|
caseSensitive |
true |
Whether a search string is required to match the case, upper or lower, of a field value. |
|
(INDEX) |
Identifies the object as an instance of a custom class. When no custom class exists, defaults to baseClassName | |
|
false |
Creates the index in descending order (Z to A, 9 to 1, later dates to earlier dates). Without DESCENDING, creates an index in ascending order. | |
|
fields |
Empty string |
A list of fields on which the table is indexed |
|
Empty string |
Specifies the name of the index tag for the index | |
|
null |
Container, form or report | |
|
false |
Prevents multiple records with the same expression value from being included in the index. dBASE Plus includes only the first record for each value. |
Description
Use Index( ) to store a reference in a newly created Index object for non-local tables. A subclass of Index, DBFIndex is available when working with local DBF tables (See class DBFIndex). An Index object requires setting only two properties, indexName and fields. As the name implies, indexName is the name you'll give the index, and fields is a list of fields on which the index is based. Once an Index object has been referenced, use the database class method: createIndex( ) to create a new index for your table.