Re: Get the first x records



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

--
Bill Todd (TeamB)
.



Relevant Pages

  • 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)