At 02:48 pm 13/12/00 +1300, Colin Fraser said:
>For example, say the user queries the DB and has a result set of say 100
>records and you only want to show 10 records at a time...
>
>Without knowing too much about this stuff, my first thought would be to have
>a hidden field or a URL parameter that holds the current record or page, and
>have this passed back to the CGI or ISAPI app when the user clicks forward
>or back.
First things first. I have recently completed a fairly large client server
CGI app that is running successfully with large amounts of data and,
although I had my theories planned, this actual eventuality never came up
as the selection form purposefully ensured that only a screen full of
records or less were returned each time.
An example in my app was that a person from a particular company (known
from the login they did) asked to view some transactions, they were first
asked to search for the transactions using such things as a combobox for
month, machine, driver etc. They may be able to select [All] for the driver
but could only select from known machines and one of the twelve months
(just the way the business worked).
They could narrow the search down further, but even with only the required
fields selected, the records returned would be minimal.
i.e. Company x, machine y, and only for month z.
Otherwise, go with what you have suggested. As someone else pointed out, so
what if they see record 9 twice.
Another theory would be to save the records out to a local paradox table
with the name of the table as the login person's ID - e.g "QRY123" - but I
always feel that this is messy and runs the risk of leaving lots of
droppings (temporary files) all over your hard disks.
But then you could automatically clean out any files in the C:\whatever\
directory that are more than, say, 10 hours old whenever someone logs in or
at midnight or something.
Good luck.
Steve
Steve Peacocke
With the Vizslas Amongst Kiwifruit, Avacados, Pheasants and Quail in the
sunny Bay of Plenty
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of "unsubscribe delphi"
