Of course, the fact that a specific driver is installed does
not give you access to the database if the database needs
also the installation of a server. For example, Microsoft
SQL Server databases need a server to be installed.
Example of database installation : installation of MySQL
:
Download the package for Windows from :
http://www.mysql.com/downloads/mysql-4.0.html
Download the drivers ODBC from :
http://www.mysql.com/downloads/api-myodbc-3.51.html
After installing both, launch winmysqladmin.exe
Go in the ODBC dialog (through the setup of a device or by
the ODBC icon in the Control Panel) and create an alias for
the database that you want to use.
Example on how to use an Excel spreadsheet as a database:
Create a spreadsheet. In the first row, enter the names of
the fields. Select the cells that you have created with the
mouse and give a name to this selection ( in the upper left
of the spreadsheet ). Your first table is created.
Do it for every table and save your file.
In Manager, create a device. Go in the ODBC dialog through
the setup of the device. Create an alias using the Excel ODBC
driver and select the file that you have just created. Use
this alias to connect to this database.
> Top
Creation
(Device) :
The setup of the device is done through this dialog box
:

The setup dialog allows the user to define the default Database,
User Name and Password for this device. These are not mandatory
and can be specified via the Connect command.
To setup default device properties :
- Select the default database in the database list (Click
on the "Setup ODBC" button to manage the installed
ODBC drivers if needed) or type the default database name
in the Database edit box.
- Type the default User Name
- Type the default Password
The connection panel allows to specify whether
the connection to the database is regularly checked and how
often this check is performed.
> Top
Graphical
User Interface:
Device Control
Panel
This MxM provides
a Device Control Panel can be displayed either as a stand
alone window or inside a User Screen Contenair object with
the "Device Control" Manager command. Note: See the Manager
Help menu for details about using this command.
The Device Control Panel allows testing SQL
queries against the Database connected to the device (via
the "Connect" command).

Type the required SQL query and click on the
"Execute Query" button.
Error messages are displayed in the status
bar at the bottom of the control panel.
> Top
Commands
(List Of) :
The commands marked with * work only if a table is
active ( i.e. a previous request has returned a valid result).
Connect Database :
Description: Connects to a database.
Parameters:
Database [Type: String] : The database (ODBC Data
Source) to connect to.
User name [Type : String] : The login name for this
database.
Password [Type: String] : The login password for
this database.
Usage : If the Database, User Name or Password
are empty, the default values defined in the device setup
are used to establish the connection. Note also that with
some Databases, it is not necessary to specify the login
and the user name which are either set up in the ODBC Data
Source definition or implied by the target database engine.
Note : A wizard allows to select one of the existing
ODBC DataSource.

Disconnect :
Description Terminates the communication
with the database and closes the connection.
Parameters: No Parameters.
Get Database List :
Description Get the list of Databases
(ODBC Data Sources) available on this workstation.
Parameters: No Parameters.
Usage : After this command, the Databases
system variable contains the list of the available Databases.
Get Table List :
Description Get the list of tables
available with the opened Database.
Parameters: No Parameters.
Usage : After this command,
the Tables system variable contains the list
of the available Databases.
Get Table :
Description: To get the content of
a table.
Parameters:
Name [Type : String] : Name of the table to get
Usage: The name of the table must be an existing
table. The existing tables are listed into the variable
Tables exported by the MxM.
Note : A wizard allows to
select one of the available tables in the connected database.

SQL Request :
Description: To send a SQL command
to the current database.
Parameters:
Request [Type : String] : String containing the SQL
command
Return Result [Type : String] : Optional return string
which will contain the SQL Result Set (Fields are separated
by a TAB character (09) and records are separated by CR/LF
(0D, 0A) character pair ).
Usage: The request must comply with the SQL syntax.
The record set returned by the command (if any) is stored
internally in the device and the Current Record index is
set to the first record of the record set (0). The
record set is displayed in the Device Control Panel.
Set Current Record * :
Description: Sets the current record
index.
Parameters:
Mode [Type: Enum]: Record access mode
Available values:
"By Index": go to the record whose index is
specified in the record index parameter
"Next Record": go to the next record in the
record set
"First Record": go to the first record of the
record set
Record index [Type: Integer]: The
index of the record to set (0 for the first record of the
record set).
Usage: This command can be used
to navigate through the current record set. The RecordIndex
and FieldValue system variables are updated after
this command is executed.
Get Field *:
Description: Reads a field from the
current record.
Parameters:
Mode [Type: Enum]: Field access mode
Available values:
"By Index": gets the field whose index is specified
in the index parameter
"By Name": gets the field whose name (column
name) is specified in the Field Name parameter
Field Name [Type: String]: Name of
the field (column name)
Field Index [Type: Integer]: The
index of the field to read (0 for the first field)
Return String [Type: String]: String that will contain
in return the content of the field (optional).
Usage : The FieldValue system variable is also
set to the content of the specified field after this command
is executed.
Note : A wizard allows to select
one of the available field names (column names) for the
current record.

> Top
Variables
(List Of) :
Status:
Type : Enum.
Description : Status of the last request
Available values :
"Not Connected": the database is not connected
"Ready": the database is connected and ready to
receive requests
"Error": there was an error while executing the
last command
"Busy": the device is executing a command
LastError:
Type: String
Description: Last error message, when Status
value is Error.
Databases:
Type: String.
Description: List of the databases (ODBC Data Sources)
available on the system.
Tables:
Type: String.
Description: List of the names of the tables present
into the current database.
FieldNames:
Type: String.
Description: List of the names of the fields of the
current table. (Names of the columns).
FieldCount:
Type: Integer.
Description: Count of fields in each record of the
current table. (Count of columns)
RecordCount:
Type: Integer.
Description: Count of records of the current record
set returned by the last SQL request. (Count of rows)
RecordIndex:
Type: Integer.
Description: Current Record index. (Row).
FieldIndex:
Type: Integer.
Description: Current Field index. (Column)
FieldValue:
Type: String.
Description: Content of the current selected cell
of the current table.
> Top
Support
(Difference with previous versions) :
V 1.0.1:
- Bug fixed: SQL requests are limited to 1024 characters
V 1.0.2: