Unable to update Integer field in SQLite database

Question

I am trying to update an 'integer' fields in SQLite database by adding 1 to it. So it is X = X+1

Following is my code

  public synchronized void updateStatistics(List<String> correctWords,
            List<String> facedWords, int wordListNumber, boolean flag) {
        // TODO Auto-generated method stub
        String[] tableLastNames= {"A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","U","V","W","X","Y","Z"};

        String tableName = "WordList_"+tableLastNames[wordListNumber];


        if(flag)
        {
            //First update 'FacedWords' row

            Toast.makeText(context, "Faced Words Length: "+facedWords.size(), Toast.LENGTH_LONG).show();
            Toast.makeText(context, "Correct Words Length: "+correctWords.size(), Toast.LENGTH_LONG).show();

            try
            {
                for(int i=0;i<facedWords.size();i++)
                {
                    String query = "update  "+ tableName+" set NumberOfTimesEnglishWordShowed=NumberOfTimesEnglishWordShowed+1 where EnglishWord = ' "+(facedWords.get(i)).trim()+"'";
                    database.execSQL(query);
                }

                for(int i=0;i<correctWords.size();i++)
                {
                    String query = "update   "+ tableName+" set NumberOfTimesEnglishWordCorrected=NumberOfTimesEnglishWordCorrected+1 where EnglishWord = ' "+(facedWords.get(i)).trim()+"'";
                    database.execSQL(query);
                }

                //Toast.makeText(context, "Updated Word: "+, duration)
            }
            catch(Exception e)
            {
                Toast.makeText(context, "Update error", Toast.LENGTH_LONG).show();
            }

        }



    }

I am using SQLite database browser to see the things in my database, and I noticed the above code has updated nothing! There is no error as well! In case you need, following is the required part from the table

String createDatabaseQuery = "create table WordList_A(" +
                    "ID integer primary key autoincrement,"
                    +"NumberOfTimesEnglishWordShowed integer,"

                    +"NumberOfTimesEnglishWordCorrected integer,");";

The update query I used is similar to the MS SQL update query, so I am not sure whether that way is working with SQLite. Why my code is not updating anything?

Is the leading space in ' "+(facedWords.get(i)).trim()+"' on purpose? It seems wrong... — Vincent van der Weele
– Vincent van der Weele, Commented Aug 12, 2013 at 7:17
@Heuster: Great! This is it! Thank you! Since you found the issue first, I would like to mark your answer as the answer. Please be kind enough to provide your answer as an Answer — PeakGen
– PeakGen, Commented Aug 12, 2013 at 7:21
Tnx, but just mark the other answer as accepted. It's not a competition :) — Vincent van der Weele
– Vincent van der Weele, Commented Aug 12, 2013 at 7:23

Arash GM · Accepted Answer · 2013-08-12 07:19:08Z

3

I think you have extra "space" in your where clause :

where EnglishWord = ' "+(facedWords.get(i)).trim()+"'"

so replace it with :

where EnglishWord = '"+(facedWords.get(i)).trim()+"'"

answered Aug 12, 2013 at 7:19

Arash GM

10.4k6 gold badges62 silver badges78 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

PeakGen Over a year ago

Hello, Thanks a lot for the answer. It works! I already gave you a +1

Collectives™ on Stack Overflow

Unable to update Integer field in SQLite database

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related