Brilliant Database Software - Home
Database software - Online Help System

Online Help System

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



List of Functions

table border="0" width="100%" cellspacing="0" cellpadding="4" bgcolor="#00000077">
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 record;
    RF - returns the value of a field of the specified record;
    FLen - returns the length of a field of the current record;
    User - returns user input.
    Learn more...

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



All topics in the "Functions Description" section: