The application examples implement a visualization for monitoring and control purposes.
This section provides a brief description of each function. In addition, refer to the visualization screen.
The visualization Visu_Start > Settings consists of two sections:
|
Section |
Description |
|---|---|
|
Database to be accessed |
Enter the name of the schema and the name of the table to access the database. These parameters are concatenated into the SQL query in the application program. |
|
SQL Gateway connection parameter |
The connection parameter for the SQL Gateway consists of the IP address of the PC where the SQL Gateway is running and the port the gateway is listening. Further you have to enter the connection name which is specified for the connection between the SQL Gateway and the SQL database. |
Enter the parameter according to your system configuration.
On the visualization screen Visu_Start > Read access, three lines are provided to enter the SQL query. Optionally a preformed query can be loaded by clicking the respective button.
By clicking Execute Query, the instance of FB_SqlDbRead is triggered and the entered SQL query is sent to the specified database connection.
On the visualization screen Visu_Start > Write access, three lines are provided to enter the SQL query. Optionally a preformed query can be loaded by clicking the respective button.
By clicking Execute Query, the instance of the FB_SqlDbWrite is triggered and the entered SQL query is sent to the specified database connection.
