GetFieldValue(RecNo: Integer; FieldNo: Integer): Variant;
RecNo is record number.
FieldNo is column number.
The GetFieldValue method returns value of cached field without moving by records.
Sub UserProc;
Var
MB: IMetabase;
DSInst: IDatasetInstance;
Cache: ICachedDataset;
v: Variant;
Begin
MB:=MetabaseClass.Active;
DSInst:=MB.ItemById("Table_1").Open(Null) As IDatasetInstance;
Cache:=DSInst.OpenCached;
Cache.FetchToRecord(Cache.RecordCountAll);
v:=Cache.GetFieldValue(3,3);
End Sub UserProc;
After executing the example the "v" variable contains value of the fourth column, the fourth record of the cache.
See also: