Yes, I wrote an article on pagination years ago and it was published by the UT.
Here's the link
http://www.universalthread.com/ViewPageArticle.aspx?ID=847
Rafael Copquin
> On 10/24/13 06:39 AM, Alan Bourke wrote:
>> Oh for built-in paging functionality:)
>
> I was going to say that Rafael Copqui
On 10/24/13 06:39 AM, Alan Bourke wrote:
Oh for built-in paging functionality:)
I was going to say that Rafael Copquin had a paper on this, which I did
a test implementation of with some success.
Then Rafael himself popped up with his formula.
I didn't carry it further because I've been ret
On Thu, Oct 24, 2013, at 02:46 PM, Rafael Copquin wrote:
> I use this formula to determine the quantity of records visible in a
> grid:
>
Many thanks Rafael, clever approach, I will see if I can integrate it.
___
Post Messages to: ProFox@leafe.com
Sub
Hmmm. It's a list of customers and yearly turnover totals for current
year, year minus one and so on. The turnover totals aren't stored so I
am calculating them in the grid cursor SQL i.e.
select accountcode, name, Thisform.GetBalance(accountcode, 1) as prev1
... and so on. GetBalance() uses
I use this formula to determine the quantity of records visible in a grid:
nGridRowQty = int( (thisform.grid1.height - thisform.grid1.headerheight)
/ thisform.grid1.rowheight)
This gives you a very good estimate of the quantity of records that will
be visible in a grid with fontname= Arial an
On Thu, Oct 24, 2013, at 02:29 PM, Dave Crozier wrote:
>
> Personally I would make the underlying cursor a "SQL Expression" which
> you can modify then requery in order to refresh the cursor but this means
> that you are dealing wit disconnected data and so updates to the
> displayed data need t
n Bourke
Sent: 24 October 2013 14:24
To: profox@leafe.com
Subject: Grid visible set.
So I have a grid with a cursor behind it. The active index on the cursor can be
changed by the user, thus sorting the grid in different ways.
Is there any easy way of determine the subset of records visible
So I have a grid with a cursor behind it. The active index on the cursor
can be changed by the user, thus sorting the grid in different ways.
Is there any easy way of determine the subset of records visible in the
grid at any given time?
--
Alan Bourke
alanpbourke (at) fastmail (dot) fm
_
8 matches
Mail list logo