IncludedFields Property

Version: Available or changed with runtime version 8.0.

Sets the fields that are included as non-key columns in the index on SQL Server.

Applies to

  • Table Key

Property Value

A comma-separated list of field names.

Syntax

IncludedFields = Field1,Field2;

Remarks

You can't use this property on primary keys or clustered secondary keys (Clustered property is true).

Fields that are part of a IncludedFields definition are not used when searching for a matching key with the Record.SetCurrentKey method. For more information, see Record.SetCurrentKey Method.

Using this property can improve query performance. For more information, see Table Keys.

See Also

Get Started with AL
Developing Extensions