Progress
Embedded SQL-92
Guide and Reference
OPEN a Cursor
The OPEN statement sets a cursor to the open state. When a cursor is opened, the SELECT statement associated with the cursor is executed producing a result set. This result set is referred to as the active set. Executing the SELECT statement uses the current program variables and leaves the cursor positioned just before the first row in the active set.
When the cursor is in the open state, any changes to the program variables of the SELECT statement do not change the rows retrieved in the active set.
EXAMPLEThe following example shows an OPEN operation on the cursor custcur:
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |