The All-in-One Database Software Solution

Online Help System

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

Creating Text/Math/Date Variables

Regular variables containing text, numbers or date can be defined in one of the following ways:

By Math Formula

Set the value of the variable using a mathematical formula.

In the formula you can use the values of other variables, database fields, queries, etc. Learn more about formulas...

Examples

[$orders] = queRecN(|All Orders|). Sets variable orders as the number of database software records from the All Orders query.

[$orders] = [$orders]+[Quantity]. Increases the value of the [$orders] variable by the value of the Quantity field of the current database software record.

Note: if you want to use the field values of the current database software record, don't forget to specify its type in the Use the following database software record type text box:

By Text Formula

Set the value of the variable using the text formula.

Text Formula is a text string that consists of several elements such as values of the database software record fields, formulas, variables, system values, etc. Learn more about text formulas...

Examples

For example, there is a database software record with the First Name and Last Name fields that store the Thomas and Anderson values accordingly.

[$full_name] =[First Name] [Last Name^text UCASE]. Sets full_name as value Thomas ANDERSON. ANDERSON capitalized, according to the UCASE formatting.

[$full_name] = Dear [$full_name]. Adds prefix Dear to variable [$full_name]. Now [$full_name] equals to "Dear Thomas ANDERSON".

Note: if you want to use the field values of the current database software record, don't forget to specify its type in the Use the following database software record type field:

By User Input

Set the value of the variable using the edit field.

The user is offered to input the value of the variable directly while the script is being executed, for example:

The default value and the message text can be set by using text formulas.

By Input List

The user is offered to select a value on the list as the variable value.

Options:

Input window text - value-entry window title; e.g., you can enter Select a value from the list.
List of values - the list of values - one value per line; for example:
   London
   Moscow
   Paris
List Style - can contain one of two possible values and defines the appearance of the value-entry window:

By default, this action puts the selected value (e.g., Moscow) to the variable. However, you can have the program put the value identifier instead of the actual value to the variable. To make that happen, the list items are to be defined as identifier > value pairs; for example:

1 > London
2 > Moscow
3 > Paris

In this case, the list will appear the same way, but the selection of, for instance, London will write 1 to the variable.

This method is especially useful for the further work with the values in formulas. For example, this way you can make the tax selection:

0 > No taxes
17.5 > VAT (17.5%)
5 > Internal 5% tax

Depending on the selected value, the variable will have 0, 17.5 or 5.

The list text can be set by using text formulas.

By Calendar

In this case, the user will be offered to select a date using the calendar:

Options:

Default Date - date set by default.
Result Date Format - in which format the date is to be returned:
- Text - date is written to a variable as plain text. In this format, it can be used in queries, for displaying on the screen, etc.
- For Math Formulas - date is written as numbers. This method is to be used only if you are planning to use the variable you are creating in math formulas.

By Form

Here, the user is shown the selected form in a different window, and field values are inserted into the variables:

Learn more about this way of data entry...