New topic: Select returns too many records...
<http://forums.realsoftware.com/viewtopic.php?t=31379> Page 1 of 1 [ 2 posts ] Previous topic | Next topic Author Message JustSomeGuy Post subject: Select returns too many records...Posted: Wed Dec 02, 2009 12:00 pm Joined: Fri May 11, 2007 11:35 am Posts: 668 If you perform a select and it returns a gazillion records, you can't display them all on a listbox as the listbox will go boom. How can you paginate the record set into groups of a more manageable size? I know you can keep the record set and do it manually, but is there some SQL magic that I might be missing? _________________ A picture paints a thousand words. A thought paints a thousand pictures. Top timhare Post subject: Re: Select returns too many records...Posted: Wed Dec 02, 2009 12:42 pm Joined: Fri Jan 06, 2006 3:21 pm Posts: 6882 Location: Portland, OR USA You can use LIMIT and OFFSET to walk through static data a chunk at a time, as long as you aren't adding or deleting records at the same time - that would throw your offsets off. Or you can come up with some more ingenious ways to achieve the same thing with dynamic data. Top Display posts from previous: All posts1 day7 days2 weeks1 month3 months6 months1 year Sort by AuthorPost timeSubject AscendingDescending Page 1 of 1 [ 2 posts ] -- Over 1500 classes with 29000 functions in one REALbasic plug-in collection. The Monkeybread Software Realbasic Plugin v9.3. http://www.monkeybreadsoftware.de/realbasic/plugins.shtml [email protected]
