^{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