Handbook
Glossary
Result sets
Furnace framework
»
Database library
»
Low-level database protocol
Prev:
query-results ( query -- result-set )
Result sets are the encapsulated, database-specific results from an SQL query.
Two possible protocols for iterating over result sets exist:
Random access result sets
Sequential result sets
Query the number of rows or columns:
#rows
( result-set -- n )
#columns
( result-set -- n )
Traversing a result set:
advance-row
( result-set -- )
more-rows?
( result-set -- ? )
Pulling out a single row of results:
row-column
( result-set column -- obj )
row-column-typed
( result-set column -- sql )