Progress
SQL-92
Guide and Reference
CLOSE Statement
Closing a cursor changes the state of the cursor from open to closed.
SYNTAX
cursor_name
An identifier named earlier in a
EXAMPLEDECLARE
CURSOR
statement and anOPEN
CURSOR
statement.This example is a code fragment from the
seldone
routine in the sample program 4DynSel.pc. The complete source for sample program,4DynSel.pc
, is listed in Appendix A of the Progress Embedded SQL-92 Guide and Reference .
NOTES
- Only a cursor in the open state can be set to the closed state.
- When a transaction ends, any cursors in the open state are automatically set to the closed state.
- When a cursor is in the closed state, you cannot perform FETCH, DELETE, or UPDATE operations using that cursor.
- It is good practice to close cursors explicitly.
AUTHORIZATION
None (See AUTHORIZATION for the OPEN Statement)
SQL COMPLIANCE
SQL-92
ENVIRONMENT
Embedded SQL-92 only
RELATED STATEMENTS
DECLARE CURSOR Statement, OPEN Statement, FETCH Statement, positioned UPDATE Statement, positioned DELETE Statement
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |