Android Question problem with sql

[tufanv]

Hello,

I am using names.sql file in my app . It has 1432 record in "tblnames". In my app i can find every record upto 1000th record but after 1000th record i cant get them. When i look at sqlite i see that it is divided into 2 pages when browsing data and second page is not being found by my app. What can i do ?

Thank you

 

[eps]

Code?

 

[tufanv]

cursornames = sqlnames.ExecQuery("SELECT * FROM tblnames where win<5 ORDER BY id ASC ")
cursornames.Position = 0
h2 = cursornames.GetString("name")

The code works perfect for the win>5 but win<5 is after record number 1100 till 1400 so after 1000th record the problem occurs

 

[eps]

if you execute this code in SQLite browser or Firefox Extension what does it return, the same or different?

If you execute this, in SQLite browser or FF extension, what does it return?

SELECT count(*) FROM tblnames where win<5 ORDER BY id ASC

and then

SELECT count(*) FROM tblnames where win<5

 

[tufanv]

both shows 0 in sqlite. But it is strange i tried
SELECT count(*) FROM tblnames where win>43435434343 ORDER BY id ASC
it shows 1437 records ( all the records) altough my biggest value for win is 29

 

[eps]

win isn't text is it?

 

[eps]

I suspect it's a bit of javascript funkiness where it's only (possibly) considering the first character...

 

[tufanv]

field name is win but the values are digits sir. it is not configured as text in sql file

 

[tufanv]

ok i fixed it. You gave me a good clue about it. I changed the win field to numeric. It is ok now ! thank you very much for the help

 

[eps]

pls Like the post that helped, it may help others your issue rang a bell about another issue I'd seen recently.

 

[tufanv]

ok done. Thank you again