How do I update a row in a SQLite database?
-
So far I have: update values subname=maths mark=90 where key =s1,
-
Answer:
ContentValues data=new ContentValues(); data.put("Field1","bob"); data.put("Field2",19); data.put("Field3","male"); DB.update(Tablename, data, "_id=" + id, null);
Abhishek Gupta at Quora Visit the source
Other answers
SQLite is a open source, lightweight, single tier relational DBMS SQLite, is a powerful SQL database library. Following are some function in a "Cursor" class, which helps nevigation within result set. moveToFirst Moves the cursor to the first row in the query result moveToNext Moves the cursor to the next row moveToPrevious Moves the cursor to the previous row getCount Returns the number of rows in the result set getColumnName Returns the name of the specified column index getColumnNames Returns a string array of all the column names in the current Cursor moveToPosition Moves the Cursor to the specified row getPosition Returns the current Cursor position Following this link : http://www.theappguruz.com/blog/android-using-sqlite-database
Finaa Amelia
Related Q & A:
- How can I sort a column in a DataGrid?Best solution by Stack Overflow
- How do i find a profile of a person with a yahoo mail address?Best solution by Yahoo! Answers
- How do I save a video from a CD to a computer?Best solution by Yahoo! Answers
- How do I update my blackberry without a desktop?Best solution by Yahoo! Answers
- How can I get a job at a resort for a Summer?Best solution by eHow old
Just Added Q & A:
- How many active mobile subscribers are there in China?Best solution by Quora
- How to find the right vacation?Best solution by bookit.com
- How To Make Your Own Primer?Best solution by thekrazycouponlady.com
- How do you get the domain & range?Best solution by ChaCha
- How do you open pop up blockers?Best solution by Yahoo! Answers
For every problem there is a solution! Proved by Solucija.
-
Got an issue and looking for advice?
-
Ask Solucija to search every corner of the Web for help.
-
Get workable solutions and helpful tips in a moment.
Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.