test-query-select-fetch.js

var common = require("./common")
  , odbc = require("../")
  , db = new odbc.Database()
  , assert = require("assert")
  ;

db.openSync(common.connectionString);
assert.equal(db.connected, true);

db.queryResult("select 1 as COLINT, 'some test' as COLTEXT ", function (err, result) {
  assert.equal(err, null);
  assert.equal(result.constructor.name, "ODBCResult");
  
  result.fetch(function (err, data) {
    db.closeSync();
    assert.deepEqual(data, { COLINT: '1', COLTEXT: 'some test' });
  });
});