The All-in-One Database Software Solution

Online Help System

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

Data Functions

F (|Field|)

Returns the value of Field of the current database software 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 database software record with RecordID.

Examples:

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

FLen (|Field|)

Returns the length of Field of the current database software record.

Examples:

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

If Title field of a database software 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.