Download NiceMemMaster User Guide

Defines the SQL statement --or query-- to execute. You can use statements from Data Manipulation
Language (DML) to execute queries upon existing database tables. You can use the standard SQL
statements, such as SELECT, INSERT, DELETE and UPDATE, including joins, function and keywords. You
cannot use statements from Data Definition Language (DDL) to create databases and tables
(CREATE DATABASE, CREATE TABLE), or to delete them (DROP TABLE).
Click the Test button in the toolbar to open the Data Preview section, where you can test execution of
SQL statements. Click the Insert variable button to insert trigger variables into the SQL statement.
The editor control allows you to Export/Import the SQL statements to/from file.
Execution mode
Specifies the explicit mode of execution. With some complex SQL queries it becomes increasingly
difficult to automatically determine what is the supposed action. If the built-in logic has troubles
identifying your intent, manually select the main action.
l Automatic. The application will try to automatically determine the action.
l Returns set of records (SELECT). You expect to receive data set with records.
l Does not return set of records (INSERT, DELETE, UPDATE). You are executing query that will
not return the records. You want to either insert new records, delete or update existing
records. The result will be status response about how many rows very affected by your query.
Save Result to Variable
Defines the variable that will store the result of the SQL statement.
l Result of SELECT statement. When you execute the SELECT statement, the result will be data
set of records. You will receive the CSV-formatted text contents. The first line will contain field
names returned in a result. The next lines will contain records.
To extract the values from the returned data set and use them in other actions, define the
Configuring Structured Text Filter and execute action Use Data Filter upon the contents of
this variable.
l Result of INSERT, DELETE and UPDATE statements. When you use INSERT, DELETE and
UPDATE statements, the result will be number indicating the number of records affected in the
table.
Data Preview
This section allows you to test the execution of your SQL statement upon a live data. To protect the
data from accidental updates, make sure the option Simulate execution is enabled. The statements
INSERT, DELETE and UPDATE will execute, so you will have feedback about how many records will be
affected, then the transactions will be reversed.
If you use trigger variables in the SQL statement, you will be able to enter their values for the test
execution.
Action Execution and Error Handling
l Enabled. Specifies if the action is enabled or disabled. Only enabled actions will execute. You
can use this functionality for testing.
- 69 -