About SELECT TOP ... & TADOQuery

Thread View: borland.public.cppbuilder.database.ado

3 messages

[T] Back to Threads [V] Tree View [G] Group Articles

3 total messages Started by Vladimir Stefanovic Sun, 11 Dec 2005 09:09

#568

Author: Vladimir Stefanovic
Date: Sun, 11 Dec 2005 09:09

25 lines
1532 bytes

Hi,

Is there any mechanism (or trick) in SQL that I can say:

SELECT TOP 10 FROM TABLE
(I know that this exists, and that OK)

SELECT MIDDLE(11,20) FROM TABLE
(but what about this, I suppose that 'middle' does not exist???)

In other words I would like to have a 'Next>' button in the
app which should give me only a portion of data from a huge
table.

The main reason for this is the speed gain. It would be a waste
of speed and resources to get the whole recordset and internaly
truncate the unnecessary rows.





-- 
Best regards,
Vladimir Stefanovic

Re: About SELECT TOP ... & TADOQuery

#570

Author: Scott Morris
Date: Mon, 12 Dec 2005 14:28

7 lines
1179 bytes

> In other words I would like to have a 'Next>' button in the
> app which should give me only a portion of data from a huge
> table.

Below is one of the most commonly referenced mechansims in the MS sql server 
newsgroups (that I monitor).
http://www.aspfaq.com/show.asp?id=2120

Re: About SELECT TOP ... & TADOQuery

#571

Author: Vladimir Stefanovic
Date: Mon, 12 Dec 2005 15:07

14 lines
1262 bytes

> Below is one of the most commonly referenced mechansims in the MS sql 
> server newsgroups (that I monitor).
> http://www.aspfaq.com/show.asp?id=2120

Interesting page, indeed.

Thank you. I'll try to find something that I can use for my case...




-- 
Best regards,
Vladimir Stefanovic

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads