Selecting tables with Indexes

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

Article #185

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

#185

From: Tom
Date: Thu, 11 Mar 1999 00:00

17 lines
1284 bytes

How do I structure a select statement to use the index tags from the
table below?

Select area:   1, Table in USE: H:\ICDUPART.DBF  Alias: ICDUPART
Table Language Driver: DB437US0, character set: DOS437
Production MDX file: ICDUPART.MDX
          Index TAG: DESC  Key: DESC
          Index TAG: DI  Key: PARTNO  For: division = "DI"
          Index TAG: WI  Key: PARTNO  For: DIVISION = "WI"
          Index TAG: SF  Key: PARTNO  For: DIVISION = "SF"
          Index TAG: AS  Key: PARTNO  For: DIVISION = "AS"
          Index TAG: WP  Key: PARTNO  For: DIVISION = "WP"
          Index TAG: AR  Key: PARTNO  For: DIVISION = "AR"
          Index TAG: PARTNO  Key: PARTNO

I tried select * from "h:\icdupart" order by partno, but this gave me
the rows from the DI tag.

Technical Details

Message-ID: <36E842E2.61460EC4@deltanet.com>

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: ff5a1,87b373f8359904f5,start
X-Google-Attributes: gidff5a1,public
From: Tom <thall@deltanet.com>
Subject: Selecting tables with Indexes
Date: 1999/03/11
Message-ID: <36E842E2.61460EC4@deltanet.com>
X-Deja-AN: 453964968
Content-Transfer-Encoding: 7bit
X-Accept-Language: en
Content-Type: text/plain; charset=us-ascii
Organization: Another Netscape Collabra Server User
Mime-Version: 1.0
Newsgroups: borland.public.vdbase.data.sql