search

dyedgreen / deno-sqlite

Deno SQLite module
https://deno.land/x/sqlite
MIT License
409 stars 36 forks source link

Update after a select query doesn't work #197

Closed marcosadriano05 closed 2 years ago

marcosadriano05 commented 2 years ago

I create a query to update some data, it's work fine. The query is: this.database.query("UPDATE todo SET title = ?, description = ?, start_date = ?, finish_date = ? WHERE id = ?;", [data.getTitle(), data.getDescription(), formatedStartDate, formatedFinishDate, data.getId()]).

But if i run this query after a select query with the same id, doesn't work. The select query: this.database.query("SELECT * FROM todo WHERE id = ?;", [data.getId()]").

This problem occur when the data is recent create on database too.

dyedgreen commented 2 years ago

Can you provide a minimal script to reproduce the issue?