The All-in-One Database Software Solution

Online Help System

Back to Brilliant Database Web-Site | Write to Support | Help Index

List of Functions

Math/Logic Functions
    Abs - returns the absolute value;
    Cos - returns the value specifying the cosine of an angle;
    Exp - returns e (exponent) raised to the power of a value;
    If - returns 1 if expression is true, otherwise 0 is returned;
    Int - returns the integer portion of a number;
    Log - returns the value specifying the natural logarithm of a value;
    Pow - returns base raised to the power of exp.;
    Round - returns the rounded value to specified precision;
    Sgn - returns the number indicating the sign of a value;
    Sin - returns the value specifying the sine of an angle;
    Sqr - returns the square root of a number;
    V - returns the value of a variable.
    Learn more...

Date Functions
    dateSerial - returns the date for the specified year, month and day;
    datePart - returns the specified part of the date;
    dateCurrent - returns the current system date;
    dateDiff - returns the interval between two dates;
    dateAdd - returns the date shifted from date to a specified interval;
    Learn more...

Data Functions
    F - returns the value of a field of the current database software record;
    RF - returns the value of a field of the specified database software record;
    FLen - returns the length of a field of the current database software record;
    User - returns user input.
    Learn more...

Functions for Recordset
Return results of operations (sum, avrage, etc) for database software records from:
    folMathOp - specified folder;
    mmrMathOp - many-to-many field ;
    setMathOp - database software recordset stored in a variable;
    queMathOp - query results;
    repMathOp - report;
    subMathOp - grouped database software records in a report;
    cexMathOp - custom export;
Return numbers of database software records in:
    folRecN - specified folder;
    mmrRecN - many-to-many field;
    setRecN - database software recordset stored in a variable;
    queRecN - query results;
    repRecN - report;
    subRecN - grouped database software records in a report;
    cexRecN - custom export.
    Learn more...