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
You could use "set filter to" but this can be VERY slow if the tables are af a
large size or the network connection isn't particularly quick.
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
7 matches
Mail list logo
