Welltech SIPIVR 6800GS V.2.1 - Manual (Page 97)

96
Alias Name: Used to identify a DB connection
Execute Now: Check this box, the SQL Command will execute
immediately
SQL Command: SQL Command. “$$” is a reserved word. It is used as a
pair to indicate it is a variable instead of value. For example, you declare
a variable: var_1=“Filed1” at first. When you type “select $$var_1$$ from
some Table” in SQL Command field, the system replace $$var_1$$ to
“Field1”. Thus the inputted SQL Command will be translated to “select
Field1 from some Table”.
Success Goto: This read-only field contains the component ID that takes
control following successful completion of the current component
Not data Goto: Next component to be executed if no data found
Error Goto: Next component to be executed if an error is occurred
Remark: Description or remark for this component
7.4 SQL Fetch
[Introduction]
Retrieve data from database cursor. The output field is defined by SQL
Execution and Filed Mapping components.
[Description]
Right-click the SQL Fetch component, the screen appears as Figure 7-4.
Figure 7-4
Alias Name: Used to identify a DB connection
Retrieve Mode:
next: Fetch the next row of the result set
first:
Fetch the first row of the result set
prior: Fetch the prior row of the result set
last:
Fetch the last row of the result set
No Data found Goto: Next component to be executed if no data found
Success Goto: This read-only field contains the component ID that takes
control following successful completion of the current component
Error Goto: Next component to be executed if an error is occurred
Remark: Description or remark for this component