Re: SQL return limits

["PHUNG, BINH" <BPHUNG@FINEHOST.COM>]

i got it!
SQL 7.0 QUERY tool have properities setting.
Found them.
Thank You

> -----Original Message-----
> From: Dray, Adam [SMTP:Adam.Dray@PHH.COM]
> Sent: Friday, November 12, 1999 4:54 PM
> To:   Multiple recipients of list SQR-USERS
> Subject:      Re: SQL return limits
>
> You haven't told us what database you use.  Generally, 'set'
> commands in SQL are used before the statement:
>
>     set record limit=100
>     select * from ps_ap_invoices
>
> But this won't work in Sybase, as far as I know.  Tell us what
> database you're using and we can help you better.
>
> > -----Original Message-----
> > From: PHUNG, BINH [SMTP:BPHUNG@FINEHOST.COM]
> > Sent: Friday, November 12, 1999 4:44 PM
> > To:   Multiple recipients of list SQR-USERS
> > Subject:      Re: SQL return limits
> >
> > will that command work in pure SQL.
> > something like this?
> > select * from ps_ap_invoices
> > set record limit=100
> >