The next-to-last argument to db.update is the WHERE clause, but without
the WHERE (look it up in a SQL reference).
So while in SQL you'd write "WHERE SwitchName = value", with db.update
you need to use "SwitchName = value".
The last argument is used supply variable values to the conditions. This
is more efficient as well as safer. Each value in the last argument
(which is an array) replaces one "?" placeholder in the condition.
The entire statement might look like this:
sampleDB.update(SWITCH_TABLE_NAME, args, "SwitchName = ?", new String[]
{ oldSwitchName} );
-- Kostya
02.12.2010 14:24, pramod.deore пишет:
Hi, I have a table with 5 columns.
1. RoomID
2. RoomName
3.RoomSuffix
4. SwitchID
5. SwitchName
I have some data in this table. Now I want to update database. How to
do this? I search for this but didn't get well answer
I had tried it like:
sampleDB = this.openOrCreateDatabase(SAMPLE_DBNAME, MODE_PRIVATE,
null);
ContentValues args = new ContentValues();
args.put(SwitchName, switchRename);
Here I want to put SwitchName value as switchRename.
Now I execute method as:
sampleDB.update(SWITCH_TABLE_NAME, args, SwitchName
+'menuItemName',null);
But here second last argument (i.e where clause give me an error).In
where clause I want as "SwitchName = 'xyz' " i.e where SwitchName is
xyz. How to write this where condition correctly?
--
Kostya Vasilyev -- WiFi Manager + pretty widget -- http://kmansoft.wordpress.com
--
You received this message because you are subscribed to the Google
Groups "Android Developers" group.
To post to this group, send email to android-developers@googlegroups.com
To unsubscribe from this group, send email to
android-developers+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en
