| db resultSet row |

db := NBSQLite3Connection openOn: ':memory:'.
[ db basicExecute: 'create table x (xk integer primary key, iv integer, tv text)'.
  db beginTransaction.
  db execute: 'insert into x values (NULL, ?, ?)'
    with: #(1 'two').
  db execute: 'insert into x values (NULL, ?, ?)'
    with: #(2 'three').
  db commitTransaction.

  resultSet := db execute: 'select * from x'.
  [ (row := resultSet next) isNotNil ] whileTrue: [
    | xk iv tv |
    xk := row at: 'xk'. 
    iv := row at: 'iv'.
    tv := row at: 'tv'.
    Transcript show: 'xk = ', xk asString, ' (', xk class asString, ')'; cr.
    Transcript show: 'iv = ', iv asString, ' (', iv class asString, ')'; cr.
    Transcript show: 'tv = ', tv asString, ' (', tv class asString, ')'; cr ].
  resultSet close.
] ensure: [ db close ].