Android Question SQLite Question

[peggjones]

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]

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]

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

 

[peggjones]

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]

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]

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.