ICachedDataset.IndexFields

Syntax

IndexFields: String;

Description

The IndexFields property determines the list of cache sorting fields of data source.

Comments

Fields in the list are separated with semicolon. The property also determines the list of fields, used for the filtering during linking several data sources.

Example

Executing the example requires two tables with the Table_1 and Table_2 identifiers in repository.

Sub Main;

Var

MB: IMetabase;

DSInst, DSInst1: IDatasetInstance;

Cache, Cache1: ICachedDataset;

Begin

MB := MetabaseClass.Active;

DSInst := MB.ItemById("Table_1").Open(Null) As IDatasetInstance;

DSInst1 := MB.ItemById("Table_2").Open(Null) As IDatasetInstance;

Cache := DSInst.OpenCached;

Cache1 := DSInst1.OpenCached;

Cache.IndexFields := "FIELD2";

Cache.MasterFields := "FIELD_2";

Cache.MasterSource := Cache1;

Cache1.First;

While Not Cache1.Eof Do

Debug.WriteLine(Cache.RecordCountAll);

Cache1.Next;

End While;

End Sub Main;

After executing the example, two tables are connected. The field of the main table from which the data is taken has the FIELD_2 identifier; the field of the dependent table, by which filtering according to data from the first table is performed, has the FIELD2 identifier. All records of the main table will be checked. Quantity of records in the linked table, received as a result of filtering by data of each record of the main table, is displayed in the console.