Navigation:  Business Operations > Transfer Manager >

Triggers

Training Manuals Alphabetical Function List Back Print this Topic Previous topicOne level upNext topic
Show/Hide Hidden Text

On this tab the following fields can be viewed:

 

hmtoggle_plus1Apply

When deleting triggers and apply is clicked, the transfer set name is deleted from the Transfer Trigger table.

 

When inserting triggers and apply is clicked, the transfer set name, trigger state, trigger sequence, and trigger type are inserted in the Transfer Trigger table.

hmtoggle_plus1Triggers Grid

The transfer triggers are used to initiate events based on the state of transfers. The states of triggers you can specify are "Before Transfer", "When Successfully Transferred" and "When Not Successfully Transferred".

 

These triggers are not to be confused with the SQL triggers.

 

SEQUENCE

The triggers are executed in the sequence specified.  When deleting a trigger make the "Sequence" zero and click the "Apply" button to perform the physical delete.

 

 

STATE

The state indicates a specific event that occurs during the execution of a transfer which results in the trigger being executed.

 

The states of triggers you can specify are "Before Transfer", "When Successfully Transferred" and "When Not Successfully Transferred".

 

 

TYPE

The type indicates the action to be initiated when the specified state exists.  The trigger types can be one of the following:

 

1.  "Mail" (System mail and not e-mail)

2.  "SQL Command"

3.  "Shell"

4.  "Object Call"

5.  "Call Next Transfer Set"

 

According to your trigger type selection, the relevant fields to be filled in will be enabled.

 

BYPASS TRIGGERS

This column is enabled when the type selected is "SQL Command".  When checked and the SQL command specified in the "Text/SQL/File Name/Object Method and Parameters" column results in inserts, updates, or deletions the triggers on the applicable tables will not be executed.

 

This setting is not to be confused with the "Bypass Triggers on Insert and Delete" on the "Advanced Settings" tab.

 

MAIL RECIPIENT/TRANSFER SET

This column is enabled when the type "Mail" or "Call Next Transfer Set" is selected.

 

When the type "Mail" is selected, the combo is populated with the surname, first name, middle initial and employee ID from the Employee Master table where the status is Active "A" or Unavailable "U".

 

When the type "Call Next Transfer Set" is selected, the combo is populated with the transfer set name and description from the Transfer Header table.

 

OBJECT NAME

This column is enabled when the type "Object Call" is selected.  The user must enter a Visual Basic object name.

 

SERVER (SQL AND NEXT TRANSFER SET)

This column is enabled when the type "SQL Command" or "Call Next Transfer Set" is selected.  The server is the computer name of the server where the destination database is located.

 

DATABASE (SQL AND NEXT TRANSFER SET)

This column is enabled when the type "SQL Command" or "Call Next Transfer Set" is selected.  The database is the name of the destination database.

 

USER (SQL AND NEXT TRANSFER SET)

This column is enabled when the type "SQL Command" or "Call Next Transfer Set" is selected.  The user is the logon ID on the server specified (when working with tables,

the user must be a system administrator).

 

PASSWORD (SQL AND NEXT TRANSFER SET)

This column is enabled when the type "SQL Command" or "Call Next Transfer Set" is selected.  The password is the password required by the specified user to gain access to the specified database.

 

TEXT/SQL/FILE NAME/OBJECT METHOD AND PARAMETERS

When the type of trigger is "Mail" enter the message text in this column.

 

When the type is "SQL Command" enter the complete SQL string to be executed.

 

When the type "Shell" is selected, enter the executable file name.  It is necessary to specify the full path if the file is not located in a folder that is not part of your system path.

 

When the type is "Object Call" enter the object method and the subsequently required parameters.

 

When the type is "Call Next Transfer Set" enter the user ID and flags in the following format:

 

"~System_User_ID~Flag1~Flag2"

 

Where Flag1 is "0" (No) or "1" (Yes), it indicates whether error messages should be displayed when executing the transfer set called and Flag2 is "0" (No) or "1" (Yes), it indicates whether to continue the transfer once an error occurs.  This value is only effective if Flag1 is "0" (No).

 

TEST TRIGGER

When clicked, the "Test" button will simulate the trigger.

 

When the type is "Mail" the subject of the mail message will be "Test Transfer Trigger".  When the type is "Shell" the application will be opened.

 

For all other types it will try to access the database or object with the specified parameters.