VistaDB 5
Example 






index name
Table columns participating full text index. These names are listed in the same string and separated with ';' sign
CreateFTSIndex Method
Create special index to use by full text search. Identity columns may not be used for FullTextSearch indexes. Only a single FullTextSearch index may exist per table.
Syntax
'Declaration
 
Sub CreateFTSIndex( _
   ByVal name As System.String, _
   ByVal columns As System.String _
) 
'Usage
 
Dim instance As IVistaDBTable
Dim name As System.String
Dim columns As System.String
 
instance.CreateFTSIndex(name, columns)
void CreateFTSIndex( 
   System.string name,
   System.string columns
)
procedure CreateFTSIndex( 
    name: System.String;
    columns: System.String
); 
function CreateFTSIndex( 
   name : System.String,
   columns : System.String
);
void CreateFTSIndex( 
   System.string* name,
   System.string* columns
) 
void CreateFTSIndex( 
   System.String^ name,
   System.String^ columns
) 

Parameters

name
index name
columns
Table columns participating full text index. These names are listed in the same string and separated with ';' sign
Remarks
DDA cannot query the FullTextSearch indexes. Only the SQL CONTAINS command operates on Full Text Search (FTS) indexes.
Example
The following example creates an FullTextSearch Index on multiple columns.
using( IVistaDBDatabase db = DDAObj.OpenDatabase(dbName, VistaDBDatabaseOpenMode.ExclusiveReadWrite, null) )
{
    using( IVistaDBTable table = db.OpenTable("testtable", false, false) )
    {
        table.CreateFTSIndex("FTSTest", "col1;col2;col3;col4");
    }
}
CREATE FULLTEXT INDEX indexname on tablename(columnname,...)
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