RAIS RAIS 4 Fiche technique

The Regulatory Authority Information System RAIS 3.0 with SQL Server Extensions Programmer’s Guide Part I – Advanced Customization Document version

RAIS 3.0 Programmer’s Guide – Part I : Advanced Customization 8 Create the field Operation Code. Please check spelling and system field option.

RAIS 3.0 Programmer’s Guide – Part I : Advanced Customization 9 It’s empty, of course, we only created the table. Next step is to populate our new

RAIS 3.0 Programmer’s Guide – Part I : Advanced Customization 10 Test also the behavior when modifying the record. Please note that only a warni

RAIS 3.0 Programmer’s Guide – Part I : Advanced Customization 11 letter M. This letter makes the menu node for our protector appear under

RAIS 3.0 Programmer’s Guide – Part I : Advanced Customization 12 To compensate for shifting of primary keys, the concept of evaluators has been intro

RAIS 3.0 Programmer’s Guide – Part I : Advanced Customization 13 Select the table [Evaluator Waste Management], click the button Edit Sel

RAIS 3.0 Programmer’s Guide – Part I : Advanced Customization 14 This is to prevent unintended modification of system fields. If you need

RAIS 3.0 Programmer’s Guide – Part I : Advanced Customization 15 here, please create a new preselection list query for the form [Evaluator Waste Mana

RAIS 3.0 Programmer’s Guide – Part I : Advanced Customization 16 As it is seen, query and statistics results depend very much on ev

RAIS 3.0 Programmer’s Guide – Part I : Advanced Customization 17 open in design mode, please lookup the table name and open the form called

RAIS 3.0 Programmer’s Guide – Part I : Advanced Customization Contents 1 Introduction...

RAIS 3.0 Programmer’s Guide – Part I : Advanced Customization 18 Form Name SUB EDIT Generator Query Name Consistency Check – Generator Type Messag

RAIS 3.0 Programmer’s Guide – Part I : Advanced Customization 19 2.3.1.2 Duplicate generator serial number Example 1 was really simple. Let’s have a

RAIS 3.0 Programmer’s Guide – Part I : Advanced Customization 20 and again run and analyze it. It returns only a record set if our fi

RAIS 3.0 Programmer’s Guide – Part I : Advanced Customization 21 2.3.2 Comments No restrictions apply on how many consistency checks may be

RAIS 3.0 Programmer’s Guide – Part I : Advanced Customization 22 Field Name FK Region ID Parameter Name Region ID Parent Not used any more This s

RAIS 3.0 Programmer’s Guide – Part I : Advanced Customization 23 Form Name Name of the form that contains the combo box Field Name Name of the com

RAIS 3.0 Programmer’s Guide – Part I : Advanced Customization 24 If a combo box field has no query attached, RAIS automatically detects the foreign t

RAIS 3.0 Programmer’s Guide – Part I : Advanced Customization 25 The red box in the picture above highlights the field that will be shown in the mai

RAIS 3.0 Programmer’s Guide – Part I : Advanced Customization 26 Exit Function Dim r Dim d Dim k Dim a Dim m r = DF

RAIS 3.0 Programmer’s Guide – Part I : Advanced Customization 27 Retrieving r is done by looking up the region identifier upon the primary key of the

RAIS 3.0 Programmer’s Guide – Part I : Advanced Customization 1 1 Introduction This document is part of the official programmer’s guide of RAIS 3.0

RAIS 3.0 Programmer’s Guide – Part I : Advanced Customization 28 If d <> "" Then d = "-" & d Forms("I

RAIS 3.0 Programmer’s Guide – Part I : Advanced Customization 29 Another way to test is by means of queries. Create a new query, having the following

RAIS 3.0 Programmer’s Guide – Part I : Advanced Customization 30 Custom forms, as well as standard RAIS forms, allow for public access of all of thei

RAIS 3.0 Programmer’s Guide – Part I : Advanced Customization 31 Manual creation of RAIS tables shall be avoided as the RAIS 3.0 Creator is f

RAIS 3.0 Programmer’s Guide – Part I : Advanced Customization 32 Letter Z is reserved for future RAIS development. Example: Open the table Treview

RAIS 3.0 Programmer’s Guide – Part I : Advanced Customization 33 Label 5 Text for label 5 Query 5 Query for filling combo box 5 Label 4 Text for l

RAIS 3.0 Programmer’s Guide – Part I : Advanced Customization 34 Image Index If this is the first menu entry for use with custom forms, the RAIS

RAIS 3.0 Programmer’s Guide – Part I : Advanced Customization 35 After the new menu has been validated, records that have been added to both the [P

RAIS 3.0 Programmer’s Guide – Part I : Advanced Customization 36 AddExecutableMenu v, "Calculations", "Calculations" AddE

RAIS 3.0 Programmer’s Guide – Part I : Advanced Customization 37 CommandBars("RAIS Menu Bar").Controls(5).Controls(1).Enabled = Not b

RAIS 3.0 Programmer’s Guide – Part I : Advanced Customization 2 The descriptions of the main types of queries are given in the following table. Typ

RAIS 3.0 Programmer’s Guide – Part I : Advanced Customization 38 2.10.2 Comments If forms are opened with the parameter acDialog, they may not loose

RAIS 3.0 Programmer’s Guide – Part I : Advanced Customization 39 Select * from [generators history] where ( ([fk generator type id] = forms![query p

RAIS 3.0 Programmer’s Guide – Part I : Advanced Customization 40 As only the second menu entry is linked to the query parameter form, only one entry

RAIS 3.0 Programmer’s Guide – Part I : Advanced Customization 41 2.11.1.2 Statistic for practice profile Let us now have a look at how the

RAIS 3.0 Programmer’s Guide – Part I : Advanced Customization 42 Query 0 Form Query Parameter Form Image Index 0 And again only one entry in the

RAIS 3.0 Programmer’s Guide – Part I : Advanced Customization 43 After copying the new report from the front end to the creator, modification of the

RAIS 3.0 Programmer’s Guide – Part I : Advanced Customization 44 Please note that SQL statements shall always return search result in the form Primar

RAIS 3.0 Programmer’s Guide – Part I : Advanced Customization 45 • Design the needed customization in an unlocked front-end • Test, debug and valid

RAIS 3.0 Programmer’s Guide – Part I : Advanced Customization 46 3 Copying customizations from a front-end to the creator 3.1 Copying Queries Quer

RAIS 3.0 Programmer’s Guide – Part I : Advanced Customization 47 [RAN - ] [Calculation - ] [Export Selection - ] [Exportable Selection - ] [Exported

RAIS 3.0 Programmer’s Guide – Part I : Advanced Customization 3 • Copy custom objects into the RAIS 3.0 Creator: After custom objects have be

RAIS 3.0 Programmer’s Guide – Part I : Advanced Customization 48 new name. This may easily be avoided by first deleting the form to be

RAIS 3.0 Programmer’s Guide – Part I : Advanced Customization 49 In order for the custom forms to be created upon next run of the creator,

RAIS 3.0 Programmer’s Guide – Part I : Advanced Customization 50 3.4 Copying modules Copying modules from the Front-End into the Creator is

RAIS 3.0 Programmer’s Guide – Part I : Advanced Customization 51 4 Entity Relationship Diagrams The following Entity-Relationship Diagrams are

RAIS 3.0 Programmer’s Guide – Part I : Advanced Customization 52 4. Authorization Types: are defined by relationship from the authorization

RAIS 3.0 Programmer’s Guide – Part I : Advanced Customization 53 4.2 Sources 4.2.1 Radiation Generators 4.2.2 Sealed Sources ManufacturerPK PK Ma

RAIS 3.0 Programmer’s Guide – Part I : Advanced Customization 54 4.2.3 Unsealed Sources ManufacturerPK PK Manufacturer IDNameAddressPhoneFaxeMailCon

RAIS 3.0 Programmer’s Guide – Part I : Advanced Customization 55 4.2.5 Source-Equipment Association 4.3 Authorizations

RAIS 3.0 Programmer’s Guide – Part I : Advanced Customization 56 4.3.1 Authorization Types AuthorizationPK PK Authorization IDU1 Authorization Proce

RAIS 3.0 Programmer’s Guide – Part I : Advanced Customization 57 4.4 Workers PersonPK PK Person IDU1 Regulatory Authority NumberNameBirth DateFK1,I1

RAIS 3.0 Programmer’s Guide – Part I : Advanced Customization 4 2 RAIS Advanced Customizations This section describes advanced customization of RAIS

RAIS 3.0 Programmer’s Guide – Part I : Advanced Customization 58 4.6 Enforcements 4.7 Incidents IncidentPK PK Incident IDU1 Incident NoFK2,I2 FK F

RAIS 3.0 Programmer’s Guide – Part I : Advanced Customization 59 4.8 Service Providers

RAIS 3.0 Programmer’s Guide – Part I : Advanced Customization 5 2.1.1 Examples 2.1.1.1 Protecting deletion of important facilities This example s

RAIS 3.0 Programmer’s Guide – Part I : Advanced Customization 6 Then select and expand the group node Common Tables and click the button Add Table.

RAIS 3.0 Programmer’s Guide – Part I : Advanced Customization 7 This is to prevent unintended modification of system fields. If you need