Re: how to limit the number of rows for Client in the TADODataset?
From: Arthur Hoornweg (arthur.hoornweg_at_wanadoo.nl.net)
Date: 06/25/04
- Next message: Hernando Duque C.: "Re: Record not found or changed by another user. How to solve it?"
- Previous message: Arthur Hoornweg: "Re: Sort order of Access table without index"
- In reply to: Dexter: "how to limit the number of rows for Client in the TADODataset?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Fri, 25 Jun 2004 14:30:19 +0200
Dexter wrote:
> Hello,
>
> I need to limit the number of rows returned of a TADODataset. I know that
> the ADODataset make this work.
> Exemple:
>
> I want to make a select (select * from tab1) in my DataBase, but it returns
> only the 10 first rows, then when the pointer goes to the end, the
> TADODataBase returns more 10 rows.
>
> Would somebody know how to make this?
>
>
>
> Dexter
>
>
If you use MS Sql server or *.MDB (Access) database format,
you can specify "TOP" in the query.
Example: Select TOP 10 * from mytable where custno=1234
-- Arthur Hoornweg (please remove the ".net" from my e-mail address)
- Next message: Hernando Duque C.: "Re: Record not found or changed by another user. How to solve it?"
- Previous message: Arthur Hoornweg: "Re: Sort order of Access table without index"
- In reply to: Dexter: "how to limit the number of rows for Client in the TADODataset?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
