Re: Get the first x records

From: Yannis <None@xxxxxxxxxx>
Date: 13 Jul 2006 10:36:41 -0700

"Bill Todd" <no@xxxxxx> wrote in news:44b67dc7$1@xxxxxxxxxxxxxxxxxxxxxx:

Giorgio Vanoni wrote:

Hi all,
in my program I want to limit the number of fetched records in
queries containing select statement. MaxRecord doesn't works for all
the providers.

How can I do?

Many thanks.

Giorgio.

SELECT TOP 10...

It does not work for all providers as well eg oracle.

All providers is not something that I have managed to acomplish yet.
So please specify which providers you need and we will see if there is a
common way to accomplish it.

Regards
Yannis.
.

Follow-Ups:
- Re: Get the first x records
  - From: Giorgio Vanoni

References:
- Get the first x records
  - From: Giorgio Vanoni
- Re: Get the first x records
  - From: Bill Todd

Prev by Date: Re: Get the first x records
Next by Date: Re: Locate and loCaseInsensitive
Previous by thread: Re: Get the first x records
Next by thread: Re: Get the first x records
Index(es):
- Date
- Thread

Relevant Pages

Re: Dups
... The GROUP BY is fine with only one query, but I need all 4 queries.. ... I have 4 question that I asked Providers, ... >> All I want to do is count the Distinct ProviderNO. ...
(microsoft.public.access.queries)
Re: Get the first x records
... in my program I want to limit the number of fetched records in ... queries containing select statement. ... MaxRecord doesn't works for all ... the providers. ...
(borland.public.delphi.database.ado)
Get the first x records
... in my program I want to limit the number of fetched records in queries containing select statement. ... MaxRecord doesn't works for all the providers. ...
(borland.public.delphi.database.ado)