RAIS RAIS 4 Fiche technique télécharger pdf (Page 19)

RAIS 3.0 Programmer’s Guide – Part I : Advanced Customization

open in design mode, please lookup the table name and open the form called “SUB EDIT

table name”.

Consistency checks are stored in the table [Propagator – Consistency Checks]

Form Name Name of the form that will trigger the consistency check

Query Name Query that will be evaluated

Message Message to be displayed upon non successful evaluation

2.3.1 Examples

2.3.1.1 Ensuring selection of a generator type

Let us have the simple example of checking that a generator type has been selected for

radiation generators. Generator types have been defined to be optional in RAIS 3.0; the field

may be left blank and we may even select the generator type to be unknown.

Have a look at the input form for generators; the field for generator types is a combo box.

Open the input form for generators in design mode (that form is called [SUB EDIT

Generator] and select the control for generator types. Look at its properties; it is bound to the

table field [FK Type ID] and has the name [COMBO Type]. We may refer to that control in

queries as if they where constants or table fields, simply with the statement [COMBO Type]

(don’t forget the square brackets). This is possible due to the fact that consistency checks are

executed within the context of the input forms (clever, isn’t it).

If we want to enforce RAIS Regulators to enter the generator type, we have to design a

consistency check like this one

or in SQL view

SELECT IsNull([COMBO type]) AS Expr1, [FK Generator Type ID]<>[COMBO type] AS

Expr2

FROM [Evaluator Unknown GT]

WHERE (((IsNull([COMBO type]))=True)) OR ((([FK Generator Type ID]<>[COMBO

type])=False));

Save this query as [Consistency Check – Generator Type] and append the following record to

the table [Propagator – Consistency Checks]

1 2 ... 14 15 16 17 18 19 20 21 22 23 24 ... 60 61

Pas de commentaire

RAIS RAIS 4 Fiche technique Page 19