skip to main content
DataDirect tools : DataDirect Test : DataDirect Test tutorial : Scrolling through a result set
  

Try DataDirect Drivers Now
Scrolling through a result set
1. From the Connection window menu, select Connection / Create JDBC 2.0 Statement. DataDirect Test prompts for a result set type and concurrency.
2. Complete the following fields:
a. In the resultSetType field, select TYPE_SCROLL_SENSITIVE.
b. In the resultSetConcurrency field, select CONCUR_READ_ONLY.
c. Click Submit; then, click Close.
Get JDBC 2.0 Statement Properties window
3. Select Statement / Execute Stmt Query.
4. Type a Select statement and click Submit. Then, click Close.
Execute SQL Query window with SQL statement
5. Select Results / Scroll Results. The Scroll Result Set window indicates that the cursor is positioned before the first row.
Scroll Result Set window
6. Click the Absolute, Relative, Before, First, Prev, Next, Last, and After buttons as appropriate to navigate through the result set. After each action, the Scroll Result Set window displays the data at the current position of the cursor.
Scroll Result Set window with returned information
7. Click Close.