SQL TRANS 2.1

Category/Domain: | Tools
Scol Engine compatibility: | V2.0c and higher
Updated: | 09/2000

# Function

This module makes it possible to deposit a group of SQL requests in an SQL database. If no errors occur during the transfer, the modifications will be deposited, otherwise the module will backtrack, thus ensuring the integrity of the SQL database.

# Configuration

Figure 1: Main SQL TRANS module interface

BEWARE ! : This library is not provided in the basic Scol Voy@ger/Engine for it requires ODBC support that may not be found on all machines. It is provided in the form of a Scol plugin : "scolsql.dll" that can be downloaded from the following address:

www.cryonetworks.com (SCOL Tools).

- Copy the scolsql….dll file into the Scol/Plugins folder.

- Edit the usm.ini file:

### The usm.ini file may be easily edited owing to the Scol Voy@ger:

Right-click on the blue Scol icon in the systray, then Advanced…, Expert Mode menus.

- Type the following line :

plugin plugins/scolsql….dll SCOLloadSQL

## 1- Database Name: Name of the database defined in ODBC.

2- Login: User name required to access the database; if not entered, "Admin" is used by default.

3- Password: Indicates the password corresponding to the login; "" by default.

#

# Implementation

Action | Function
module.event à SQLTrans.transaction | The database prepares to receive a list of requests and its parameters

Event | Function
SQLTrans.log à module.action | Log of the server's request status

##### Zone

Function

Interface

Assigned

None |  |  |