I can create and use the table in runtime, but not drop the table.
More...............
If I dont stop the application and manually trying to create a table or modify data in a table with SQLLiteStudio it causes the following error:
[23:02:54] Could not commit table structure. Error message: Could not commit a database transaction. Details: database is locked
It looks like that the entire database is locked for some transactions.
What can cause this??
B4X:
Dim m As Map
m.Initialize
m.Put("ID", "INTEGER")
m.Put("ImageID", "TEXT")
jDBUtils.CreateTable(Main.dbImage, "tmpSel", M, "ID")
sSQL = "INSERT INTO tmpSel VALUES (1, 'Img2032')"
jDBUtils.sqlR(sSQL) ' work
jDBUtils.DropTable(Main.dbImage, "tmpSel") 'doesn't work
'java.sql.SQLException: [SQLITE_LOCKED] A table in the database is locked (database table is locked)
More...............
If I dont stop the application and manually trying to create a table or modify data in a table with SQLLiteStudio it causes the following error:
[23:02:54] Could not commit table structure. Error message: Could not commit a database transaction. Details: database is locked
It looks like that the entire database is locked for some transactions.
What can cause this??