sqlite query execution when button is clicked in android [duplicate]

Question

I have a databaseHelper class. But, I want to multiply two values of each row and store it in another column while a button is clicked. I have checked my query and it works fine but I want to directly multiply the values and make change in the database when a button is click. I don't want to return any values but simply execute the query.

What I did for this is I have created a method in my database helper class. This is the method:

public void getTicketTotal(){
    SQLiteDatabase db=this.getWritableDatabase();
    db.rawQuery("update ticket_table set total=quantity*item_price ",null);
}

and in the button click event I did this. But, it didn't multiply and store the values in the table:

 myDb=new DatabaseHelper(TicketActivity.this);

                myDb.getTicketTotal();

What to do?

try using db. execSQL instead of db.rawQuery. It is used when you are expecting some results in return — Gautam
– Gautam, Commented Feb 14, 2017 at 9:48
FYI, You are using UPDATE query then where is WHERE statement ? — IntelliJ Amiya
– IntelliJ Amiya, Commented Feb 14, 2017 at 9:48

Soumya Rauth · Accepted Answer · 2017-02-14 10:36:50Z

1

The problem was with the method that I was using. The solution is to use db.execSQL instead of rawQuery. So the line of code would be:

public void getTicketTotal(){
    SQLiteDatabase db=this.getWritableDatabase();
     db.execSQL("update ticket_table set total=quantity*item_price ");
}

and simply call it from within the activity.

answered Feb 14, 2017 at 10:36

Soumya Rauth

1,2095 gold badges18 silver badges33 bronze badges

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

3 Comments

Zaki Pathan Over a year ago

good. So annoying. Sorry bro will not got this. Thanks

Soumya Rauth Over a year ago

It's totally ok bro. :) The great part is we actually learned something.

Zaki Pathan Over a year ago

yes bro :) happy to talk with you

Ankush Bist · Accepted Answer · 2017-02-14 10:09:39Z

0

your update query is wrong. on which row you have to update total?

hope it helps

public void getTicketTotal(){
      SQLiteDatabase db=this.getWritableDatabase();
      db.rawQuery("update ticket_table tt set total= tt.quantity * tt.item_price" ,null);
    }

edited Feb 14, 2017 at 10:09

Ankush Bist

1,8841 gold badge17 silver badges32 bronze badges

answered Feb 14, 2017 at 9:50

Zaki Pathan

1,7821 gold badge16 silver badges26 bronze badges

15 Comments

Soumya Rauth Over a year ago

But this query works fine while I am separately applying it in my db table.

Soumya Rauth Over a year ago

Why do I need a where statement here?

Zaki Pathan Over a year ago

Because you want to update on single data right? So you need to set WHERE condition. Like "WHERE Id = 3"

Zaki Pathan Over a year ago

I think it helps you. If this helps mark this as a right answer. Thanks Bro

Ankush Bist Over a year ago

@ZakiPathan where clause is not mandatory.

|

Collectives™ on Stack Overflow

sqlite query execution when button is clicked in android [duplicate]

2 Answers 2

3 Comments

15 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

15 Comments

Linked

Related