IDatasetModelField.Mandatory

Syntax

Mandatory: Boolean;

Description

The Mandatory property returns True if empty values in the field are not allowed.

Example

Sub UserProc;
Var
    MB: IMetabase;
    DSInst: IDatasetInstance;
    DSModel: IDatasetModel;
    Fields: IDatasetModelFields;
    Field: IDatasetModelField;
    s: String;
Begin
    MB:=MetabaseClass.Active;
    DSInst:=MB.ItemById("Table_1").Open(Null) As IDatasetInstance;
    DSModel:=DSInst.Dataset;
    Fields:=DSModel.Fields;
    Field:=Fields.Item(0);
    If Field.Mandatory Then
        s:="No";
    Else
        s:="Yes";
    End If;
    DSInst.Close;
End Sub UserProc;

After executing the example, the "s" variable contains Yes if empty values are allowed in the first field of data source. Data source identifier is Table_1.