| Subject | RE: [ib-support] mySQL Limit to Firebird |
|---|---|
| Author | Leyne, Sean |
| Post date | 2001-04-26T13:01:09Z |
Tilo,
Ann Harrison is currently working on exposing the existing TOP X syntax
(it's in the engine just not exposed to the SQL interface) as part of
the work for Firebird v1.0.
The TOP X syntax implements only part of the mySQL LIMIT X, Y
functionality, so it won't be a complete replacement.
Accordingly, your friend should look to write a SELECT SP which provides
the necessary functionality.
Sean
Ann Harrison is currently working on exposing the existing TOP X syntax
(it's in the engine just not exposed to the SQL interface) as part of
the work for Firebird v1.0.
The TOP X syntax implements only part of the mySQL LIMIT X, Y
functionality, so it won't be a complete replacement.
Accordingly, your friend should look to write a SELECT SP which provides
the necessary functionality.
Sean
> -----Original Message-----http://docs.yahoo.com/info/terms/
> From: Tilo Muetze [mailto:tmuetze@...]
> Sent: Thursday, April 26, 2001 5:46 AM
> To: ib-support@yahoogroups.com
> Subject: [ib-support] mySQL Limit to Firebird
>
>
> Hi, a friend of mine tries to port a mySQL php site to
> Firebird. The only
> place where he run into problems yet, is the LIMIT feature of
> mySQL(he needs
> a simple search function which fetches n records and then the
> next n records
> and so on). Is there any possibility to emulate the LIMIT(or
> Oracle ROWNUM)
> functionality or does he have to use a stored procedure?
>
> Regards,
> Tilo
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to