How do I update the database? about sqlite3 HOT 9 CLOSED

Can you provide a reproduction for this error?

from sqlite3.

I'm just doing an UPDATE using db.exec().
db.exec("UPDATE table SET column=value where id=?", id);

from sqlite3.

Is there anything I'm missing?

from sqlite3.

Hmm, I wonder if its because I have mine wrapped in a Promise.all?

from sqlite3.

Promise.all shouldn't be making a difference, it seems like it is failing when calling sqlite3_prepare_v2 which means there is likely something wrong with the query itself, but I don't see it... what if you change all bind parameters to ? instead of using :release_download_count ?

from sqlite3.

Did not notice that mistake, but that did not work either. Is there anything else I could provide that would help?

from sqlite3.

Is it possible for you to reproduce the problem in a small test script instead? We need to isolate the case

from sqlite3.

@DjDeveloperr Indeed it was a problem with my code. I was using the wrong table and closing the database before all the async calls were finished.

Thank you for your help!

from sqlite3.

No problem, glad you found the issue.

from sqlite3.