About SELECT TOP ... & TADOQuery

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

Article #568

Back to borland.public.cppbuilder.database.ado Previous Next

#568

From: 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

Technical Details

Message-ID: <439bec84$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!nx01.iad01.newshosting.com!newshosting.com!news-out.newsfeeds.com!propagator2-sterling.newsfeeds.com!in.nntp.be!caladan.landsraad.net!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 10698b,3b6e334594244b43,start
X-Google-Attributes: gid10698b,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Vladimir Stefanovic" <antivari@po.sbb.co.yu>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: About SELECT TOP ... & TADOQuery
Date: Sun, 11 Dec 2005 10:09:28 +0100
Lines: 27
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
NNTP-Posting-Host: 82.117.212.65
Message-ID: <439bec84$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1134292100 82.117.212.65 (11 Dec 2005 01:08:20 -0700)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!nx01.iad01.newshosting.com!newshosting.com!news-out.newsfeeds.com!propagator2-sterling.newsfeeds.com!in.nntp.be!caladan.landsraad.net!newsgroups.borland.com!not-for-mail