Re: SQL return limits

[Manoj Gurjar <mgurjar@HOTMAIL.COM>]

For SQR :
A) Use LOOPS with Begin-select to specify no of rows.

  Begin-select LOOPS=100
B) Some counter
  let #i = 1
  Begin-Select
  Fields
    let #i=#i+1

    do all-processing
    if #i = 100    ! before FROM
       break
    end-if
  FROM table
  where....

3) On Oracle Backend Select use ROWNUM <= 100 in where.

HTH
Manoj
>From: "PHUNG, BINH" <BPHUNG@FINEHOST.COM>
>Reply-To: SQR-USERS@list.iex.net
>To: Multiple recipients of list SQR-USERS <SQR-USERS@list.iex.net>
>Subject: SQL return limits
>Date: Fri, 12 Nov 1999 16:23:14 -0500
>
>Hi All.
>
>Is there a way to limit the number of returned records in an SQL statement?
>examples, the table contain 100,000 records. I just want the first 100
>records.
>
>Thank You
>Binh

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