Datasheet

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

3 Copying customizations from a front-end to the creator

3.1 Copying Queries

Queries are most easily copied by a simple Drag-and-Drop operation from the Front-End into

the Creator. If the query to be copied already exists in the Creator, MS Access will ask for a

new name. This may easily be avoided by first deleting the query to be copied from the

creator, as a new query from the Front-End is going to supersede that very query. Please note

that both Front-End and Creator need to be opened in design mode in order to execute Drag-

and-Drop operations.

Queries to be copied from the Front-End usually contain both tables and relations. When

copying queries by Drag and Drop operations into the Creator, these relationships generally

are broken if the query is run, due to the fact that the Creator does not “know” about those

relationships. The results of this unfortunate behavior are non-working queries.

To avoid for this, we recommend linking the RAIS Creator to a RAIS backend, possibly a

test backend only. This is easily achieved by opening the form [Backend Selector] manually

within the Creator and selecting a RAIS Backend to “connect to” just the same way as within

the RAIS User Interface.

Above mentioned procedure allows MS Access to preserve relationships within SQL

Statements during Copy/Paste operations.

Another possibility is to open the query to be copied in SQL view, copy the text of the SQL

statement and paste it in a new blank query opened in the creator in SQL view. Save this new

query in the creator with the same name as the one in the front end.

3.1.1 Simple static SQL Statements

The RAIS creator uses bulk copies to copy all SQL statement having a specific prefix into the

created Frontend. Below is a list of SQL Statement prefixes that are copied during creation.

Prefix

[Consistency Check - ]

[Preselection Filter - ]

[Preselection List - ]

[Entry Filter - ]

[Allocation Filter - ]

[Report Queries]

[Helper - ]

[Display - ]

[Mini Display - ]

[Item Selection - ]

[Query - ]

[Statistics - ]