Tutorials on Android sqlite counter

Question

1.00/5 (1 vote)

See more:

Hi is there any tutorials on android sqlite counter, when item is clicked once, the count in database will have increment by one.

Posted 1-Nov-15 22:15pm

Benji Heng

Add a Solution

Comments

Krunal Rohit 2-Nov-15 4:24am

Don't repost the question. Yesterday I've commented on your question that you have to fire the update statement whenever your item is clicked.

-KR

Benji Heng 2-Nov-15 4:29am

I understand I have to have the update statement but how do I do it? I even made edits to the codes, please do take a look

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Afzaal Ahmad Zeeshan · Answer 1 · 2015-11-01T22:22:00

That is a combination of two objects.

1. SQLiteOpenHelper
2. OnClickListener

These would (collectively) work to accomplish the task. The helper would allow you to work around with SQLite databases, like accessing or updating the values and the click listener would allow your application to handle the taps by user.

Start by this tutorial, Using SQLite Database with Android[^], then the listener[^] can be added to the items in your list to trigger the helper to update the values.

Richard MacCutchan · Answer 2 · 2015-11-01T22:28:00

Solution 2

Why do you need a button click? SQLite, like most databases, provides for an automatic incremented field: see https://www.sqlite.org/faq.html#q1[^].

Posted 1-Nov-15 22:28pm

Richard MacCutchan

Comments

Benji Heng 2-Nov-15 4:34am

The issue is, I already have a id that is INTEGER PRIMARY KEY autoincrement

Richard MacCutchan 2-Nov-15 4:56am

Then please edit your question and explain exactly what you are trying to achieve.

Benji Heng 2-Nov-15 10:04am

I have the questions here please take a look

Richard MacCutchan 2-Nov-15 10:30am

I don't see any update to your question.

Benji Heng 2-Nov-15 11:21am

http://www.codeproject.com/Questions/1045771/Increment-a-counter-in-database-sqlite

Richard MacCutchan 2-Nov-15 11:24am

Why have you created a new question when I asked you to edit this one?

Benji Heng 2-Nov-15 11:35am

Initially, I created the http://www.codeproject.com/Questions/1045771/Increment-a-counter-in-database-sqlite 1st then people that reply me didn't provide much help so I post a new question asking for related tutorial hoping that it will help me