Re: [GENERAL] Howto only select secific lines from a result?

2010-08-08 Thread Alban Hertroys
On 8 Aug 2010, at 3:37, Clemens Eisserer wrote: > What I would need is a LIMIT command, which allows to LIMIT the > results in two ways. > Is there some way to select only specific lines from a result, something like: > Select * from table Where RESULNR BETWEEN 1000 and 1040? > > Or do you have a

Re: [GENERAL] Howto only select secific lines from a result?

2010-08-07 Thread Thom Brown
On 8 August 2010 02:37, Clemens Eisserer wrote: > Hi, > > I am working on a graphical table display widget which should be able > to display huge amounts of data, by lazy-loading database values. It > already works well if the primary-key and line-number are equal. > However I don't have any idea

[GENERAL] Howto only select secific lines from a result?

2010-08-07 Thread Clemens Eisserer
Hi, I am working on a graphical table display widget which should be able to display huge amounts of data, by lazy-loading database values. It already works well if the primary-key and line-number are equal. However I don't have any idea howto handle the case where the primary-key contains holes,