Re: Search in query result set

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

Article #22

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

#22

From: Aage Johansen
Date: Wed, 04 Aug 1999 00:00

21 lines
1384 bytes

Include the RecID criterion in the SQL in the query.  Then,  "if not
Query1.Eof then <found>;"
Try to avoid bringing the "thousand records" over the network in the
first place.

Aage J.

btm wrote:

> [Delphi 1.02]
>
> I have a Query1 which returns a result set of several hundred or even
> thousand records.
> What's the most efficient way to find out whether among those records
> there is one with key field "RecID" matching a given value? What I
> need is a Boolean function similar to Table1.FindKey(...).
>
> Thanks for any hints
>
> Thomas

Technical Details

Message-ID: <37A89F66.731C090F@online.no>

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

References: <37a81ca1.1020257@news.spectraweb.ch>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ffff5,d3db6b5c5738e11b
X-Google-Attributes: gidffff5,public
X-Google-Thread: 115d96,d3db6b5c5738e11b
X-Google-Attributes: gid115d96,public
From: Aage Johansen <aagjohan@online.no>
Subject: Re: Search in query result set
Date: 1999/08/04
Message-ID: <37A89F66.731C090F@online.no>
X-Deja-AN: 508933458
Content-Transfer-Encoding: 7bit
References: <37a81ca1.1020257@news.spectraweb.ch>
Content-Type: text/plain; charset=us-ascii
X-Complaints-To: news-abuse@online.no
X-Trace: news1.online.no 933801949 130.67.11.45 (Wed, 04 Aug 1999 23:25:49 MET DST)
Organization: Telenor Online Public Access
MIME-Version: 1.0
NNTP-Posting-Date: Wed, 04 Aug 1999 23:25:49 MET DST
Newsgroups: comp.lang.pascal.delphi.databases,borland.public.delphi.database

Reply to Parent Message