Selecting tables with Indexes

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

1 messages

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

1 total messages Started by Tom Thu, 11 Mar 1999 00:00

#185

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

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