DtoIndexes Collection
A collection of DtoIndex objects representing the indexes of a table.
Properties
Count | Returns the number of members in a collection. |
Item | Returns a specific member of a DtoIndexes collection. You can pass either a 1-based ordinal or the name of the Index. |
Methods
Remarks
Use the Count property to find the number of members in the collection.
Example
Dim dictionary as new DtoDictionary
Dim result as DtoResult
result = dictionary.Open("d:\mydemodata")
Dim students_table as DtoTable
Set students_table = dictionary.Tables("STUDENT")
Dim students_idx as DtoIndexes
Set students_idx = students_table.Indexes
See Also
Methods Detail
Add method
Add an item to a collection.
Syntax
result = Collection.Add(Object)
Arguments
Collection | Collection to add object to. |
Object | A new DtoIndex object to add to the DtoIndexes collection. |
Return Values
result | DtoResult long value indicating the result of the method call. Use the Error property of the
DtoSession Object to obtain a description for the result. |
Remarks
This method takes a parameter of type DtoIndex. Therefore, you are responsible for first instantiating the object and setting its properties before adding it to the collection.
Note You cannot use this method to add indexes to preexisting PSQL tables. This method does not alter data or DDF files, and can only be used to add indexes in memory before a table is created. See the example for
AddTable method as a reference.
Remove method
Removes an item from a collection.
Syntax
result = Collection.Remove(index)
Arguments
Collection | Collection from which to remove object. |
index | A variant containing either the index (starting with 1) or the name of the item you wish to remove from the DtoIndexes collection |
Return Values
result | DtoResult long value indicating the result of the method call. Use the Error property of the
DtoSession Object to obtain a description for the result. |
Remarks
You can pass either a name or a 1-based ordinal to the Remove method.
Note You cannot use this method to remove indexes from preexisting PSQL tables. This method does not alter data or DDF files, and can only be used to remove indexes in memory before a table is created. See the example for
AddTable method as a reference.
Clear method
Removes all items from a DtoColumns or DtoIndexes collection.
Syntax
result = Collection.Clear
Arguments
Collection | DtoIndexes collection obtained from a DtoTable object |
Return Values
result | DtoResult long value indicating the result of the method call. Use the Error property of the
DtoSession Object to obtain a description for the result. |
Remarks
This method removes all the indexes from a table in memory.
Note You cannot use this method to remove indexes from preexisting PSQL tables. This method does not alter data or DDF files, and can only be used to remove all indexes in memory before a table is created. See the example for
AddTable method as a reference.