Limet my Select result at 10 or 20 rec ?

<none>

Delphi Developer

Sun, 09 Mar 2003 03:00:00 GMT

Limet my Select result at 10 or 20 rec ?

I would like to read only 10 ou 20 record with a SELECT * FROM
customer..
Can I this with interbase ?
I used to a treeWiew to view the result...
Thank
Jack

Craig Stunt

Delphi Developer

Sun, 09 Mar 2003 03:00:00 GMT

Re:Limet my Select result at 10 or 20 rec ?

Quote

"" wrote:

> I would like to read only 10 ou 20 record with a SELECT * FROM
> customer..
> Can I this with interbase ?

Sure. Write your query as usual, fetch 20 records, and close the
query. IB will not send records unless you ask for them.

HTH,

-Craig

--
Craig Stuntz Vertex Systems Corporation
Senior Developer http://www.vertexsoftware.com

Other Threads

1. help with the media object to get pics/frames into 10 to 20 seperate image objects

2. Looking t cut movie into 10 - 20 individual images 1 second apart

3. sql:order on numbers in text field 1 10 11 19 2 20 21

4. How to select only the 10 first line in a BDE SQL SELECT

5. Select Top 20 *...

6. QuickReport is to slow (report 20 selected recs from 100000)

7. Using SELECT TOP 10 statement with TADOQuery

8. SELECT TOP 10

9. Select Last 10 record ?

10. Select Top 10