Node.js SQLite not returning anything

Question

I am trying to user SQLite in Node.js

function sqlget(command, param = 0) {
    var args = param;
    if(param == 0) args = [];
    var retval = null;
    db.all(command, args, (err, result) => {
        if(err) {
            console.log(err);
        } else {
            retval = result;
        }
    });
    return retval;
}

When I try this, it returns null. However, If I just use db.get, It works well. The program executes db.all {...}, too.

Use `result` in `else` block, like `console.log(result)` . – hoangdv Dec 09 '19 at 11:28 — hoangdv, Dec 09 '19 at 11:28
I think it is because function can't return json. Any way? – 훗페트야 골든아이 Dec 09 '19 at 12:28 — 훗페트야 골든아이, Dec 09 '19 at 12:28

score 0 · Answer 1 · answered Dec 09 '19 at 11:25

0

The issue is retval returns before db.all(command, args, (err, result) => {}); callback execute.

Try:

function sqlget(command, param = 0) {
    let args = param;
    if(param == 0) args = [];
    db.all(command, args, (err, result) => {
        if(err) {
            console.log(err);
        } 
        return result;
    });
}

answered Dec 09 '19 at 11:25

Zahidul Islam

135
1
5

Not working.... – 훗페트야 골든아이 Dec 09 '19 at 11:33

score -1 · Answer 2 · answered Dec 09 '19 at 11:41

-1

Try this:

function sqlget(command, param = 0) {
    let args = param;
        if(param == 0) args = [];
        return db.all(command, args, (err, result) => {
            if(err) {
                console.log(err);
            } 
            return result;
        });
    }

answered Dec 09 '19 at 11:41

shahrokh

142
2
13

it's better to use async-await too, in this part! – shahrokh Dec 09 '19 at 11:43

Node.js SQLite not returning anything

2 Answers2