jeudi 3 mars 2016

sqlite3_exec api returns database locked error while executing drop table query

I have a c program with somewhat below sequence

sqlite3_open sqlite3_exec("create table temp.....") sqlite3_exec("drop table if exists temp") sqlite3_close

While executing second query of drop table temp, I get database locked error.

Can anybody please let me know the reason behind it and how to solve it?

Is it because I am creating and deleting table in same transaction?

Thanks

Aucun commentaire:

Enregistrer un commentaire