ITableIndex.FieldNames

Syntax

FieldNames: String;

Description

The FieldNames property returns the character string containing the list of fields, by which the index is created.

Comments

The list consists of fields identifiers separated with semicolon.

Fore Example

Executing the example requires that the repository contains a table with the Table_1 identifier. The primary index including several fields is created for the table.

Sub UserProc;
Var
    MB: IMetabase;
    Table: ITable;
    Index: ITableIndex;
Begin
    MB := MetabaseClass.Active;
    Table := MB.ItemById("Table_1").Bind As ITable;
    Index := Table.Indexes.Primary;
    Debug.WriteLine(Index.FieldNames);
End Sub UserProc;

On executing the example the list of primary index fields, separated with semicolon, is displayed in the console window.

Fore.NET Example

Executing the example requires that the repository contains a table with the Table_1 identifier. The primary index including several fields is created for the table. Selected procedure is an entry point for the .NET assembly.

Public Shared Sub Main(Params: StartParams);
Var
    MB: IMetabase;
    Table: ITable;
    Index: ITableIndex;
Begin
    MB := Params.Metabase;
    Table := MB.ItemById["Table_1"].Bind() As ITable;
    Index := Table.Indexes.Primary;
    System.Diagnostics.Debug.WriteLine(Index.FieldNames);
End Sub;

On executing the example the list of primary index fields, separated with semicolon, is displayed in the console window.