# Opcua client sqlite not working
**URL:** https://discourse.nodered.org/t/opcua-client-sqlite-not-working/89683
**Category:** Industrial
**Tags:** opcua
**Created:** [22 July 2024 20:45 UTC](https://discourse.nodered.org/t/opcua-client-sqlite-not-working/89683 "2024-07-22T20:45:32Z")
**Posts on this page:** 11
**Page:** 1
### Author:  [@nathan1](https://discourse.nodered.org/u/nathan1)
#### Post date: [22 July 2024 20:45 UTC](https://discourse.nodered.org/t/opcua-client-sqlite-not-working/89683/1 "2024-07-22T20:45:32Z")
Hello,
I am currently working on creating a datalogger using OPCUA. For some reason, I'm unable to get the msg.payload into the sqlite, because it's saying that the payload is undefined. Could anyone help with this Issue?
\*
\*
Thank you for your time.
---
### Author:  [@Colin](https://discourse.nodered.org/u/Colin)
#### Post date: [22 July 2024 21:14 UTC](https://discourse.nodered.org/t/opcua-client-sqlite-not-working/89683/2 "2024-07-22T21:14:35Z")
Welcome to the forum @nathan1
> [@nathan1](#):
>
> it's saying that the payload is undefined
It is saying that you are trying to access column named `undefined`. Use a debug node to see what is coming out of the write query function so that you can check what you are actually sending to the database.
---
### Author:  [@nathan1](https://discourse.nodered.org/u/nathan1)
#### Post date: [23 July 2024 13:35 UTC](https://discourse.nodered.org/t/opcua-client-sqlite-not-working/89683/3 "2024-07-23T13:35:58Z")
Hi @Colin,
This is what I'm seeing:
This is my first time using Node-Red, I'm still a newbie.
Thank you,
Nathan
---
### Author:  [@nathan1](https://discourse.nodered.org/u/nathan1)
#### Post date: [23 July 2024 19:12 UTC](https://discourse.nodered.org/t/opcua-client-sqlite-not-working/89683/4 "2024-07-23T19:12:19Z")
> [@Colin](#):
>
> Use a debug node to see what is coming out of the write query function so that you can check what you are actually sending to the database.
Here's the writequery function:
---
### Author:  [@Colin](https://discourse.nodered.org/u/Colin)
#### Post date: [23 July 2024 19:42 UTC](https://discourse.nodered.org/t/opcua-client-sqlite-not-working/89683/5 "2024-07-23T19:42:47Z")
msg.topic should be a string containing the query. Possibly something like
`msg.topic = "INSERT INTO RANDOMNUM VALUES (" + x + ")"`
Though I find it much easier to use this syntax for making complex strings
```auto
msg.topic = `INSERT INTO RANDOMNUM VALUES ( ${x} )`
```
Also make debug 3 output Complete Message so you can more easily see what is in the topic.
In addition I recommend adding another debug node showing what is going _into_ the function to check that what you expect is there.
---
### Author:  [@nathan1](https://discourse.nodered.org/u/nathan1)
#### Post date: [24 July 2024 14:01 UTC](https://discourse.nodered.org/t/opcua-client-sqlite-not-working/89683/6 "2024-07-24T14:01:59Z")
Hi Colin,
It seems that it's getting NULL into the writequery function. I'm not sure why since Debug3 is getting the correct message.
---
### Author:  [@nathan1](https://discourse.nodered.org/u/nathan1)
#### Post date: [24 July 2024 14:06 UTC](https://discourse.nodered.org/t/opcua-client-sqlite-not-working/89683/7 "2024-07-24T14:06:50Z")
I moved it up to the first output and it seems to be giving an output now. However, the query is still empty.
---
### Author:  [@Colin](https://discourse.nodered.org/u/Colin)
#### Post date: [24 July 2024 15:31 UTC](https://discourse.nodered.org/t/opcua-client-sqlite-not-working/89683/8 "2024-07-24T15:31:30Z")
> [@nathan1](#):
>
> the query is still empty.
Your function is not connected to the sqlite node.
---
### Author:  [@nathan1](https://discourse.nodered.org/u/nathan1)
#### Post date: [24 July 2024 15:52 UTC](https://discourse.nodered.org/t/opcua-client-sqlite-not-working/89683/9 "2024-07-24T15:52:41Z")
Thank you it works now. I have another question with read multiple. Is there a way to put the payload values in 1 array?
---
### Author:  [@Colin](https://discourse.nodered.org/u/Colin)
#### Post date: [24 July 2024 16:38 UTC](https://discourse.nodered.org/t/opcua-client-sqlite-not-working/89683/10 "2024-07-24T16:38:12Z")
> [@nathan1](#):
>
> I have another question with read multiple. Is there a way to put the payload values in 1 array?
Is this a question about opcua or sqlite? If it is an opcua question it might be better to start a new thread. I have never used opcua.
---
### Author:  [@system](https://discourse.nodered.org/u/system)
#### Post date: [22 September 2024 16:39 UTC](https://discourse.nodered.org/t/opcua-client-sqlite-not-working/89683/11 "2024-09-22T16:39:00Z")
This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.