To define the action of a task, you select the appropriate radio button in the Method template panel. EDT uses this action type to determine which SQL statements to generate, for example an INSERT statement when adding data to a table or an UPDATE statement when editing existing data.

The possible actions of a task are dependent on the type of destination:

Action

Data Destination Type

Microsoft SQL Server,

MySQL

Oracle

DBII

Microsoft
Access,

Microsoft
FoxPro,

Dbase

Microsoft
Excel Worksheet

CSV/Text file

Add / transfer data to table

Available

Available

Available

Available

Send data to stored procedure

Available

N/A

N/A

N/A

Edit / update data table

Available

Available

NA

N/A

Edit / update / insert data table

Available

Available

N/A

N/A

Load / report data only

Available for all data sources - EDT Version 3.0 onwards

Add / transfer data to Table

This method can be used to transfer data from any source including the windows clipboard.

EDT will generate the SQL insert for each row.

EDT will automatically Validate the data against the destination table column data types.

Send data to stored procedure

This method can be used to send data to the stored procedure from any source including the windows clipboard.

EDT will generate the SQL EXEC statement for each row.

The stored procedure should a value of 0(zero) on success, or -1 on failure.

EDT will automatically Validate the data against the stored procedure parameter data types.

Edit / Update data table

This method is used to Edit existing table data.

(Note that for more advanced tasks it is common to send the data to a stored procedure that handles the data update, passing each column value as a stored procedure parameter).

EDT will generate an SQL UPDATE statement for each row.

By default only modified rows will be sent.

EDT will automatically Validate the data against the destination table column data types.

Edit / Update / insert data table

This method is used to Edit existing data and also Insert new row data.

(Note that for more advanced tasks it is common to send the data to a stored procedure that handles the data update, passing each column value as a stored procedure parameter).

EDT will generate SQL UPDATE and INSERT statements for each row, depending on if a row with a matching Key value in the destination table already exists.

By default only modified rows will be sent.

EDT will automatically Validate the data against the destination table column data types.