SQL TRANS 2.1
Category/Domain: |
Tools |
Scol Engine compatibility: |
V2.0c and higher |
Updated: |
09/2000 |
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.
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:
Right-click on the blue Scol icon in the systray,
then Advanced…, Expert Mode menus.
-
Type the following line :
plugin plugins/scolsql….dll SCOLloadSQL
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.
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 |
|
|
|