Navigation:  Programming Cookbook > Database Connectivity > Executing SQL Queries >

Inspecting a Result Set

Previous pageReturn to chapter overviewNext page

The DBResultSet displays in a workspace (via #printOn:) by listing the columns that it contains. However, a better way of viewing it is to use an Inspector since this will also allow you to access the individual rows. Try inspecting the existing result set, rs, to open a Flipper Inspector on to the results.

Note that the Published Aspect Inspector for a DBResultSet is capable of pulling the rows from the database in batches of 10 as you ask for them. Simply click on the Next 10 items entry in the left-hand pane to access each subsequent batch in the result table. The advantage of this behaviour is that it is not necessary for the inspector to pull a (potentially very large) result set into memory all in one go.