Re: [sqlite] Questions from a novice - basic browsing of records ina listview.

2014-07-12 Thread RSmith
On 2014/07/12 14:26, - wrote: Hello Ryan, Thanks for your response. I was writing a lengthy reply when I realized that most of what I said in it where repetitions of what I have already said earlier, so I deleted it. To be honest, its well possible that I currently just can't wrap my head

Re: [sqlite] Questions from a novice - basic browsing of records ina listview.

2014-07-12 Thread -
rom a novice - basic browsing of records ina listview. > > > > >> What if the table has 10^16 or more items? > > Is that number within the limits as set by SQLite3 ? Than its my intention > > to handle it. > > No, I just made that up out of thin air. SQLite's maximum

Re: [sqlite] Questions from a novice - basic browsing of records ina listview.

2014-07-10 Thread RSmith
Quick typo/fact check: ...// What if the table has 10^16 or more items? (This is more than the amount of stars in the known universe//... should of course read: ...// What if the table has 10^24 or more items? (This is more than the amount of stars in the observable universe//...

Re: [sqlite] Questions from a novice - basic browsing of records ina listview.

2014-07-10 Thread RSmith
On 2014/07/10 16:04, - wrote: You could set a very big maximum (e.g. 5000 rows) on the assumption that users will never actually read or scroll through that many rows. :-) In that case I would simply use a simple listview (a listview can handle upto 32000 records), and see if I can use its

Re: [sqlite] Questions from a novice - basic browsing of records ina listview.

2014-07-10 Thread -
ussion of SQLite Database <sqlite-users@sqlite.org> Sent: Thursday, July 10, 2014 2:17 PM Subject: Re: [sqlite] Questions from a novice - basic browsing of records ina listview. > > On 10 Jul 2014, at 12:54pm, - <mz2n6u7c.temp...@xs4all.nl> wrote: > > > But it might cause

Re: [sqlite] Questions from a novice - basic browsing of records ina listview.

2014-07-10 Thread -
General Discussion of SQLite Database <sqlite-users@sqlite.org> Sent: Wednesday, July 09, 2014 3:11 PM Subject: Re: [sqlite] Questions from a novice - basic browsing of records ina listview. > How about using prepared statements in conjunction with bind? > > http://www.sqlite.org/c3ref