Hi,
Maybe you should try to call 'c.moveToFirst(); before to query to
the double value.
The ";" at the end of of your raw query is not mandatory and will
throw a warning log.
best regards,
- raymond-
On 2 mar, 06:11, rajesh chandrasekaran <crajeshdanger...@gmail.com>
wrote:
> 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 android-developers@googlegroups.com
To unsubscribe from this group, send email to
android-developers+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en
