Recent News
|
InnPlanner 2010 Released
New faster database engine, more customization features, weekly tariffs, full multi-user work support and much more... | |
InnPlanner 2010 RC1
InnPlanner 2010 Release Candidate 1 is ready for downloading and testing. You can download it from the "Downloads" section. |
|
|
Hotel Software Documentation
Functions for Recordset
...MathOp Functions
The following functions carry out operations (summation, subtraction, average
computing, etc.) over a set of records and differ only in the type of the source
of records.
- folMathOp (FolderID, FormID, |Field|,
|Operation|) - records are retrieved from the folder with FolderID
- mmrMathOp (|RelationalField|, |Field|, |Operation|) -
records are retrieved from the many-to-many field
(parameter RelationalField).
- setMathOp (|VariableName|, |Field|, |Operation|) -
records are retrieved from the variable with the
VariableName name.
- queMathOp (QueryID, FormID, |Field|,
|Operation|, Var1, Var2) - records are generated on the basis of the
query with the QueryID.
You can use the optional
variables Var1 and Var2 to set the "User Input" query parameters.
The following 3 functions can be used only with the Report Styles or
Custom Export templates:
- repMathOp (|Field|, |Operation|) -
operation over records selected into the report (for
printing).
- subMathOp (|Field|, |Operation|) -
operation over records grouped into the report (for
printing).
- cexMathOp (|Field|, |Operation|) -
operation over records selected into Custom Export.
The Field parameter defines the record field over which the operation
is to be carried out.
The Operation parameter defines the operation itself. For example,
there are three records with values 1, 2 and 3. Then:
- Sum - sums values (1+2+3=6);
- SumOfSquares - calculates the sum of squares (1*1+2*2+3*3=14);
- SimpleAverage - calculates simple average ((1+2+3)/3=2)
- Quantity - returns the number of records (=3)
- Min - returns the lowest value of the set (=1)
- Max - returns the highest value of the set (=3)
- First - returns the first value of the set (=1)
- Last - returns the last value of the set (=3)
Examples: Let's assume that we have 2 records in the folder
with ID=7. The records use the form with ID=9 and have field Price.
The Price field contains the following values: 3 and 4.
folMathOp(7,9,|Price|, |Sum|), returns 3+4=7;
folMathOp(7,9,|Price|, |SumOfSquares|), returns 3*3+4*4=9+16=25;
folMathOp(7,9,|Price|, |SimpleAverage|), returns (3+4)/2=3.5;
folMathOp(7,9,|Price|, |Quantity|), returns 2.
...RecN Functions
Functions RecN are a particular case of the MathOp functions
and return the number of records in the selection:
folRecN, mmrRecN, setRecN, queRecN, repRecN, subRecN, cexRecN
|
|
|
|
Today"s Poll
What software do use for your inn/b&b/hotel/etc?
|
About