Hi all,
I am creating a database to store the list of earthquakes as an update to my
existing app.
I am receiving an error with the following caused by statement:
Caused by: android.database.sqlite.SQLiteException: near ",": syntax error:
create table earthquakes (_id integer primary key autoincrement, date
INTEGER, details TEXT, latitude FLOAT, longitude FLOAT, magnitude FLOAT),
link TEXT);
My SQL statement is:
private static class earthquakeDatabaseHelper extends SQLiteOpenHelper {
private static final String DATABASE_CREATE =
"create table " + EARTHQUAKE_TABLE + " ("
+ KEY_ID + " integer primary key autoincrement, "
+ KEY_DATE + " INTEGER, "
+ KEY_DETAILS + " TEXT, "
+ KEY_LOCATION_LAT + " FLOAT, "
+ KEY_LOCATION_LNG + " FLOAT, "
+ KEY_MAGNITUDE + " FLOAT), "
+ KEY_LINK + " TEXT);";
As far as I can see the statement is fine. Please help.
Thanks
--
Raghav Sood
http://www.raghavsood.com/
http://wiki.androidappcheck.com/
http://www.telstop.tel/
https://market.android.com/developer?pub=Raghav+Sood
--
You received this message because you are subscribed to the Google
Groups "Android Developers" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en
