Re: Sybase - Selecting specific numbers of records

[Manoj Gurjar <mgurjar@HOTMAIL.COM>]

Bob forgot to increment counter.

move 0 to #count  ! might have to initialize by 1
begin-select
col1

   let #count = #count + 1
   if #count >= 10 and #count <= 20

         do processing
   end-if

from table
end-select

Manoj
>From: Bob Buford-Abba Systems <bbuford@GALEIND.COM>
>Reply-To: SQR-USERS@list.iex.net
>To: Multiple recipients of list SQR-USERS <SQR-USERS@list.iex.net>
>Subject: Re: Sybase - Selecting specific numbers of records
>Date: Tue, 26 Oct 1999 13:15:24 -0400
>
>Welcome Khaled,
>
>You could put a counter initialized to 0 before the select and put an if
>statement within the loop that acts only when counter is between 10 and 15
>
>e.g.
>
>move 0 to #count
>begin-select
>col1
>
>   if #count >= 10 and #count <= 20
>
>         do processing
>   end-if
>
>from table
>end-select
>
>Bob
>
>-----Original Message-----
>From: Khaled Abdel-Rahman [mailto:khaled.abdel-rahman@DB.COM]
>Sent: Tuesday, October 26, 1999 12:22 PM
>To: Multiple recipients of list SQR-USERS
>Subject: Sybase - Selecting specific numbers of records
>
>
>Hi,
>      This is my first question to the list an the following is my first
>question!!!!!
>
>      Suppose you have a table which has 20 rows, I want to get only rows
>from 10-15. How can I don that?!
>
>      Thanks in advance,
>      Best Regards,
>      Khaled

______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com