About    Download    Order    Support

Recent News

InnPlanner 2010 Released New faster database engine, more customization features, weekly tariffs, full multi-user work support and much more... 2010 Feb 10

InnPlanner 2010 RC1 InnPlanner 2010 Release Candidate 1 is ready for downloading and testing. You can download it from the "Downloads" section. 2010 Jan 14

Hotel Software Documentation

Creating Recordset Variables

Introducton

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

• How to create a RecordSet?
• Usage of RecordSet variables
• Examples

How to create a RecordSet?

By Query

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

Parameters:

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

By Relational Field

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

Parameters:

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

By Filtering Recordset

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

Parameters:

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

By Recordset Input

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

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

Parameters:

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

By Folder Input

User will be offered to select necessary records from a database folder.

Parameters:

• Folder - folder, from which records are to be selected.
• Reсord(s) input properties - record-entry window properties. More...
• Number of Records - the number of records, possible to be chosen in this window.

By Standard Set

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

Parameters:

• Record Type - record type for records in the recordset.
• Source - source of sampling:
  • Auto - selected items in the current record folder. If there are none, then last query results.
  • Current Record - the current record, opened in the main window
  • Records in Current Folder - all the records in the current folder
  • Selected Records - selected records
  • Query Results - last query results
  • Recordset variable... - variable set from another Recordset
  • Left/Center Query Window - recordset, kept at the left\center window of query results.
• Number of Records - the number of 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:

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

Examples

1. Adding Records to Relational Field

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

2. Changing Records

In this example:

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

See Also:

Variables

Creating Variables Using Forms

Text/Math/Date Variables

Script Designer

Action Editor

List of actions

Today"s Poll

What software do use for your inn/b&b/hotel/etc?

Home Page | Contacs | Terms and Conditions

Copyright (C) 2001-2010 Binary Brilliant Inc