ODBC Real Time I/O Link Settings
The ODBC Real Time I/O Link Settings consents the setting up of dynamic links between the Movicon Real Time DB and database file data fields in the preferred DB format.
To modify the ODBC Real-Time DB settings, select the Real Time DB group in the 'Project Explorer' window with the mouse and use the Movicon 'Properties Window'.
|
|
The Database file will be organized with a column containing the names of variables (defined in the name box in the variables' General Properties) and a series of columns containing their current values and corresponding statistics.
When using MS Access as the preferred database, Movicon will create the Database file in the project's "DATA" folder for default with the following name:
ProjectName_RealTimeDB.mdb
To change the ODBC link and the linked file use the "ODBC DSN" properties described below:
|
Keep the DB Connection open
See paragraph "DBMS Settings for Recording data on DataBase" in the section on "Historical Log Management".
Max. Error Number
See paragraph "DBMS Settings for Recording data on DataBase" in the section on "Historical Log Management".
Max. Transactions
See paragraph "DBMS Settings for Recording data on DataBase" in the section on "Historical Log Management".
Max. VarChar Precision
See paragraph "DBMS Settings for Recording data on DataBase" in the section on "Historical Log Management".
ODBC DSN
See paragraph "DBMS Settings for Recording data on DataBase" in the section on "Historical Log Management".
ODBC DSN User
See paragraph "DBMS Settings for Recording data on DataBase" in the section on "Historical Log Management".
Table Name
This setting is used for inserting the Table's name. If nothing is entered, the "RTVar" default name will be used instead.
Name Column
This setting is used for inserting a name for the DBMS table's Variable Name column. This column reports the name of the variables enabled with the ODBC Real Time I/O Link function. Each record in the table represents a variable. If nothing is entered the 'Name' default name will be used instead.
Value Column
This setting is used for inserting the name of the DBMS table's Variable Value Column. This column reports the variable's value enabled with the ODBC Real Time I/O Link function. If nothing is entered, the "Val" name for default will be used instead.
Min. Value Column
This setting permits you to insert the name of the Min. Value Column of variables in the DBMS table. This column shows the minimum value of variables enabled with the ODBC Real Time I/O Link function. The "MinVal" default name will be used if left blank.
Max. Value Column
This setting permits you to insert the name of the Max. Value Column of variables in the DBMS table. This column shows the maximum value of variables enabled with the ODBC Real Time I/O Link function. The "MaxVal" default name will be used if left blank.
Ave. Value Column
This setting permits you to insert the name of the Ave. Value Column of variables in the DBMS table. This column shows the average value of variables enabled with the ODBC Real Time I/O Link function. The "AveVal" default name will be used if left blank.
Total Time ON Column
This setting permits you to insert the name of the Total Time ON Column variable from the DBMS table. This column shows the total ON time of the variables enabled with the ODBC Real Time I/O Link function. The "TotTime" default name will be used if left blank.
Last Time ON Column
This setting permits you to insert the name of the Last Time ON Column Variable of the DBMS Table. This column shows the last Time ON of variables enabled with the ODBC Real Time I/O Link function. The "LastTime" default name will be used if left blank.
Recreate All
This command regenerates the tables containing data of the variables enabled with the ODBC Real Time I/O Link functionality. Any existing data will be lost.
