you still need to specify the column list:
select first 5 * from customers;

-----Original Message-----
From: rockwithme77 [mailto:rockwithme77@...]
Sent: 15 August 2003 09:52
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Re: SQL Limit Command


Hi Michael,

Select first 5 from customers;

This gives an error.

Can you help me out pls.

Regards,
S.

--- In firebird-support@yahoogroups.com, "Michael Olschimke"
<olschimke@g...> wrote:

>
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Check
>
> SELECT FIRST X SKIP X
>
> HTH
>
> Michael
>
> - -----Original Message-----
> From: rockwithme77 [mailto:rockwithme77@y...]
> Sent: Freitag, 15. August 2003 09:59
> To: firebird-support@yahoogroups.com
> Subject: [firebird-support] SQL Limit Command
>
>
> Hi,
>
> Is there a way to limit SQL record fetch in FB like the limit
> command ?
>
> Regards,
> S.
>
>
>
>
> - ------------------------ Yahoo! Groups Sponsor -------------------

--~--> Buy Ink Cartridges or Refill Kits for Your HP, Epson, Canon or
Lexmark Printer at Myinks.com. Free s/h on orders $50 or more to the
US & Canada. http://www.c1tracking.com/l.asp?cid=5511

> http://us.click.yahoo.com/l.m7sD/LIdGAA/qnsNAA/67folB/TM
> - ------------------------------------------------------------------

---~->

>
> To unsubscribe from this group, send an email to: firebird-support-

unsubscribe@yahoogroups.com

>
>
>
> Your use of Yahoo! Groups is subject to

http://docs.yahoo.com/info/terms/

>
>
> -----BEGIN PGP SIGNATURE-----
> Version: PGP 8.0
>
> iQA/AwUBPzyUMuHaa+PgJ6iLEQJvZgCeMVhr+MpnrwSQc4UhdDIxSDkoGbcAoO9Z
> Zk2J8FizbZrw6oW1rTrGFLFp
> =e4dn
> -----END PGP SIGNATURE-----

To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/