DtoIndex Object

This object represents an index for a table.

Properties


Flags	Gets or sets the column name for the index segment. This is an enumerated value. See Index Flags for a list of possible values.
Name	Gets or sets the name of the index.
Number	Gets or sets the 0-based number of the index.
Tag	Gets the index tag. It contains the names of all the columns that comprise the index.

Collections

DtoSegments Collection

Methods

None

Remarks

Only 119 segments are allowed per index. Note that the combined size of all the columns in segments of an index cannot be more then 255 bytes.

Example

' Instantiate and open dictionary 
Dim dictionary as new DtoDictionary 
Dim result as DtoResult 
result = dictionary.Open("c:\pvsw\demodata") 
' Get STUDENT table from DEMODATA database 
Dim students_table as DtoTable 
Set students_table = dictionary.Tables("STUDENT") 
' Retrieve DEMODATA indexes collection 
Dim students_idx as DtoIndexes 
Set students_idx = students_table.Indexes 
' Get first index and determine its name 
Dim first_idx as DtoIndex 
Set first_idx = students_idx(1) 
Dim index_name as String 
index_name = first_idx.Name