Advanced PowerBuilder

Scrollable Cursors

You can also make a cursor scroll. It can move forwards or backwards through the result set, or move to an absolute or relative position in the result set. In other words, an application can retrieve the next or previous row, retrieve a specific row of data, or retrieve a row of data that is at a specified distance from the current row.

Even though PowerBuilder supports scrollable cursors, being able to use them depends on the back-end support. You can use the following commands while using scrollable cursors:

• FETCH PRIOR
• FETCH FIRST
• FETCH NEXT
• FETCH LAST

If you don't specify any clause after the FETCH, it is NEXT by default. Sybase System 10 doesn't support scrollable cursors, but Adaptive Server Anywhere supports scrolling to an absolute position or relative position in the cursor result set.

Home	Previous Lesson: Cursors and Transaction Objects Next Lesson: Updating Through a Cursor