File:RDB connection.ANA

Connection module for writing variable results into the Result database. You can freely open and use the module, but you cannot actually write information into the Result database unless you have a password.

Note that the necessary variable, index, dimension, and run information will be asked. You must fill in all tables before the process is completed.

Note! You can insert several variables at the same time. Each variable MUST have at least one index.

For reading results from the database, see RDB reader.ANA.

SQL for Dimension table:

SELECT Dim_id, Dim_name 
FROM `Dimension` 

SQL for Indices table:

SELECT Ind_id, Ind_name, Dimension.Dim_id, Dim_name 
FROM `Index`, Dimension
WHERE `Index`.Dim_id=Dimension.Dim_id 

SQL for Locations table:

SELECT Loc_id, Location, Dimension.Dim_id, Dim_name 
FROM `Location`, `Dimension` WHERE Location.Dim_id = Dimension.Dim_id 

SQL for Variables table:

SELECT Var_id, Var_name 
FROM `Variable`