Quick References
      ADO
      ASP
      CSS2
      HTML
      JavaScript
      Jet SQL
      VBScript
      WML
      WMLScript
      WSH
      XHTML
      XML DOM
      XSLT

Features
      Knowledge Base
      Tutorials

Partners
     ZVON.ORG
     XML
     Planet Source Code
     VisualBuilder
     Web Design
     Your HTML Source
     XML/XSLT Forums
     ASPAlliance
     Scripts
     
     Programmers Heaven
     Tek-Tips Forums
     Developer Fusion
     Code Project











PROPERTY:  Recordset::Index
string = recordsetobject.Index
recordsetobject.Index = string

The Index property sets or returns a string value that refers to the name of the current index for a Recordset object. This current index must have been previously created either as an index on the base table or an ADOX Index object.

The basic concept is to create an indexed display of the records and to use the companion Seek method to search these indexed records.

Few providers support this property.

You can set this property on an open or closed Recordset object. Note that you can always successfully set this property when the Recordset is closed, but if the provider does not recognize this property, the Recordset will not open properly. If you try to set the Index property on an open Recordset and the provider does not recognize this property, an error will be generated.

Code (VBScript):
If objRecordset.Supports(adIndex) Then
   objRecordset.Index = "AddressIndex"
End If

 


Copyright 1999-2005 by Infinite Software Solutions, Inc. All rights reserved.
Trademark Information