Difference between revisions of "COPY INDEXES"

Latest revision as of 06:17, 30 September 2016

Purpose

Copy single indexes to a multiple index file

Syntax

COPY INDEXES <.ndx filelist> [TO <.dbx filename>]

See Also

COPY STRUCTURE, DELETE TAG, INDEX, SET INDEX, TAG(), TAGCOUNT(), TAGNO(), USE

Description

The COPY INDEXES command creates a multiple index by copying single index files to one file. This command is useful for converting .ndx files to .dbx files. This command requires the indexes to be active before the copy can be performed. Use SET INDEX TO <.ndx file> to open a single index file. By default the index tag or tags are created in the production index. If no production index exists, then a new one is created.

TO <.dbx filename>

If the TO <.dbx filename> clause is used, the tag or tags are created in the specified .dbx file. If the .dbx file does not exist, it will be created.

Example

use accounts
set index to ordno, invno
copy indexes ordno, invno