Re: Sybase - Selecting specific numbers of records

["Lu, Clint" <Clint.Lu@MDMNETWORK.COM>]

I put my 2 cents in this situation. If you run sqr, here steps you have to
do.

1/ create a temp table in the program
2/ you have to do SQL statement in program that select records from live
table not exists in temp table.
3/ insert the records that users just selected
4/ clean up a temp table when users exit program


---------------------------------------------
Clint Lu
Caremark Rx, Inc.
Phone: 847-559-4717
Fax    : 847-559-4840




-----Original Message-----
From: Khaled Abdel-Rahman [mailto:khaled.abdel-rahman@DB.COM]
Sent: Tuesday, October 26, 1999 3:19 PM
To: Multiple recipients of list SQR-USERS
Subject: Re: Sybase - Selecting specific numbers of records


Hi,
     More Details about the question..

I'm working in an Intranet Application which makes specific internal data
available for specific user. The data are huge (20,000 records). The design
is to show the first 500 records, which are the recent, then allow the user
to choose to next 500 and so on. What I'm looking for is how to do that
from database prospective. First I'm going to get the first 500 Hundreds.
Then, when the user clicks next it will re-query the database and should
show records from 501-1000 and so on.

Querying the database for all of the records will slow down the system.


Best Regards,
Khaled