VistaDB 5






VistaDB.DDA Namespace > IVistaDBTable Interface : CreateTemporaryIndex Method
Index name
Key expression with syntax "column1[;DESC(column2)[;...n]]". Key expression cannot cover more than 128 columns.
The index requires unique column constraint
CreateTemporaryIndex Method
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
'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
)
procedure CreateTemporaryIndex( 
    name: System.String;
    keyExpression: System.String;
    unique: System.Boolean
); 
function CreateTemporaryIndex( 
   name : System.String,
   keyExpression : System.String,
   unique : System.boolean
);
void CreateTemporaryIndex( 
   System.string* name,
   System.string* keyExpression,
   System.bool 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

See Also