Working With More Than One Row – select3.sqb

The programs select1.sqb and select2.sqb each returned one row of data when you entered a customer number. Compile and run the program

select3 to receive data on more than one row. (Remember to compile and run the create program if you haven’t already. This generates the data for the sample programs.)

This program demonstrates

working with cursors
the FETCH statement

When you run select3.acu, you are asked for a starting customer number, and the program returns information on all customers with the number you provide, or higher, as shown below:

Note: The behavior and duration of a cursor can be affected by the state of transaction processing for your data source. For example, many databases do not have cursors that maintain their state across a commit or rollback. Refer to you database documentation for more details.