The Index property sets or returns a string value that indicates the name of the current index for a Recordset object. The index must have been created as an index on the table or as an ADOX Index object. This property can be set on an open or closed Recordset.
Index属性的作用是：设置或返回一个用于指示当前记录集对象索引[index]名称的字符串值。索引必须在表中以一个索引数的形式或以一个ADOX索引对象的形式创建。该属性可以在一个打开或关闭的记录及对象中设置。

Note: This property is used together with the Seek method to create an indexed display of records and to use the Seek method to search these indexed records, but few providers supports this property and method. Use the Supports method to determine whether the provider supports seek and indexes.
注意：这个属性是和Seek方法一起使用的，它的作用是创建记录的索引显示并使用Seek方法来搜索这些被索引的记录。但是，仅有少数技术提供对象[provider]支持这个属性和方法。使用Supports方法可以确定一个技术提供对象[provider]是否支持seek方法和index属性。

Syntax
语法

objRecordset.Index

评论 (0) All