I am writing an open source program.
I am having trouble getting any results using this query. This returns none....
select * from signs where lon>-121 and lon<-119;
onCreate(SQLiteDatabase db) {
db.execSQL("CREATE TABLE " + TABLE_NAME + " (" + _ID
+ " INTEGER PRIMARY KEY AUTOINCREMENT, " + TIME
+ " VARCHAR(45), " + TAGG
+ " VARCHAR(45), " + LAT
+ " FLOAT , " + LON
+ " VARCHAR(45), " + COG
+ " VARCHAR(45), " + MPH
+ " VARCHAR(45), " + KPH
+ " TEXT NOT NULL);");
}
Here is the database using RazorSQL v504
select * from signs;
_id time tag lat lon cog mph kph
1 1264890306692 test 20.0 -120.0 0.0 45.0 0.0
2 1264890311484 test 20.0 -120.0 0.0 45.0 0.0
3 1264890345263 test 20.0 -120.0 0.0 45.0 0.0
4 1264890346700 test 20.0 -120.0 0.0 45.0 0.0
-----------
I have tried lon= varchar(45) and also as a FLOAT, and both don't seem
to handle negative numbers correctly.
Any help appreciated!
Jim
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
