Re: Fetching more records for a grid

My users are used to an application that "browses" the entire database. The
application (or a version of it) goes all the way back to FPD 2.x and DOS.

I theory, with the current version of the app, they can scroll all the way
from the first record of the table to the last record of the table. The
table has several million records so in practice, nobody ever goes through
the entire database.

If I'm going to convert this app to something that can use SQL and views, I
need some way to simulate the feel of the existing application.

That is why I need to be able to fetch the next (or previous) group of
records.

Right now I put buttons on the form to do it and that will probably work
fine but it would be nice if it were more elegant.

Thanks,
Jeff
"Dan Freeman" <spam@xxxxxxxxxxxxx> wrote in message
news:OZU08JFAIHA.4612@xxxxxxxxxxxxxxxxxxxxxxx
Wouldn't be natural at all. Highly unnatural, in fact.

This will be a lot of work and probably be confusing to users. They're
used to the last record being at the bottom, not "the last until you ask
for more".

I'm sitting here trying to think of *any* other application that works as
you've described and I can't come up with anything. I'd rethink this.

Dan

Jeff Grippe wrote:
Hello and thanks in advance for the help...

I have a grid control which is based on a small table that is
extracted from a larger table. When the user scrolls to the last row,
I would like to be able to requery and show the next (or previous if
the user scroll up from the first record) batch of records.

How do you detect all of the various method (Keyboard, Scroll Bars,
Etc.) that the user might be using to scroll up from the top or down
from the bottom.

I could put menu items on the menu to requery but it would be more
natural if they could just work in the grid.

Thanks,
Jeff




.