SQL::TableInfo::IndexNumber()

Syntax

Index_Number as N = <SQL::TableInfo>.IndexNumber( Name as C )

Argument	Description
Index_Number	The number of the index named. -1 if the index name is not in the column list.
<SQL::TableInfo>	A SQL::TableInfo object.
Name	The name of the index.

Description

The IndexNumber() method gets the subscript of the requested index name in the Index array property.

Example

dim TableInfo as SQL::TableInfo

dim IndexInfo as SQL::IndexInfo

TableInfo.Name = "MyTable"

IndexInfo.Name = "Primary_Key"

IndexInfo.PrimaryKey = .t.

? TableInfo.AddIndex(IndexInfo)

= 1

? TableInfo.IndexNumber("Primary_Key")

= 1