		About
		Download
		Order/Prices
		Support/Contact
		Partner Program
		Press Room
		Online Help

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

Rule Wizard

Introduction

Rules can be used in the following two cases:

To describe queries in the Query Editor;
To describe conditions (if rules then ...) in the Script Designer.
To set rules for elements visibility and editable in the Form Editor.

In the conditions you can use text fields, mathematical formulas, variables and "User Input".

Interface

The window for entering rules comprises three parts:

Field to check - In this area you can select the field, to which the rule is applied (the first rule argument). Also you can choose Formula... or Variable as a first argument. To set a formula or select a variable press the "..." button that will appear right after the field.
Rule To use - the rule itself ("More than," "Equal," "Begins with," and so on).
Compare with - defines a second argument for the rule. Depending on the type of the second argument, the bottom part of the screen may change.

Types of the second argument

The second argument can be of the following types:

Constant

A constant value. When the field is selected, the window for entering this value will appear. Use Constant if you know the value to compare with, beforehand.

User Input

Before accomplishing a request, a user will be offered to enter a value of a second argument for the rule. When the field is selected, the window for entering a message text will appear. For example, a user searching for an item in the database may enter the following text: "Enter the first letters of the author's name:". In this case when the query is executed, the user will see the following dialog:

Moreover, when creating a text button with the given query as an action, the text provided in the text button will be automatically sent to the query as a User Input value (see the example). Also you can use the User Input type to pass a value from a queMathOp or queRecN formula. If you select the variable type, you will be offered to select "Skip this rule if empty value is entered" option. In this case if you enter no variable, the rule will be skipped. It is necessary if you're creating multiple search.

Formula

Allows using a mathematical formula as the second argument. In the formula you can use both the fields of the current record, and variables and values of the other records. For more details see section Formula Editor.

Text Formula

In this case the second argument will be in the form of a compound text string. The string can include field values, variables, system values (such as current date or the name of the user working with the database). For more details, see section Text Formulas.

Field of record being checked

In this case, the field of the same record (the one being checked) can be specified as the second argument. This, for example, will help to get a list of the book, which were purchased in the year they were published: Publication Date = Acquisition Date.

Field of record being selected

In this case, the field of the record, which was selected at the moment of requesting, can be specified as the second argument. For example, a user can create a query, which would return the list of the books, which were published earlier than the selected one.

Field of custom record

In this case, a user can specify a field of any specific record as the second argument. For example, if there is a record about quantity of money available, one can get a list of the books, which can be purchased having the given sum.



Home Page \| Contacs \| Terms and Conditions		Copyright (C) 2001-2010 Binary Brilliant Inc