Get the first x records

From: Giorgio Vanoni <g.vanoni@xxxxxxxxxxx>
Date: Thu, 13 Jul 2006 18:24:41 +0200

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.
.

Follow-Ups:
- Re: Get the first x records
  - From: Bill Todd

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

Relevant Pages

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)
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 ... It does not work for all providers as well eg oracle. ...
(borland.public.delphi.database.ado)
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)