Datasheet

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

2.10.2 Comments

If forms are opened with the parameter acDialog, they may not loose focus. You may remove

this parameter if you want to allow custom forms to be opened and user switching to the

RAIS Interface forms or other custom forms.

2.11 Creating Custom Queries and Statistics

The process of creating custom queries or statistics is among the complicate tasks of

advanced customizations of RAIS. Let us briefly outline steps to be executed, before coming

to some examples.

• Define the query, using static parameters only, meanwhile identifying all required

parameters for later use,

• Test and validate the query,

• Add a new record to the table “Treeview” in order for query to appear in the interface

• Link query parameters to the Query Parameter Form by entering new record to the

table Propogator – Menu Selector

• Create report definition entry as well as parameters for record grouping in the table

Propogator – Report Definitions

• Test and validate how the query works through the interface

• Copy customizations into the creator

It is clear that all queries and statistics need testing and validation. We recommend this as

often as possible, especially when we are handling highly complex queries.

Queries and statistics within RAIS 3.0 are to be designed just as queries in any other

Microsoft Access Application. However, queries most often will require some filtering to be

applied on parameters. These parameters are retrieved from a special form, designed for this

purpose, called [Query Parameter form]. This form offers a total of 7 parameters:

(tables already described in section 2.9)

List 5

List 4

List 3

List 2

List 1

List 0

Combo box that may be populated by underlying record sets. Each

of these combo boxes may again be used as a parameter for other

combo boxes underlying record sets. Combo boxes only are visible

if an underlying table is defined in the table [Propagator – Report

Definitions]

Start Date / End Date Start and end dates that define the time period for the query. Note

that these shall be converted using the function CVDate() to avoid

for date conversion problems. Date fields only are visible if the

value of the field [Query 0] of the relevant record in the table

[Propagator – Menu Selector] has three leading dashes “---”.

Each of these parameters may easily be used in SQL statements, such as in the example

below: