ITableIndex.AllowNulls

Syntax

AllowNulls: Boolean;

Description

The AllowNulls property determines whether empty values are allowed in the index.

Comments

The property is relevant only for the repositories using the DBMS MS SQL Server.

Available values:

True. Index allows empty values.
False. Index does not allow empty values.

Example

Executing the example requires that the repository contains a table with the "T" identifier. Add links to the Metabase, Db system assemblies.

Sub UserProc;
Var
    MB: IMetabase;
    Table: ITable;
    Inds: ITableIndexes;
    i: Integer;
    Index: ITableIndex;
    s: String;
Begin
    MB := MetabaseClass.Active;
    Table := MB.ItemById("T").Bind As ITable;
    Inds := Table.Indexes;
    For i := 0 To Inds.Count - 1 Do
        Index := Inds.Item(i);
        s := Index;
        s := s + Index.Id + "' ";
        If Index.AllowNulls Then
            s := s + allows empty values;
        Else
           s := s + does not allow empty values;
        End If;
        Debug.WriteLine(s);
    End For;
End Sub UserProc;

After executing the example the data of table indexes is displayed in the console window, whether indexes are allowed to contain null values.