^{DBRequest 1.0}

Category / Domain:	DB
SCOL Voy@ger Compatibility:	V 3.5 or above
Update:	05/2001

Function

This module allows SQL requests in a data base. The module must be used in conjunction with DBEditor that manages the data base and DBImport that allows import of tables from one data base to another.

Configuration

Figure 1: DBRequest Module Interface

�

SELECT DISTINCT

If this box is checked, the SQL request will recover only the lines in the data base that are different from one another. This avoids recovering duplicates. If the box is not checked, all lines matching the request will be recovered.

Implementation

Action	Function
module.event à DBRequest.start	Starts module at customer site.
module.event à DBRequest.show	Displays module interface at customer site. The link must be edited to insert a parameter: 1- Double-click on link to display property window: 2 - Select link in area � 3 - Enter the following parameters in area ‚: Table name Name of attributes in data base used to create SELECT; they must be entered as: table name field1 field2 field3 For example: product_description name description sellingprice If no parameter is entered, the last request loaded is displayed. If the parameter is preceded by the mention #MySqlReq#, the request is displayed and it can be completed. 4- Click on X in the top right hand corner to save modifications and close the window.
module.event à DBRequest.hide	Hides module interface (blanking).

Event	Function
DBRequest.in à module.action	Module is initiated at customer site and triggers an action.
DBRequest.entering à module.action	Each time a customer is created, it triggers an action.
DBRequest.shown à module.action	Display of module interface triggers an action.
DBRequest.hidden à module.action	Disappearance (blanking) of module interface triggers an action.
DBRequest.out à module.action	Module destroyed at customer site triggers an action.

Area	Function	Interface	Assignment
DBRequest.product	Module interface	Server	No