GLOSSARY OF TERMS – CX-Supervisor User Manual OMRON
Page 330 Release 2.0
Constant Within CX-Supervisor, a constant is a point within the script language that
takes only one specific value.
Control Object In CX-Supervisor, a control object is applied in the development
environment and can be a pushbutton, a toggle button, a slider, a trend
graph, a rotational gauge or a linear gauge. Essentially a control object can
be a complex graphic object consisting of a number of primitive graphic
objects, which provides user interaction.
CX-Server An advanced communications management system for OMRON PLCs
providing facilities for software to maintain PLC device and address
information and to communicate with OMRON PLCs and their supported
network types. CX-Server supports CS-Series PLCs.
Database connection A Database connection (or Connection for short) contains the details used
to access a data source. This can either be via Data Source Name (DSN),
filename or directory.
Database Connection Level A Database Connection Level is a string which determines what level in
the database tree hierarchy is to be operated on. Some examples are listed
below:
"Northwind" Connectionlevel
"CSV.Result" Recordset level
"Northwind.Order Details.OrderID" Field level
"Invoice.Data Types" Schema level
Database Recordset A Database recordset (or Recordset for short) is a set of records. This
could either be an actual Table in the database, or a table that has been
generated as a consequence of running a Query.
Database Schema A Database Schema (or Schema for short) obtains database schema
information from a Provider.
Database Server Query A Database Server Query (or Server Query for short) is a query that is
stored in the actual Database. They are pre-defined and added by the
database designer which means they are 'fixed' for the duration of a project.
Server Queries may have pre-defined 'Parameters', which allow criteria to
be passed to the query at runtime e.g. values to filter, allowing one query to
be used to produce different results. Each pre-defined parameter must
have a Parameter Association defined. Because these queries are stored in
a compiled and tested form they are more efficient and therefore
preferential to running a SQL Query.
Database SQL Query A Database SQL Query (or SQL Query for short) is interpreted
dynamically at runtime. The SQL Text can be modified at runtime,
enabling different Queries to be run for varying situations however, the
SQL Text has to be compiled on the fly every time it is executed and
consequently is less efficient than a Server Query.