Thanks Guys for your help.
I found the problem. - It was the query.
The "limit" parameter for the number of rows returned is a String - as
to why it is a String rather than an int is anyones guess. However,
where I made my error was by having a leading and trailing space ie "
1 " instead of "1".
I would say that it was the format of your query. Is one of your
parameters a string and would need quoting, is the time format correct
etc?
Try replacing your parameterised query with a simple string (with no
parameters) that you have previously tested in the SQLite shell. Then
start putting b
Thanks, but I tried that earlier. moveToFirst() also calls count() and
results in same error ... sigh
On Oct 22, 5:08 pm, zhen guo wrote:
> before getCount, you should add cursor.moveToFirst().
>
> On Thu, Oct 22, 2009 at 1:05 PM, brucko wrote:
>
> > I'm having trouble with a SQLite database t
before getCount, you should add cursor.moveToFirst().
On Thu, Oct 22, 2009 at 1:05 PM, brucko wrote:
>
> I'm having trouble with a SQLite database that I have on the SDCard.
>
> when I do a query that returns a cursor I keep getting an error when i
> try to call the count() method.
>
> Here's t
4 matches
Mail list logo
