[android-developers] Re: sqlite returned: error code = 1, msg = table customer has no column named totalpurchase
Not true. One simply needs to implement the database update stuff. On Nov 16, 2:47 am, Kumar Bibek coomar@gmail.com wrote: You probably have to uninstall and re-install the app if you added the column later. On Tue, Nov 16, 2010 at 2:08 PM, Rahul Garg rahul.lnm...@gmail.com wrote: Hi guys, I am facing problem with my database while inserting values that it is showing that it has no column named totalpurchase. While I clearly declared it in my table and the other columns are not showing this problem. can you suggest what is wrong with this. -- Rahul -- 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.comandroid-developers%2bunsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en -- Kumar Bibekhttp://techdroid.kbeanie.comhttp://www.kbeanie.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
Re: [android-developers] Re: sqlite returned: error code = 1, msg = table customer has no column named totalpurchase
Update stuff might not be the right solution while developing. On Tue, Nov 16, 2010 at 6:07 PM, DanH danhi...@ieee.org wrote: Not true. One simply needs to implement the database update stuff. On Nov 16, 2:47 am, Kumar Bibek coomar@gmail.com wrote: You probably have to uninstall and re-install the app if you added the column later. On Tue, Nov 16, 2010 at 2:08 PM, Rahul Garg rahul.lnm...@gmail.com wrote: Hi guys, I am facing problem with my database while inserting values that it is showing that it has no column named totalpurchase. While I clearly declared it in my table and the other columns are not showing this problem. can you suggest what is wrong with this. -- Rahul -- 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.comandroid-developers%2bunsubscr...@googlegroups.com android-developers%2bunsubscr...@googlegroups.comandroid-developers%252bunsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en -- Kumar Bibekhttp://techdroid.kbeanie.comhttp://www.kbeanie.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.comandroid-developers%2bunsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en -- Kumar Bibek http://techdroid.kbeanie.com http://www.kbeanie.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
[android-developers] Re: sqlite returned: error code = 1, msg = table customer has no column named totalpurchase
First thing to do is to VERY CAREFULLY read the code that you use to create the DB and to reference the column. Very likely the problem is a typo in one of the names or in the definition statements. Check carefully the spelling of everything. And it never hurts to do as Kumar suggests and delete, then reinstall the app. Plus you might want to try cleaning your project and building anew. On Nov 16, 2:38 am, Rahul Garg rahul.lnm...@gmail.com wrote: Hi guys, I am facing problem with my database while inserting values that it is showing that it has no column named totalpurchase. While I clearly declared it in my table and the other columns are not showing this problem. can you suggest what is wrong with this. -- Rahul -- 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
[android-developers] Re: sqlite returned: error code = 1, msg = table customer has no column named totalpurchase
The only way to be sure that the table and its colums are as you think they should be is to connect to the sqlite database on your emulator/ device and check the schema that's there. So: adb -s emulator_device_id shell sqlite3 /data/data/your_package/databases/app_name.db .schema tablename On 16 nov, 09:38, Rahul Garg rahul.lnm...@gmail.com wrote: Hi guys, I am facing problem with my database while inserting values that it is showing that it has no column named totalpurchase. While I clearly declared it in my table and the other columns are not showing this problem. can you suggest what is wrong with this. -- Rahul -- 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
[android-developers] Re: sqlite returned: error code = 1, msg = table customer has no column named totalpurchase
You may also want to check out this post http://www.designerandroid.com/?p=54 This will help your development -- 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
Re: [android-developers] Re: sqlite returned: error code = 1, msg = table customer has no column named totalpurchase
If you have seriall , I would suggest to check the schema in the application database by sqlite .schema and check the column name again(making sure its present in the table) and structure of table. On Tue, Nov 16, 2010 at 6:10 PM, DanH danhi...@ieee.org wrote: First thing to do is to VERY CAREFULLY read the code that you use to create the DB and to reference the column. Very likely the problem is a typo in one of the names or in the definition statements. Check carefully the spelling of everything. And it never hurts to do as Kumar suggests and delete, then reinstall the app. Plus you might want to try cleaning your project and building anew. On Nov 16, 2:38 am, Rahul Garg rahul.lnm...@gmail.com wrote: Hi guys, I am facing problem with my database while inserting values that it is showing that it has no column named totalpurchase. While I clearly declared it in my table and the other columns are not showing this problem. can you suggest what is wrong with this. -- Rahul -- 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.comandroid-developers%2bunsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en -- 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