1.5 Result-set collections

1.5.2 Result-set policy class

Applications use result-set policy classes to specify the behavior and performance characteristics of a result set, as well as its type. The type of the result set is determined by the result-set policy object. The type of the record object is determined by the coercion-policy slot of <sql-statement>.

If result-set-policy.scrollable? is #t, the result set will be an instance of <scrollable-result-set> otherwise it will be an instance of <forward-only-result-set>. If statement.coercion-policy ~= $no-coercion then the record will be an instance of <coercion-record>; otherwise, it will be an instance of <record>.

Table 1.5 Result set policies and classes.
Scrollable?	Coercion policy	Result set class
#f	#f	<forward-only-result-set>
#t	-	<scrollable-result-set>