Driver dialog SqlDrv-Variablen

In the variable list, the allocation between the database variable (cleartext name) and the zenon variable (memory number) is defined.

Parameters	Description
New	With this button new Items can be created.
Name	Variable name
Marker number	Marker number that identifies the variable by way of the property offset
Data type	Possible data types see "Objects for process variables in zenOn"

Both the name and the memory number have to be unique to establish a unique relation between the zenOn variable and the database variable.

Parameters	Description
Change	Enables later editing of Items.
Delete	Enables deleting of Items.

SQL database:

In the SQL database to tables for the data exchange with zenOn have to be created. Both have the same format, but the one will only be read by zenOn and the other will only be written by zenOn. The database and the names of the tables can be configured.

The fixed format of the tables is described in the following list:

Name	Data type	Usage
ID	Long Integer	ID with autoincrement (is not set when pasting)
NAME	Text	Name of the variable (exactly as in the variable list)
DATUMZEIT	Date/Time	Time stamp without milliseconds
ZEIT_MS	Integer	Milliseconds for the time stamp
WERT	Text	Value of the variable (format depends on data type)
STATUS	Number	Status flags of the variable
ACK_SRV	Number	Set to 1 after configured server has read (only for redundant operation!)
ACK_SB	Number	Set to 1 after configured standby server has read (only for redundant operation!)
INSERTZEIT	Date/Time	Standard value Now(), time of insertion of the line (only for redundant operation!)

Format of DATUMZEIT: DD.MM.YYYY HH:mm:ss

The columns of the tables must be completely full during operation.