re: Grid visible set

2013-10-24 Thread rcopquin
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

Re: Grid visible set.

2013-10-24 Thread Dan Covill
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

Re: Grid visible set.

2013-10-24 Thread Alan Bourke
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

Re: Grid visible set.

2013-10-24 Thread Peter Cushing
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

Re: Grid visible set.

2013-10-24 Thread Rafael Copquin
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

Re: Grid visible set.

2013-10-24 Thread Alan Bourke
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

RE: Grid visible set.

2013-10-24 Thread Dave Crozier
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

Grid visible set.

2013-10-24 Thread Alan Bourke
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 _