ODBC FETCH FIRST, FETCH PRIOR, and FETCH LAST – PB Docs 2019

ODBC
FETCH FIRST, FETCH PRIOR, and FETCH LAST

In addition to the conventional FETCH NEXT statement, the ODBC
interface supports FETCH FIRST, FETCH PRIOR, and FETCH LAST
statements.

What happens if you only enter FETCH?

If you only enter FETCH, PowerBuilder assumes FETCH NEXT.

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.

See also

ODBC FETCH
NEXT

Document get from Powerbuilder help

Thank you for watching.

Powerbuilder Documentation 2019

August 21, 2023

Was this article helpful?

Connection Information

ODBC FETCH FIRST, FETCH PRIOR, and FETCH LAST – PB Docs 2019

ODBC
FETCH FIRST, FETCH PRIOR, and FETCH LAST

What happens if you only enter FETCH?

My Website Links