The csr_disp_scrollcurs.c sample program uses a scrollable cursor to retrieve data from the authors table in the pubs2 database. It performs the following:
It sends a canned query to the server to open a cursor.
It processes the results using the standard ct_results while loop.
It binds the column values to program variables.
It fetches and displays the rows in the standard ct_scroll_fetch while loop.
This example uses a single prefetch buffer and regular program variables. Following is the canned query:
select au_fname, au_lname, postalcode
from authors
For more information about this sample program, see the leading comments in the example source file.
This example requires Adaptive Server version 15.0 or
later, with scrollable cursor support and the pubs2 database.
