[android-developers] Re: SQLite implementation - need help!

2010-09-05 Thread kingh32
I tried this and... it works! Thank you for your help, it now displays a list of the the most recent update to the database. (only one item in the list) but for now this will do. Many thanks On Sep 4, 5:55 pm, Kostya Vasilyev kmans...@gmail.com wrote: Without the angle brackets, right? adb

Re: [android-developers] Re: SQLite implementation - need help!

2010-09-04 Thread Kostya Vasilyev
Without the angle brackets, right? adb uninstall com.shootingrange Like that? -- Kostya Vasilyev -- http://kmansoft.wordpress.com 03.09.2010 18:09 пользователь kingh32 horaceb1...@gmail.com написал: Yes that is definately what iI did, replace package with com.shootingrange On Sep 3, 3:03

Re: [android-developers] Re: SQLite implementation - need help!

2010-09-03 Thread Kostya Vasilyev
You have an error in the SQL for creating the table: 03.09.2010 5:54, kingh32 пишет: + shotsPerRound, INTEGER The comma should be at the end shotsPerRound INTEGER,. This misplaced comma causes the shooter column to not be created. Also, you really want to use parametrized queries

[android-developers] Re: SQLite implementation - need help!

2010-09-03 Thread kingh32
Thanks for spotting the comma. I've removed it but it still cites this query as an error. In fact, no matter what I try to do the same error is displayed. Even if I change the intent pointing to this class, to completely different non database related class I still get this error and it crashes.

Re: [android-developers] Re: SQLite implementation - need help!

2010-09-03 Thread Kostya Vasilyev
Your database creation statements have if exists in them. Did you make sure the database actually got recreated? -- Kostya Vasilyev -- http://kmansoft.wordpress.com 03.09.2010 14:36 пользователь kingh32 horaceb1...@gmail.com написал: Thanks for spotting the comma. I've removed it but it still

[android-developers] Re: SQLite implementation - need help!

2010-09-03 Thread kingh32
Hello, I've sorted that problem now. I'm using adb to check that the database gets made and it does. I have this error now. 53): Starting activity: Intent { cmp=com.targetshooterapp/. DBAdapter } E/CursorWindow( 1354): Bad request for field slot 0,-1. numRows = 1, numColumns = 2

Re: [android-developers] Re: SQLite implementation - need help!

2010-09-03 Thread Kostya Vasilyev
I believe that one of the columns is still missing, so you get this error at one of these lines: cursor.getString(cursor.getColumnIndex(blah)) Where getColumnIndex() returns -1, because the column is not in the query results, and getString() is being asked to get the data for column -1,

[android-developers] Re: SQLite implementation - need help!

2010-09-03 Thread kingh32
I cant get adb uninstall to work I'm doing this adb uninstall package I've also tried adb uninstall [-k]package and adb uninstall []package In the mean time I've created another database and tried to populate it with the new queries but it still tells me that I'm trying to populate an 8 column

Re: [android-developers] Re: SQLite implementation - need help!

2010-09-03 Thread Kostya Vasilyev
What does it mean that adb uninstall doesn't work? What is the error message? Are you using your actual package name instead of package? The question mark syntax is for being able to specify SQL statement parameters separately from the statement itself. This separates the SQL statement

[android-developers] Re: SQLite implementation - need help!

2010-09-03 Thread kingh32
It says that there was a syntax error in my command. Thanks for the info on the ?s. Can imagine why its used, this looks a mess! Will try this now On Sep 3, 2:51 pm, Kostya Vasilyev kmans...@gmail.com wrote:   What does it mean that adb uninstall doesn't work? What is the error message? Are

Re: [android-developers] Re: SQLite implementation - need help!

2010-09-03 Thread Kostya Vasilyev
03.09.2010 17:58, kingh32 пишет: It says that there was a syntax error in my command. I think it's useful to learn. Use adb uninstall your package name here So if your code is in package org.knigh32.ShootingRangeStats, you'd do this: adb uninstall org.knigh32.ShootingRangeStats --

[android-developers] Re: SQLite implementation - need help!

2010-09-03 Thread kingh32
Yes that is definately what iI did, replace package with com.shootingrange On Sep 3, 3:03 pm, Kostya Vasilyev kmans...@gmail.com wrote:   03.09.2010 17:58, kingh32 пишет: It says that there was a syntax error in my command. I think it's useful to learn. Use adb uninstall your package name

[android-developers] Re: SQLite implementation - need help!

2010-09-02 Thread kingh32
Thank you for both of your replies. I have tried implementing both of your suggestions but neither has worked. I've found another way to do it though and I've had some success although displaying it as a listview seems to be really difficult. This is what I've written... package

[android-developers] Re: SQLite implementation - need help!

2010-09-02 Thread kingh32
Just to add, it gives me the same error even when i completely change the query and remove the apparently non existent column. I'm really confused! On Sep 3, 2:43 am, kingh32 horaceb1...@gmail.com wrote: Thank you for both of your replies. I have tried implementing both of your suggestions but

[android-developers] Re: SQLite implementation - need help!

2010-09-01 Thread San
Hey King, Your SQL query is not right. You have to give space before you add the type. Try this String sql = create table + TABLE_EVENT + (_id integer not null primary key autoincrement, + COL_ENTRYID + integer, + COL_EVENTNAME + varchar, + COL_DATE + date, +