Android Sqlite - Updating a table for a string

Question

I have a simple question : I'm new to sql so i have this question :

The below method works if names is a number. How to write this query if names is a string?

ourDatabase.update(DATABASE_TABLE, cv , KEY_NAME + "=" + names, null);

The Badak · Accepted Answer · 2014-04-10 08:32:27Z

2

String literals in SQL are quoted in 'single quotes'.

Though it's preferable to use ? literal placeholders and bind arguments here, e.g.

ourDatabase.update(DATABASE_TABLE, cv, KEY_NAME + "=?", new String[]{names} );

The Badak

2,0602 gold badges16 silver badges30 bronze badges

answered Apr 10, 2014 at 8:25

laalto

153k68 gold badges293 silver badges306 bronze badges

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

5 Comments

I copied and pasted your code but it gave me an error ! Invalid syntax expression on "?"

@user3496326, you should change KEY_NAME + "=" + ? to KEY_NAME + "=?"

Yes there was a missing terminating " - added by @Ȃŵåiṩĸîŋg edit.

@laalto Thanks a lot mate :) been searching this simple thing for an hour :)

Thanks to @laalto for adding this answer and good to hear that is working