Re: [sqlite] Getting the "position" (like LIMIT) for a query

On Sat, Jan 10, 2009 at 04:26:56PM -0600, Nicolas Williams wrote: > Incidentally, I think many, if not all queries that have an outer table > scan, and many, if not all joins that have an inner table scan but not > an outer table scan, could be programmatically modified to create a > scrolling

Re: [sqlite] Getting the "position" (like LIMIT) for a query

Lukas Haase schrieb: > Igor Tandetnik schrieb: >> "Lukas Haase" wrote in >> message news:gkat07$n2...@ger.gmane.org >>> I use an SQLite database to fill a virtual list control in Windows. In >>> this control, I just tell the control the numer of my elements and the >>> control

Re: [sqlite] Getting the "position" (like LIMIT) for a query

Williams Sent: Saturday, January 10, 2009 4:27 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Getting the "position" (like LIMIT) for a query On Sat, Jan 10, 2009 at 04:33:19PM -0500, Igor Tandetnik wrote: > "Lukas Haase" <lukasha...@gmx.at> wrote

Re: [sqlite] Getting the "position" (like LIMIT) for a query

Igor Tandetnik schrieb: > "Lukas Haase" wrote in > message news:gkat07$n2...@ger.gmane.org >> I use an SQLite database to fill a virtual list control in Windows. In >> this control, I just tell the control the numer of my elements and the >> control tells me for which range

Re: [sqlite] Getting the "position" (like LIMIT) for a query

On Sat, Jan 10, 2009 at 04:33:19PM -0500, Igor Tandetnik wrote: > "Lukas Haase" wrote in > message news:gkat07$n2...@ger.gmane.org > > "SELECT keyword FROM keywords ORDER BY keyword LIMIT %d, %d", iFrom, > > iTo-iFrom." > > > > I use an SQLite database to fill a virtual list

Re: [sqlite] Getting the "position" (like LIMIT) for a query

"Lukas Haase" wrote in message news:gkat07$n2...@ger.gmane.org > I use an SQLite database to fill a virtual list control in Windows. In > this control, I just tell the control the numer of my elements and the > control tells me for which range data is needed.

[sqlite] Getting the "position" (like LIMIT) for a query

Hello, I use an SQLite database to fill a virtual list control in Windows. In this control, I just tell the control the numer of my elements and the control tells me for which range data is needed. For example I set: SELECT COUNT(*) FROM keywords; to tell the control the numer of elements.