# SQLite node syntax error but sqlitebrowser works

**URL:** <https://discourse.nodered.org/t/sqlite-node-syntax-error-but-sqlitebrowser-works/47350>\
**Category:** General\
**Created:** [18 June 2021 21:03 UTC](https://discourse.nodered.org/t/sqlite-node-syntax-error-but-sqlitebrowser-works/47350 "2021-06-18T21:03:23Z")\
**Posts on this page:** 1\
**Showing post:** 27

<div class="post-metadata">

**Author:** ![mune](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/mune/32/37105_2.png) [@mune](https://discourse.nodered.org/u/mune)\
**Post date:** [3 July 2021 17:45 UTC](https://discourse.nodered.org/t/sqlite-node-syntax-error-but-sqlitebrowser-works/47350/27 "2021-07-03T17:45:02Z")

</div>

> [@Colin](#):
>
> I suspect that if you keep adding and removing records that eventually it will start reusing then.

I thought too to a cache-like issue, so I added the AUTOINCREMENT; I don't care about the fact it uses more CPU as it is used very very seldom.

```auto
BEGIN TRANSACTION;
DROP TABLE IF EXISTS recipe;
CREATE TABLE IF NOT EXISTS recipe (
        ID INTEGER PRIMARY KEY AUTOINCREMENT,
        rname VARCHAR ( 255 ),
        heat_6_7 INTEGER,
        heat_11_12 INTEGER,
        temp INTEGER,
        hyst INTEGER,
        purge_delay INTEGER,
        spray_time INTEGER,
        idle_time INTEGER,
        n_cycle INTEGER
);
COMMIT;

```

> [@Colin](#):
>
> > [@mune](#):
> >
> > I use the ID to read the new inserted data, in another "widget" I show the new data.
> 
> Perhaps you could just feed it direct to the display from before it is given to the database.

I think I thought to a solution: [look my other 3D](https://discourse.nodered.org/t/refresh-tab-page-after-using-another-tab/47912)

---

_[View the full topic](https://discourse.nodered.org/t/sqlite-node-syntax-error-but-sqlitebrowser-works/47350)._