Sorting Queries

Article View: comp.lang.pascal.delphi.databases

Article #117

Back to comp.lang.pascal.delphi.databases Previous Next

#117

From: Stuart Cox
Date: Wed, 17 Feb 1999 00:00

16 lines
1354 bytes

Hi,

I originally access my DB using a simple TTable but I now need to select a
set of records. I have tried using StartRange and EndRange BUT I want all
records whose

Field1 > Something and whose
Field2 < SomethingElse

It appears Ranges cannot handle this so off I go to TQuery. I can build the
exact SQL Query I need quite easily but I also need to sort the records on
various fields (depending on user decisions). Now, TTable has an IndexName
which I can change depending on how I want to sort the data BUT TQuery has
no equivalent. Any help would be much appreciated.

Stuart Cox

Technical Details

Message-ID: <7aeaob$qj3$1@lux.doc.ic.ac.uk>

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: ffff5,7a456c793e1fa17b,start
X-Google-Attributes: gidffff5,public
X-Google-Thread: 10de66,7a456c793e1fa17b,start
X-Google-Attributes: gid10de66,public
From: "Stuart Cox" <s.cox@ic.ac.uk>
Subject: Sorting Queries
Date: 1999/02/17
Message-ID: <7aeaob$qj3$1@lux.doc.ic.ac.uk>
X-Deja-AN: 445288171
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3155.0
X-Complaints-To: usenet@doc.ic.ac.uk
X-Trace: lux.doc.ic.ac.uk 919252555 27235 146.169.39.25 (17 Feb 1999 11:55:55 GMT)
Organization: Dept. of Computing, Imperial College, University of London, UK.
NNTP-Posting-Date: 17 Feb 1999 11:55:55 GMT
Newsgroups: comp.lang.pascal.delphi.databases,borland.public.delphi.database.sqlservers