# SQLite SELECT from node-red function return nothing but in DB browser works fine
**URL:** https://discourse.nodered.org/t/sqlite-select-from-node-red-function-return-nothing-but-in-db-browser-works-fine/58486
**Category:** General
**Tags:** database, function-node
**Created:** [16 February 2022 19:35 UTC](https://discourse.nodered.org/t/sqlite-select-from-node-red-function-return-nothing-but-in-db-browser-works-fine/58486 "2022-02-16T19:35:41Z")
**Posts on this page:** 12
**Page:** 1
### Author:  [@dm2jokes](https://discourse.nodered.org/u/dm2jokes)
#### Post date: [16 February 2022 19:35 UTC](https://discourse.nodered.org/t/sqlite-select-from-node-red-function-return-nothing-but-in-db-browser-works-fine/58486/1 "2022-02-16T19:35:41Z")
Well Hi first!
I'm a new with SQLite database, so problem is that SELECT statement in DB browser works just fine but in function node nothing is return.
DB Browser
Flow
```auto
[
{
"id": "2c85767fe0fb433d",
"type": "sqlite",
"z": "f4319603ec036678",
"mydb": "0aa4467edfdf9b8e",
"sqlquery": "msg.topic",
"sql": "",
"name": "DB",
"x": 610,
"y": 180,
"wires": [
[]
]
},
{
"id": "e5eecd6db43aec5f",
"type": "function",
"z": "f4319603ec036678",
"name": "Get TracID from table Tracks",
"func": "msg.topic = \"SELECT id FROM tr ORDER BY id DESC LIMIT 1\";\nreturn msg;",
"outputs": 1,
"noerr": 0,
"initialize": "",
"finalize": "",
"libs": [],
"x": 400,
"y": 160,
"wires": [
[
"2c85767fe0fb433d",
"e0a66b35608cbedb"
]
]
},
{
"id": "e0a66b35608cbedb",
"type": "debug",
"z": "f4319603ec036678",
"name": "SELECT",
"active": true,
"tosidebar": true,
"console": false,
"tostatus": false,
"complete": "payload",
"targetType": "msg",
"statusVal": "",
"statusType": "auto",
"x": 620,
"y": 140,
"wires": []
},
{
"id": "0ae7bf79ebc920eb",
"type": "comment",
"z": "f4319603ec036678",
"name": "SELECT FROM problem",
"info": "",
"x": 290,
"y": 100,
"wires": []
},
{
"id": "62079b96238a5a46",
"type": "inject",
"z": "f4319603ec036678",
"name": "",
"props": [
{
"p": "payload"
},
{
"p": "topic",
"vt": "str"
}
],
"repeat": "",
"crontab": "",
"once": true,
"onceDelay": 0.1,
"topic": "",
"payload": "",
"payloadType": "date",
"x": 170,
"y": 160,
"wires": [
[
"e5eecd6db43aec5f"
]
]
},
{
"id": "0aa4467edfdf9b8e",
"type": "sqlitedb",
"db": "/home/pi/dbs/boats",
"mode": "RWC"
}
]
```
Table
```auto
CREATE TABLE "tr" ('id' INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
'deviceid' TEXT,
'time' INTEGER,
'DateTime' DATETIME,
'name' TEXT,
'latitude_start' REAL,
'longitude_start' REAL,
'latitude_end' REAL,
'longitude_end' REAL);
```
DEBUG
node-red status
16 Feb 20:30:38 - [info]
# Welcome to Node-RED
16 Feb 20:30:38 - [info] Node-RED version: v2.2.0
16 Feb 20:30:38 - [info] Node.js version: v14.19.0
16 Feb 20:30:38 - [info] Linux 5.10.63-v7+ arm LE
16 Feb 20:30:41 - [info] Loading palette nodes
16 Feb 20:30:51 - [info] Worldmap version 2.25.0
16 Feb 20:30:51 - [info] Dashboard version 3.1.5 started at /ui
16 Feb 20:30:55 - [info] Settings file : /home/pi/.node-red/settings.js
16 Feb 20:30:55 - [info] Context store : 'default' [module=localfilesystem]
16 Feb 20:30:55 - [info] User directory : /home/pi/.node-red
16 Feb 20:30:55 - [warn] Projects disabled : editorTheme.projects.enabled=false
16 Feb 20:30:55 - [info] Flows file : /home/pi/.node-red/status
16 Feb 20:30:56 - [error] Uncaught Exception:
16 Feb 20:30:56 - [error] Error: listen EADDRINUSE: address already in use 0.0.0.0:1880
at Server.setupListenHandle [as \_listen2] (net.js:1331:16)
at listenInCluster (net.js:1379:12)
at doListen (net.js:1516:7)
at processTicksAndRejections (internal/process/task\_queues.js:83:21)
So I'm stuck here and need help.
Thx
---
### Author:  [@E1cid](https://discourse.nodered.org/u/E1cid)
#### Post date: [16 February 2022 19:47 UTC](https://discourse.nodered.org/t/sqlite-select-from-node-red-function-return-nothing-but-in-db-browser-works-fine/58486/2 "2022-02-16T19:47:03Z")
Do you have a debug that we can see after the sqlite node?
---
### Author:  [@zenofmud](https://discourse.nodered.org/u/zenofmud)
#### Post date: [16 February 2022 19:57 UTC](https://discourse.nodered.org/t/sqlite-select-from-node-red-function-return-nothing-but-in-db-browser-works-fine/58486/3 "2022-02-16T19:57:33Z")
Are you sure you have created the table? I don't believe you use quotes around the table name
[EDIT] I'm mistaken, you can use quotes
Are you sure you have data in it?
can you show how you are adding data to the table?
add a catch node connected to a debug node( **set to display the complete msg object** ) and add a new row to the table.
---
### Author:  [@TotallyInformation](https://discourse.nodered.org/u/TotallyInformation)
#### Post date: [16 February 2022 20:13 UTC](https://discourse.nodered.org/t/sqlite-select-from-node-red-function-return-nothing-but-in-db-browser-works-fine/58486/4 "2022-02-16T20:13:18Z")
In that debug, please switch to showing the whole msg rather than just the payload.
---
### Author:  [@dm2jokes](https://discourse.nodered.org/u/dm2jokes)
#### Post date: [16 February 2022 20:19 UTC](https://discourse.nodered.org/t/sqlite-select-from-node-red-function-return-nothing-but-in-db-browser-works-fine/58486/5 "2022-02-16T20:19:31Z")
Yes, I can add new record.
---
### Author:  [@dm2jokes](https://discourse.nodered.org/u/dm2jokes)
#### Post date: [16 February 2022 20:33 UTC](https://discourse.nodered.org/t/sqlite-select-from-node-red-function-return-nothing-but-in-db-browser-works-fine/58486/6 "2022-02-16T20:33:40Z")
Here is debug full object
---
### Author:  [@dm2jokes](https://discourse.nodered.org/u/dm2jokes)
#### Post date: [16 February 2022 20:42 UTC](https://discourse.nodered.org/t/sqlite-select-from-node-red-function-return-nothing-but-in-db-browser-works-fine/58486/7 "2022-02-16T20:42:33Z")
---
### Author:  [@UnborN](https://discourse.nodered.org/u/UnborN)
#### Post date: [16 February 2022 20:49 UTC](https://discourse.nodered.org/t/sqlite-select-from-node-red-function-return-nothing-but-in-db-browser-works-fine/58486/8 "2022-02-16T20:49:27Z")
> [@dm2jokes](#):
>
> Here is debug full object
I guess that is the output of the Debug node that is wired after your Function node (named SELECT)
but as @E1cid pointed out you need to wire a Debug node after the Sqlite node to see the output of your database. By importing your flow i dont see one.
---
### Author:  [@dm2jokes](https://discourse.nodered.org/u/dm2jokes)
#### Post date: [16 February 2022 20:53 UTC](https://discourse.nodered.org/t/sqlite-select-from-node-red-function-return-nothing-but-in-db-browser-works-fine/58486/9 "2022-02-16T20:53:11Z")
Yep, sorry.
---
### Author:  [@E1cid](https://discourse.nodered.org/u/E1cid)
#### Post date: [16 February 2022 20:54 UTC](https://discourse.nodered.org/t/sqlite-select-from-node-red-function-return-nothing-but-in-db-browser-works-fine/58486/10 "2022-02-16T20:54:18Z")
Appears to be working to me. It returns an array with one item id.
---
### Author:  [@dm2jokes](https://discourse.nodered.org/u/dm2jokes)
#### Post date: [16 February 2022 20:56 UTC](https://discourse.nodered.org/t/sqlite-select-from-node-red-function-return-nothing-but-in-db-browser-works-fine/58486/11 "2022-02-16T20:56:32Z")
Yes, thats it. Thx for effort.
I'm new in node-red and sqlite.
Regards
---
### Author:  [@system](https://discourse.nodered.org/u/system)
#### Post date: [2 March 2022 20:56 UTC](https://discourse.nodered.org/t/sqlite-select-from-node-red-function-return-nothing-but-in-db-browser-works-fine/58486/12 "2022-03-02T20:56:45Z")
This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.