The All-in-One Database Software Solution

Online Help System

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

Creating Recordset Variables

Introduction

RecordSet Variables are variables that store lists of database software records. Recordsets can be used for the mass modification of database software records, printing database software records, modifying relational fields, etc.

How to create a RecordSet?

By Query

The variable will have database software records selected from the database by the specified query.

Parameters:

Query - the query that will select database database software records for writing to the variable.

By Relational Field

The variable will have database software records stored in the many-to-many relational field or simple relation field of the current database software record. For example, if we have the Book type database software record, and it has the Authors relational field, we can create a database software recordset variable, to which we will place authors from the Authors field and then print them.

Parameters:

Relational Field - the relational field the database software records are to be taken from;
Records - which database software records are to be selected: Selected - selected only, All database software records - all database software records in the field;
Filter For Records - specifies additional rules for filtering database software records.

By Filtering Recordset

In this case, the database software records variable will be created by applying a filter to an existing database software recordset. For example, we can create a database software recordset based on database software records selected By Folder Input and then remove some database software records from it.

Parameters:

Source Recordset - variable with the source database software recordset;
Filter For Records - rules for filtering database software records.

By Recordset Input

The user will be offered to choose one or several database software records from the existing database software recordset.

For example, a database software recordset can be created by means of Query, and the user can be offered to choose one database software record from the query results.

Parameters:

Source Recordset - variable with the source database software recordset;
Window Title Text - the window title text for the database software record selection window;
Number of Records - the number of database software records possible to be chosen in this window.

By Folder Input

The user will be offered to select necessary database software records from a database folder.

Parameters:

Folder - folder from which database software records are to be selected;
Record(s) input properties - database software record-entry window properties. More...
Number of Records - the number of database software records, possible to be chosen in this window.

By Standard Set

Recordset will be created based on one of the standard database software record sample:

Parameters:

Record Type - database software record type for database software records in the database software recordset.
Source - source of sampling:
- Auto - selected items in the current database software record folder. If there are none, then last query results.
- Current Record - the current database software record opened in the main window;
- Records in Current Folder - all the database software records in the current folder;
- Selected Records - selected database software records;
- Query Results - last query results;
- Recordset variable... - variable set from another Recordset;
- Left/Center Query Window - database software recordset kept at the left\center window of query results;
Number of Records - the number of database software records possible to be chosen in this window.

Other means

In order to create a relational variable, you can use forms for data entry. To learn more...

Usage of RecordSet Variables

Further on this variable can be used for the following purposes:

Execute a script for these database software records. For example, change field value for all the database software records. To learn more, see the For Each database software record from database software recordset cycle section.
Print or custom export these database software records.
To automatically add or remove database software records in the relational fields. Use the Change relational field action.
To carry out calculations for the selected database software records in mathematical formulas. For example, get the number of database software records, total by one of the database software records' fields, etc. Use functions setMathOp() and setRecN().
To display database software record data fields using the RSET formatting.

Examples

1. Adding Records to Relational Field

A sample of a script that carries the selected database software records from the many-to-many Field_A to Field_B and displaying the number of carried database software records:

2. Changing Records

In this example:

Line 1: Places set of database software records created with the All Records query to the [$rset] variable.
Lines 2, 4: Defines the cycle, in which all operations will apply to database software records stored in the [$rset] variable and not to current database software records.
Line 3: Cycle body. Increase the value of the database software record's [Field A] by one.