Re: [sqlite] Any Way to Peak at Next Row?

2009-03-10 Thread jonwood
> What you want is to fetch the data into memory first, and then process > it later. They way you describe the goal, you'd only have to keep 1 > record in memory. Yeah, I've been toying with that. It makes things a bit more complex than I'd like but sounds like that can't be avoided. > Also, if

Re: [sqlite] Any Way to Peak at Next Row?

2009-03-10 Thread Daniel Kasak
On Tue, 2009-03-10 at 20:28 -0700, jonwood wrote: > I'm creating some reports with some SQLite data. One report groups data by > one column and subtotals each group. > > It's working well but it really doesn't look right when the last item in a > group is at the bottom of the page and the

[sqlite] Any Way to Peak at Next Row?

2009-03-10 Thread jonwood
I'm creating some reports with some SQLite data. One report groups data by one column and subtotals each group. It's working well but it really doesn't look right when the last item in a group is at the bottom of the page and the subtotal is then orphaned on the start of the next page. I really