Skip to content

Node-firebird don't give results if more than 3 fields in the query #216

@wakeupwakeup

Description

@wakeupwakeup

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 fouth field it doesn't give any response. It is not a problem with any exact field because it querys well if I ask for it with less other fields. Depending on the table the number of fields I can query is different. Thanks

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();
    });

 
});

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions