SAPHIR, MySQL VIEW LabVIEW toolkit

SmartSQLVIEW for MySQL features

· SmartSQLVIEW for MySQL toolkit is an add-on to NI LabVIEW that adds capabilities to connect MySQL databases from any LabVIEW program.

· SmartSQLVIEW for MySQL is compatible with the LabVIEW Real-Time Module

· With SmartSQLVIEW for MySQL you can easily connect your test and measurement applications to "the world's most popular open source database".

· SmartSQLVIEW for MySQL is really easy to install. It does not require additional component to be installed but the toolkit itself.

Features

SmartSQLVIEW for MySQL toolkit supports the following features:

· Open connection to database

· Execute SQL queries

· Manage queries with transaction

· Test database communication tool allowing quick communication checking

The toolkit also includes simple request and performance examples

Functions palette

SmartSQLVIEW for MySQL toolkit is located in Connectivity

palette MySQL VIEW

Name	Icon	Help
Open database		This VI attempts to establish a connection to a MySQL database engine running on host. This VI must complete successfully before you can execute any other API VI.
Execute SQL query		This VI executes an SQL query.
Close database		This VI closes a connection to a MySQL database engine previously open.
Create transaction		This VI creates a new transaction. Such transactions usually persist until the next COMMIT or ROLLBACK command. But a transaction will also ROLLBACK if the database is closed or if an error occurs.
Commit transaction		This VI commits all modifications that occurred on the database since the last call of the “Create transaction” method.
Rollback transaction		This VI cancels all modifications that occurred on the database since the last call of the “Create transaction” method.
Get table information		This VI provides information about each non-temporary table.
Get columns information		This VI provides information about each column of a given table.
Ping server		This VI tests the connection and resets the connection inactivity counter in the MySQL server.
Get server statistics		This VI returns some MySQL server statistics.

Examples

SmartSQLVIEW for MySQL toolkit is provided with comprehensive examples demonstrating how to access MySQL database. You can find them browsing "NI Example Finder".

· Simple request to MySQL database: This example demonstrates how you can open/create, insert and retrieve data from MySQL database.