Brilliant Database Software - Home
Database software - Online Help System

Online Help System

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



Data Functions

table border="0" width="100%" cellspacing="0" cellpadding="4" bgcolor="#00000077">
Data Functions

F (|Field|)

Returns the value of Field of the current record. This function is equivalent to the square bracket operator [].

Examples:

F(|Price|), returns the price field value;

F(|Quantity|)-[Quantity], always returns 0,

RF (RecordID, |Field|)

Returns the value of Field of a record with RecordID.

Examples:

RF(107,|Price|), returns the price field value of a record with ID=107;

FLen (|Field|)

Returns the length of Field of the current record.

Examples:

If Title field of a record is "Record", FLen(|Title|) returns 6 (number of chars);

If Title field of a record is "Hello", FLen(|Title|) returns 5.

Special Functions for Script Designer

Note. This function is available only when editing scripts.

User(DefaultValue) - only for script designer.

This function opens an input dialog and prompts the user to specify its value. For example, when the user clicks the button that changes the value of the Quantity field according to the formula: Quantity=[Quantity]+User(1), the value of the Quantity field is increased by the specified value. If the user clicks Cancel, the calculation of the formula is aborted. The optional parameter DefaultValue is used to define the default value of the function.

Instead of this function it is recommended to use a script with preliminary input of data into the variable.




All topics in the "Functions Description" section: