How to sqlite statement to update duedate of the row whose name is myname and dob is mydob

⇧

⇩

43 views

Hi I have the below statement to update a row in the table

    ContentValues myValues = new ContentValues();
    myValues.put("duedate", duedate);

    return mDb.update(DATABASE_TABLE, myValues,"name" + "=?" + "dob" + "=?", new String[] { myname,mydob });

I want to update the duedate of the row whose name is myname and dob is mydob.

The above code is not working. Can you please help me how to do it.

Thanks, Vijay

android sqlite

asked June 24, 2011 2:26 pm CDT

vijay

posted via StackOverflow

0 Answers

Be the first to answer this question

Similar discussion threads

Re: sqlite.exe db_name .dump : It missed : table name is un quoted.(INSERT statement)
November 7, 2010 05:29:00 AM
sqlite-2.8.17-47fee16ba9bd8ab2.diff --- SQLite-47fee16ba9bd8ab2/src/shell.c +++ SQLite-47fee16ba9bd8ab2/src/shell.c @@ -421,7 +421,7 @@ p->zDestTable = 0; } if( zName==0 ) return; - needQuote = !isalpha(*zName) && *zName!='_'; +…

sqlite.exe db_name .dump : It missed : table name is un quoted.(INSERT statement)
November 4, 2010 07:12:43 AM
sqlite.exe db_name .dump It missed : table name is un quoted.(INSERT statement) database conversion fails (version 2 to 3) sqlite -version 2.8.17 --------- dump_test.sql create table "where" (id INTEGER); INSERT INTO "where" VALUES(1);

Howto...multi-sqlite command string through sqlite3_prepare_v2() to create SINGLE statement
June 21, 2011 06:23:29 AM
The commented out lines work. I'm wondering... a) is it possible to do what's not commented out b) what's the syntax re the "sql =..." and "sql +=..." lines Any help much appreciated! [code] //sql = "create table episodes (id integer primary key,…

Re: Howto...multi-sqlite command string through sqlite3_prepare_v2() to create SINGLE statement
June 21, 2011 06:53:27 AM
e-mail mgbg25171 <mgbg2### @blueyonder.co.uk> wrote: > Howto...multi-sqlite command string through sqlite3_prepare_v2() to create SINGLE statement You can't do that. > sql = "BEGIN"; //you need to add newline here > sql +=…

Getting null values in an update statement
April 26, 2011 12:41:09 PM
I want to perform an UPDATE to a field in a table. Such a field is of type numeric, does not allow null values and has a default value of 0 (zero). The situation I am facing is that the records that do not meet the update criteria are set to null…

cache not flushing after UPDATE statement
January 18, 2011 03:48:22 PM
Here are my settings: <settings> <setting name="cacheEnabled" value="true"/> <setting name="lazyLoadingEnabled" value="true"/> <setting name="aggressiveLazyLoading" value="false"/> <setting…

Problem with first update statement after Tomcat restart
November 24, 2010 08:25:08 AM
Hi gurus, Every time I restart Tomcat, the first transaction trying to modify data gets stuck in "in transaction" state. I'm running the following configuration on Gentoo: Postgresql 8.4.4 Apache Tomcat/6.0.18 JVM: 1.6.0_13-b03…

C# : How to add multiple values to an array in a single Update() statement
February 12, 2011 11:25:37 AM
I want to add multiple new items to an array property in a single Update() method, but this code fails : var oQuery = Query.EQ( "_id", ObjectId.Parse( _id)); var oUpdate = Update.AddToSet( "colours", "red").AddToSet( "colours", "green").AddToSet(…

ORA-01461 exception when using large string in update statement
July 6, 2010 06:29:09 PM
Hello All, I'm getting the following exception when trying to perform an update using a large (>4000 character) string. Since neither my table nor my parameters contain any LONG values, I'm assuming the error is misleading. Seems to work OK…

OS/2] Update OS/2 support in sqlite 3.7.x
September 23, 2010 06:39:07 AM
This defect report is cloned from mozilla bug595599 RW: "This patch disables WAL journalling on OS/2 since that feature requires memory-mapped file i/o which OS/2 doesn't support, and makes other small changes where needed." The patch was…

OS/2] Update OS/2 support in sqlite 3.7.x
September 29, 2010 04:42:23 PM
> > If the underlying VFS does not support shared-memory (which the OS/2 VFS > does not) then SQLite simply will not go into WAL mode. No patching is > needed for this. Everything should work as delivered. > > What exactly is…

rtree+ trigger + update cause incorrect result for the select statement
May 19, 2011 06:59:46 AM
Hello. It seems to me I've found a bug in the Sqlite. I have database with two tables. TestTable is ordinary table, TestTableRTree is virtual rtree table. Each table has two records. Also database has after update trigger for table TestTable,…

Re: [sqlite-dev] what's the wrong with my update function
February 22, 2011 07:57:34 AM
sqlite3_step can be called several times if your statement returns some rows (like select statement). In this case each call of sqlite3_step except last one will return SQLITE_ROW. Last call will return SQLITE_DONE. And in case of any error…

Re: Is it possible to update the same sqlite table using two different Linux pthread threads?
December 16, 2010 08:20:23 AM
Frank Chang <frankch### @gmail.com> wrote: > Good morning, If we use the latest version of sqlite, is it possible to > update the same sqlite table using two different Centos/RedHat Linux pthread > threads? Yes, but not at the…

Is it possible to update the same sqlite table using two different Linux pthread threads?
December 16, 2010 06:18:40 AM
Good morning, If we use the latest version of sqlite, is it possible to update the same sqlite table using two different Centos/RedHat Linux pthread threads? We are using the same database connection on both pthreads but we always update…

SQLITE return codes for insert/delete/update/select
May 11, 2011 02:53:21 PM
I dont know if it is just me but I find the return codes for SQL operation quite confusing. I am new to SQLITE, have learnt a few things and wanted to know if going in the correct direction, 1. Return code for an UPDATE/DELETE query (ignoring…

PATCH/puppet 05/18] moved the require statement just after the confine statement
May 19, 2011 01:18:47 AM
From: Joel Rosario <cirq### @gmail.com> Signed-off-by: James Turnbull <jam### @lovedthanlost.net> --- Local-branch: tickets/master/6693 lib/puppet/provider/group/groupadd_win.rb | 3 +-- lib/puppet/provider/user/useradd_win.rb | …

Bug? LIMIT in compound statement with UNION ALL seems to affect only the first SELECT statement if i
October 6, 2010 11:23:05 AM
Hi, everyone, This looks like a bug to me: --sql: CREATE TABLE t(a INTEGER); INSERT INTO "t" VALUES(1); INSERT INTO "t" VALUES(2); INSERT INTO "t" VALUES(3); INSERT INTO "t" VALUES(4); SELECT * FROM ( SELECT a FROM t WHERE a<=2 …

Re: sqlite] SELECT is Slow when run in C++ code compared to SQLite Administrator
September 20, 2010 08:08:52 AM
This is a multi-part message in MIME format. Have you timed the entire application instead of just the SQL query? Put both apps inside a system() call and time those. Are you sure they are both compiled with the same optimization? Michael D.…

sqlite queries execute faster in sqlite manager addon but take a lot of time to execute using a java
June 3, 2011 08:30:21 AM
Hi One of my sqlite query executes faster in sqlite manager( firefox addon ) but take a lot of time to execute using a java program. Here is the snippet PreparedStatement mStatement; ResultSet mResults; …

Questions and Answers are licensed under cc-wiki license.

How to sqlite statement to update duedate of the row whose name is myname and dob is mydob

0 Answers

Be the first to answer this question

Join with account you already have