OLE DB FETCH NEXT
In the singleton SELECT, you specify variables to hold values
for the columns within the selected row. The syntax of the FETCH
statement is similar to the singleton SELECT statement syntax. Values
are returned INTO a specified list of variables.
Example
This example continues the previous example by retrieving
some data:
|
1 |
// Go get the first row from the result set. <br>FETCH emp_curs INTO :emp_id_var, :emp_name_var; |
If at least one row is retrieved, this FETCH places the values
of the emp_id and emp_name columns from the first
row in the result set into the PowerScript variables emp_id_var
and emp_name_var. FETCH statements typically occur in
a loop that processes several rows from a result set (one row at
a time), but this is not the only way they are used.
What happens when the result set is exhausted?
FETCH returns +100 (not found) in the SQLCode property
within the referenced transaction object. This is an informational
return code; -1 in SQLCode indicates an error.
Closing the cursor
The CLOSE statement terminates processing for the specified
cursor. CLOSE releases resources associated with the cursor, and
subsequent references to that cursor are allowed only if another
OPEN is executed. Although you can have multiple cursors open at
the same time, you should close the cursors as soon as possible
for efficiency reasons.