CODEWITHSUNDEEP
androiddatabasesqlite
dIvYaNsH sInGh
dIvYaNsH sInGh

Reputation: 1993

Saved data lost when I restart the application(android)

I'm saving some records through my application in SQLite database and later retrieving those records for future use.

It's working fine until I close my application.

When I close my application all the previously saved record becomes zero.

Here is the code:--

 public long insertAlbum(long Outlet_id,long user_id,String Remarks,String PhotoName,String ReportId,String Date,String Status,String LocalRepId)
 {
     long rowId=0;

     ContentValues initialValues = new ContentValues(); 
     initialValues.put("web_AlbumId", 0);
     initialValues.put("OutletId", Outlet_id);
     initialValues.put("Remarks", Remarks);
     initialValues.put("UserId", user_id);
     initialValues.put("Usr_Entdt", Date);
     initialValues.put("PhotoName", PhotoName);
     initialValues.put("ApprovedYN", "Pending");
     initialValues.put("Status", Status);
     initialValues.put("ReportId", ReportId);
     initialValues.put("LocalReportId", LocalRepId);
     try
     {
         myDataBase.beginTransaction();
      rowId=  myDataBase.insertOrThrow("Album", null, initialValues);
      myDataBase.setTransactionSuccessful();

     }
     catch(SQLException e)
     {
         e.printStackTrace();
     }
     finally
     {
         myDataBase.endTransaction();
     }
     return rowId;

Upvotes: 3

Views: 2585

Answers (3)

Ram
Ram

Reputation: 406

Go to to folder where your Sqlite Db file created and check in that file whether the data you saved is present or not . If the data is present in the DB then you need to Retrieve the data from DB

Upvotes: 0

Steve Bergamini
Steve Bergamini

Reputation: 14600

Without seeing your code, it's hard to say what's going on. However, my suspicion is that your code is ALWYAYS creating the database. Are you extending the SQLiteOpenHelper class to create your database? Check there or post the code for further assistance.

Upvotes: 0

IncrediApp
IncrediApp

Reputation: 10353

This shouldn't happen. Sounds to me like you're recreating the database when you're opening the database. Check your code to make sure it's correct

Upvotes: 6

Related Questions