select SOMETHING from AnotherQuery

Article View: borland.public.cppbuilder.database.multi-tier

Article #1217

Back to borland.public.cppbuilder.database.multi-tier Previous Next

#1217

From: Paolo Polce
Date: Wed, 05 Apr 2000 00:00

13 lines
884 bytes

Hello,

  I Have a TQuery component with an sql statement like "select * from
myTable where etc etc ... order by etc etc...."
The result is a table of 3000 thousand records...
Now, I need only the first 2000 records... and I need to order them...

I'd like to issue a command like   "select * from MyPreviousQuery order by
something..."

Can someone help me?
Thank you.

Technical Details

Message-ID: <38eb0797@dnews>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: fcd2b,a29207fe6ff3368f,start
X-Google-Attributes: gidfcd2b,public
From: "Paolo Polce" <java.group@bricabrac.it>
Subject: select SOMETHING from AnotherQuery
Date: 2000/04/05
Message-ID: <38eb0797@dnews>
X-Deja-AN: 606985421
X-Trace: 5 Apr 2000 02:29:59 -0800, 194.185.89.113
X-MSMail-Priority: Normal
X-Priority: 3
Newsgroups: borland.public.cppbuilder.database.multi-tier
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600