Android Question SQLite Question

peggjones · Oct 14, 2013

Is it possible to corrupt a database using DBUTILS?

A couple of times I've lost the data in my database. When I try to open it with SQLiteManager it says the file is not a database. It's still there and iIs physical size is the same. It's happened a couple of times over several months.

Could easily be something other than Basic4Android that is causing the problem, just wondered if anyone else has seen the same thing.

Thanks.

eps · Oct 14, 2013

Are you making sure that you Close the DB or commit the data to the database after updating any data? Are you updating any data? A little more information will help, such as how the DB is created, what version of SQLite and what operations you typically perform on the database.

I found that the Firefox add-on is a good way to access DBs and gives you some useful tools to analyse and fix any issues with SQLite databases.

Erel · Oct 14, 2013

DBUtils just wraps the SQL object and makes it easier to build the queries.

peggjones · Oct 14, 2013

eps said:
Are you making sure that you Close the DB or commit the data to the database after updating any data? Are you updating any data? A little more information will help, such as how the DB is created, what version of SQLite and what operations you typically perform on the database.

I found that the Firefox add-on is a good way to access DBs and gives you some useful tools to analyse and fix any issues with SQLite databases.

peggjones · Oct 14, 2013

Thanks. I add, update and delete records on my database. I don't close it. Do you know what the consequences of not doing so are? I don't know what version I'm on, I installed it about 6 months ago. I created it using an app called ABCdb.

Thanks for your help.

eps · Oct 14, 2013

I would close the DB, otherwise you will get unexpected issues.

I think older versions of Android, have older versions of SQLite on them, which aren't as robust as the newer versions.

Android Question SQLite Question

peggjones

Active Member

eps

Expert

Erel

B4X founder

peggjones

Active Member

peggjones

Active Member

eps

Expert

Similar Threads

Android Question SQLite Question

peggjones

Active Member

eps

Expert

Erel

B4X founder

peggjones

Active Member

peggjones

Active Member

eps

Expert

Similar Threads

Privacy & Transparency

Privacy & Transparency