Update query is not working in sqlite

Question 1

I have a update query in my android application. But its not working properly. When clicking the button for updating the application stops working. The code is as follows-

update.setOnClickListener(new OnClickListener (){            @Override            public void onClick(View v) {                // TODO Auto-generated method stub            String feched_name = show_name.getText().toString();            String get_std_for_update=id_search.getText().toString();            String get_new_name = id_update.getText().toString();            if(feched_name.matches("")){                Toast.makeText(getApplicationContext(), "No Student selected", Toast.LENGTH_LONG).show();                }                    else {                        if(get_new_name.matches("")){                        Toast.makeText(getApplicationContext(), "New Name is empty", Toast.LENGTH_LONG).show();                         }                        else{                            stdDB.execSQL("Update student set name = "+get_new_name + "where id = "+get_std_for_update);                                Toast.makeText(getApplicationContext(), "Student's name has been updated", Toast.LENGTH_LONG).show();                           }                    }            }           });

Question 2

Replace the query below with the existing one :

stdDB.execSQL("Update student set name = '"+get_new_name + "' where id = "+get_std_for_update);

Mark the single quote around the name and the space.

Hope this helps.

Question 3

Thats it. I forgot to add single quotes. Its working now. Thank you.

Question 4

You should accept the answer if it was helpful to you, it will help others in future.

Question 5

Try

stdDB.execSQL("Update student set name = '"+get_new_name + "' where id = "+get_std_for_update);

or

stdDB.execSQL("Update student set name = \""+get_new_name + "\" where id = "+get_std_for_update);

Please note I added quotes and also I added a space after your where clause.

Shraddha 1,05211 silver badges22 bronze badges · Accepted Answer · 2013-07-18 06:26:17Z

1

Replace the query below with the existing one :

stdDB.execSQL("Update student set name = '"+get_new_name + "' where id = "+get_std_for_update);

Mark the single quote around the name and the space.

Hope this helps.

Share

Improve this answer

answeredJul 18, 2013 at 6:26

Shraddha

1,05211 silver badges22 bronze badges

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

2 Comments

Muntashir Are Rahi

Muntashir Are Rahi Over a year ago

Thats it. I forgot to add single quotes. Its working now. Thank you.

2013-07-18T06:33:26.363Z+00:00

Shraddha

Shraddha Over a year ago

You should accept the answer if it was helpful to you, it will help others in future.

2013-07-18T06:37:21.053Z+00:00

Movatterモバイル変換

Collectives™ on Stack Overflow

Update query is not working in sqlite

2 Answers2

2 Comments

Comments

Your Answer

Sign up orlog in

Post as a guest

Related

Hot Network Questions

Subscribe to RSS