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