Article View: borland.public.vdbase.data.sql
Article #60Re: Selecting tables with Indexes
From: Geoff S. Wass ( dBVIPS )
Date: Tue, 23 Mar 1999 00:00
Date: Tue, 23 Mar 1999 00:00
27 lines
1457 bytes
1457 bytes
Tom,
You said:
I tried select * from "h:\icdupart" order by partno, but this gave
me the rows from the DI tag.
Are you sure? Sorry, for asking, but I am surprised as this should have
returned the whole table ordered by PartNo.
Which level are the tables? (3, 4, 5, 7?)
SQL is not going to be able to use those partial indexes like DI. They
are dBASE exceptions AFAIK. It can only use partNo. The others will
always be ignored. The reason, as I understand it, is that SQL as
non-procedural code, is not going to give you a way to instruct it in
the procedures it follows to carry out the task. Procedural code in a
non-procedural lanague will not do.<g>
--
Geoff Wass ( dBVIPS )
Kuala Lumpur, Malaysia
=>=> More dBASE info at http://members.theglobe.com/Geoff_Wass <=<=
*>*> Visit the NEW! dBASE Inc. news groups on the news server
news://news.dbase2000.com <*<*
Technical Details
Message-ID:
<36F76DB6.76A365E0@ibm.net>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<36E842E2.61460EC4@deltanet.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: ff5a1,87b373f8359904f5 X-Google-Attributes: gidff5a1,public From: "Geoff S. Wass ( dBVIPS )" <gswass@ibm.net> Subject: Re: Selecting tables with Indexes Date: 1999/03/23 Message-ID: <36F76DB6.76A365E0@ibm.net> X-Deja-AN: 457931369 Content-Transfer-Encoding: 7bit References: <36E842E2.61460EC4@deltanet.com> X-Accept-Language: en Content-Type: text/plain; charset=us-ascii Organization: Noordindarus Consultancy Sdn. Bhd. Mime-Version: 1.0 Newsgroups: borland.public.vdbase.data.sql