[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 wrote: > Without the angle brackets, right? > > adb uninstall com.sho

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" написал: Yes that is definately what iI did, replace with On Sep 3, 3:03 pm, Kostya Vasilyev wrote: > 03.09.2010 17:

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

2010-09-03 Thread kingh32
Yes that is definately what iI did, replace with On Sep 3, 3:03 pm, Kostya Vasilyev 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 " > > So if your code is in package "org.knigh32.Shoo

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 " So if your code is in package "org.knigh32.ShootingRangeStats", you'd do this: adb uninstall org.knigh32.ShootingRangeStats -- Kostya Vasilyev -- WiFi

[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 wrote: >   What does it mean that adb uninstall doesn't work? What is the error > message? > > Are you using your

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 ? The "question mark" syntax is for being able to specify SQL statement parameters separately from the statement itself. This separates the SQL statement logic from

[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 I've also tried adb uninstall [-k] and adb uninstall [] 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 table with 9 columns.

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, w

[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 D/AndroidRuntime(

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" написал: Thanks for spotting the comma. I've removed it but it still cites this query a

[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. Ho

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 queri

[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 wrote: > Thank you for both of your replies. I have tried implementing both of > your suggestions but neither has worked.

[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 com.targetshooter

[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,