Hi ALL,
I am getting few problem in sqlite.
This is my schema for the userScoreTable
CREATE TABLE userScoreTable (sno integer primary key
AUTOINCREMENT,userName VARCHAR, setID INT(5), score INT(5),
totalTimeTaken DOUBLE);
this is my data in the userScoreTable
1|Rock|1|20|11214.0
2|Rock|2|40|11632.0
This is my code
c = myDB.rawQuery("SELECT totalTimeTaken FROM userScoreTable where
userName = 'Rock' AND setID = 2;", null);
int lastColumn = c.getColumnIndex("totalTimeTaken");
double jjj = c.getDouble(lastColumn);
But i not getting any value in jjj.
Wht the problem?, any range problem?
Please help me..........
Thanks
C.Rajesh
--
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
