Hi all,

I have created one table using SQLite by applying

"create table temp (number integer, name text, address text)";

Now i want to know that where the temp file is stored? And also i want to know that how i can save the table when i am working with the SQLite.

If any command of it, tell me and also if you have any material about SQLite give me.

Thanks...

"Now i want to know that where the temp file is stored?"

The book Hello Android says the databases are stored in /data/data/packagename/databases (where packagename is your app's package name (com.blah or whatever).

"And also i want to know that how i can save the table when i am working with the SQLite."

What do you mean by saved? It's preserved until you "drop table temp" (or reset the device).

You can check out http://www.sqlite.org for more info about the database in general.