Retrieves data from memory, one row at a time, then passes it to the next action cell (such as Format String) for processing.
Fetch Query Result
|
|
Retrieves data from memory, one row at a time, then passes it to the next action cell (such as Format String) for processing. |
Use this after a Database Query, Execute Query or Data Management action cell has been used to perform a 'Select' query for retrieving data from a database table. The action cell performing the query populates a file in memory with the results and optionally returns a value indicating the number of rows found. The query populates the variables defined to hold returned values with values taken from the first row found.
Select the Query Statement to Fetch
Select the query whose results you want to fetch.
Record Number
Enter the row to fetch. (If you have selected the 'Explicit' Record Selector option (see below), use a literal value preceded by =, or an integer variable.)
Result Row
Optionally, enter an integer variable to hold the row number of each returned result. Row numbering begins at 1.
Record Selector
|
Selector |
Description |
|
First |
Fetches the first row. |
|
Last |
Fetches the last row. |
|
Explicit |
Enables the Record Number field for specifying the row to fetch. |
|
Previous |
Fetches the last row, the preceding row, and so on down to the first row, after which the ‘End of file’ exit route is taken. |
|
Next |
Fetches the first row, the next row, and so on up to the last row, after which the ‘End of file’ exit route is taken. |
|
Exit point |
Taken |
|
Complete |
When the required row has been fetched successfully. |
|
End of File |
When every row has been fetched successfully. |