Super Systems SuperDATA - Manual (Page 92)

Super Systems Inc Page 92 of 172 Super Data Operations Manual
ODBC Connections
The ODBC (Open Database Connectivity) source is a very powerful tool that can get data out of an external database
system of almost any type. The user must first create a Data Source Name on the system. This identifies the
database or tables that will be accessed via the ODBC Reference.
Properties
Name - The Name property makes the object easier for the RealEdit programmer to identify. Often it is a good idea
to use the same name for related objects, such as a Data Value that represents a Constant.
DSN - Data Source Name defined in the computer’s ODBC setup
SQL Query - Text SQL query which makes the selection from the database
Data Type - Represents the expected type of data. Data Types are:
Number
Text
Logical
Date/Time Serial Number
Alarm Code
Data Value %1-%4 - The Data Value which replaces %n in the SQL query.