Functions for working with tables

Functions for working with tables

Loading a table from the database to Cache
LoadInCache(name1, name2, … , nameN)
Loads the selected fields from the table.

Function has various numbers of arguments.

name1, … , nameN – names of the table parameters.

Example:

LoadInCache(D);
LoadInCache(dr, dH);

Selection from the table
SelectInCache(strFilterKey, strParamName, strOperation, Value … , strFilterKeyN, strParamNameN, strOperationN, ValueN)

Executes selection from the object’s table cache. Various numbers of arguments.

strFilterKey – key of filtration – string, taking the following values:

“kFirst” – select the first from the values, satisfying the filtration condition

“kLast” – select the last from the values, satisfying the filtration condition

“kFilter” – select the range of the values

“kAsk” – ask user (activates the dialog for manual selection of the value)

“kAskIfNeed” – ask user if automatic selection cannot be preformed

strParamName -name of the table parameter – string, containing the name of the table parameter, on which selection is made.

strOperation – operation of filtration – string that can take values :

“=” – equals

“>=” – more or equals

“<=” – less or equals

“~” – approximately equals

“>” – more

“<” – less

“+” – calculation of the expression

Example:

LoadInCache(dr, L);
SelectInCache(“kFirst”, “dr”, “~”, 14, “L”, “>=”, 100);

LoadInCache(dr, L, b);
SelectInCache(“kFirst”, “dr”, “~”, rdr, “L”, “r;+”, “L>=rMinLen && L<=rMaxLen && (L-b<=rTrLen)”);