Re: Using Joins

Article View: borland.public.vdbase.data.sql

Article #562

Back to borland.public.vdbase.data.sql Previous Next

#562

From: Bowen Moursund (TeamB)
Date: Fri, 09 Oct 1998 00:00

12 lines
964 bytes

>My testing has been questionable and the Language Reference seems
>inconclusive.  Would someone please confirm that a query with a Join and
>an Order By clause will not respond to a ....rowset.findkey().

Seems logical to me that it wouldn't. FindKey() uses an explicitly named
index. A join is a temp/virtual table that has no indexes.
__
Bowen Moursund (TeamB)
bowen at nerds dot com
http://lonestar.texas.net/~moursund/
Try this help resource:
http://www.dejanews.com/home_ps.shtml

Technical Details

Message-ID: <6vlebo$1nc18@forums.borland.com>

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

References: <361D37DC.79D6@inna.net>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,a7ecc2e42a78f594
X-Google-Attributes: gidff5a1,public
From: "Bowen Moursund (TeamB)" <bowenSEND_ME_NO_SPICED_HAM@nerds.com>
Subject: Re: Using Joins
Date: 1998/10/09
Message-ID: <6vlebo$1nc18@forums.borland.com>
X-Deja-AN: 399402801
References: <361D37DC.79D6@inna.net>
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4
Organization: DataTech
Newsgroups: borland.public.vdbase.data.sql

Reply to Parent Message