Search in query result set

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

2 messages

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

2 total messages Started by btm Wed, 04 Aug 1999 00:00

#21

Author: btm
Date: Wed, 04 Aug 1999 00:00

11 lines
1115 bytes

[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

Re: Search in query result set

#22

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

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