[android-developers] Insert data using SQLite Database with Insert + Where Clause after already entered data in next colums!

I would like to Insert data in my next columns of TABLE with help of Signup2Activity which has been already inserted by SIgnup1Activity.java. HereBy i had attached all the necessary file to find the error. ERROR: Database: near Where: near INSERT INTO+TABLE+ ( +columns+) VALUES

Re: [android-developers] Insert data using SQLite Database with Insert + Where Clause after already entered data in next colums!

I do not believe that there is any SQL database that supports a WHERE clause on INSERT. For questions regarding SQLite SQL syntax, please use a SQLite support resource, or a generic support resource (e.g., StackOverflow). On Tue, Jul 24, 2012 at 9:06 AM, vikalp patel vikalppatel...@gmail.com

Re: [android-developers] Insert data using SQLite Database with Insert + Where Clause after already entered data in next colums!

As Mark writes the syntax is not valid. You should use update. Please refer to the SQLite documentation for specific syntax questions - to the best of my knowledge the official documentation of standard SQLite also covers the features available on Android: http://www.sqlite.org/lang_update.html