The Select for Retrieval command queries the database, retrieves data, creates a cursor (buffer), and places in it the rows which match the “where” criteria in the select statement. A record is selected each time the rule is invoked.
When you select the up arrow next to the Select for Retrieval text box, the Select From Table For Retrieval window displays.
SQL User File – the internal ECMap name that provides the link to the database which is queried and from which data is retrieved.
SQL User Record – the internal ECMap name for the specific rows/record/table (in the file/database specified above) which is queried and from which data is retrieved.
SQL Table Name – the name of the database table that corresponds to the internal ECMap file name. This is the actual database table which is queried and from which data is retrieved.
You can use one or more “where clauses” to specify conditions. On each Where Clause tab, enter the following information:
Record Field – the application record field that holds the value that is used as the left side of the conditional statement defining which rows in the database are updated. If you choose Select, the Records/Tables window displays. Double-click a field or drag it and drop it onto the Record Field text box.
Operator – logical operator that relates the left and right sides of the conditional statement defining which rows in the database are updated. The choices in the drop-down list include:
EQ – equal to.
NE – not equal to.
GT – greater than.
GE – greater than or equal to.
LT – less than.
LE – less than or equal to.
Variable – holds the value that is used as the right side of the conditional statement defining which rows in the database are updated. Choose from:
Memory Variable – appears in the first text box, and the Memory Variables window displays next to the Select from Table for Retrieval window. Double-click a memory variable and the program automatically enters it in the second text box.
Record/Field – appears in the first text box, and the Records/Tables window displays next to the Select from Table for Retrieval window. Double-click a field and the program automatically enters it in the second text box.
String Constant – appears in the first text box, and the WinMap window displays next to the Select from Table for Retrieval window. Enter a value in the text box on the WinMap window and select OK. The value is automatically entered in the second text box.
When you finish entering all the information, select Compile Statement and the program constructs the SQL statement in the text box at the bottom of the window.
Select Test Statement to make sure that the program can connect with the database to execute the statement.
