1

I'm testing "node-firebird" with Firebird 2.5 and it runs if I query for 1, 2 or 3 fields, but if I ask for a fourth field, it doesn't give any response. It is not a problem with any exact field because it queries well if I ask for it with less other fields. Depending on the table the number of fields I can query is different.

var Firebird = require('node-firebird');

var options = {};
 
options.host = '127.0.0.1';
options.port = 3050;
options.database = 'xxx.FDB';
options.user = 'SYSDBA';
options.password = 'masterkey';
options.lowercase_keys = false; // set to true to lowercase keys
options.role = null;            // default
options.pageSize = 4096;        // default when creating database


Firebird.attach(options, function(err, db) {

    if (err)
        throw err;


    db.query('SELECT fiel1, field2, field3_act FROM table', function(err, result) {
 
        console.log("result", result)

        db.detach();
    });

 
});
Mark Rotteveel
  • 100,966
  • 191
  • 140
  • 197
wakeup
  • 67
  • 7

0 Answers0