List View with many records

[cirollo]

Hi!

I'm having a real big problem.
I have a listview that show data from customer table
For testing purpose I used approx 100 record.

Going to my customer, the table was filled with 2940 records.
Each record has 15 fields
When I open the ListView the process is closed and the program crashed

what could be????

 

[timo]

...The 'Load more' solution is more complicated and I have not seen an example of it yet...

Not so complicated.
I've prepared a simple 'rude' example (where you should still eventually add some eor control) that could maybe help:

 

[thedesolatesoul]

'rude'

I think you meant 'crude'
Nice one timo, but I still think restructuring is important, and a user will not want to go through 100 pages to find a record.

 

[timo]

'crude' eh!eh!.

However, it was just for the mechanism. You don't necessarily have to calculate '/10' as i've made, and that query was only an example; if you add WHERE is more useful. (TotRows/NumRows in fact refers only to the queryresult)

P.S.
a modif.ver. here: http://www.b4x.com/forum/basic4android-getting-started-tutorials/16353-load-more-sqlite.html