CreateTemporaryIndex Method

In This Topic

Create temporary index from given keyExpression. The index is not added to database but kept separately in the user temporary folder. The file is deleted by engine when the table is closed.

Syntax

Visual Basic
C#

'Declaration
 
Sub CreateTemporaryIndex( _
   ByVal name As System.String, _
   ByVal keyExpression As System.String, _
   ByVal unique As System.Boolean _
)

'Usage
 
Dim instance As IVistaDBTable
Dim name As System.String
Dim keyExpression As System.String
Dim unique As System.Boolean
 
instance.CreateTemporaryIndex(name, keyExpression, unique)

void CreateTemporaryIndex( 
   System.string name,
   System.string keyExpression,
   System.bool unique
)

Parameters

name: Index name
keyExpression: Key expression with syntax "column1[;DESC(column2)[;...n]]". Key expression cannot cover more than 128 columns.
unique: The index requires unique column constraint

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Reference

IVistaDBTable Interface
IVistaDBTable Members

Send Feedback