Connection Information

To perform the requested action, WordPress needs to access your web server. Please enter your FTP credentials to proceed. If you do not remember your credentials, you should contact your web host.

Connection Type

ODBC Cursor statements – PB Docs 2019 – PowerBuilder Library

ODBC Cursor statements – PB Docs 2019

ODBC Cursor
statements

In embedded SQL, statements that retrieve data and statements that
update data can both involve cursors. Not all backend DBMSs support cursor
statements.

Retrieval statements

The retrieval statements that involve cursors are:

  • DECLARE cursor_name CURSOR FOR …

  • OPEN cursor_name

  • FETCH cursor_name INTO …

  • CLOSE cursor_name

Update statements

The update statements that involve cursors are:

  • UPDATE … WHERE CURRENT OF cursor_name

  • DELETE … WHERE CURRENT OF cursor_name

See also

ODBC Retrieval using
cursors

ODBC FETCH
NEXT

ODBC FETCH FIRST, FETCH
PRIOR, and FETCH LAST

ODBC Update


Document get from Powerbuilder help
Thank you for watching.
Was this article helpful?
Subscribe
Notify of
guest
0 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x