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)");