How do I restrict number of feched rows from server?

Ozkan DULGER

Delphi Developer

Wed, 19 May 2004 23:31:51 GMT

How do I restrict number of feched rows from server?

I use TTable at client side and MS SQL 2000 at the server side. I want to
limit the number of rows fetched to a small number and fetch the remaining
rows on demand of the user (eg. user scroll down in the grid to a row not
olready fetched)
Thanks in advance
Ozkan

Deja

Delphi Developer

Thu, 20 May 2004 11:35:52 GMT

Re:How do I restrict number of feched rows from server?

you can't do it :

1. for client/server architeture DON'T use TTAble, use TQuery
2. you must write your stored proc for paging
3. I recomend you to use ADO for MS SQL 7 / MS SQL 2K

Quote

"Ozkan DULGER" <ozkan_dul...@yahoo.com> wrote in message

news:3c08f69a_1@dnews...

Quote

> I use TTable at client side and MS SQL 2000 at the server side. I want to
> limit the number of rows fetched to a small number and fetch the remaining
> rows on demand of the user (eg. user scroll down in the grid to a row not
> olready fetched)
> Thanks in advance
> Ozkan

Other Threads

1. Restricting number of numbers typed in a cell in TStringGrid

2. SQL Server 6.5 / ADO / TDBGrid and large number of rows

3. How do I Restrict number of row fetched from server.

4. Restricted Numbers of data with TQuery

5. Component for restricting number of lines

6. Restrict number of instantiations

7. Restricting number of records returning

8. Restricting input of numbers

9. Getting Rows Affected when doing an Open

10. Restricting a user to logging on to a server only once