Update query is not working in sqlite

Question

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();   
                        }
                    }


            }

           });

Shraddha · 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.

answered Jul 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 Over a year ago

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

Shraddha Over a year ago

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

Martin Magakian · Accepted Answer · 2013-07-18 06:25:25Z

0

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.

answered Jul 18, 2013 at 6:25

Martin Magakian

3,7865 gold badges39 silver badges53 bronze badges

Collectives™ on Stack Overflow

Update query is not working in sqlite

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related