Difference between revisions of "SET INDEX"

From Recital Documentation Wiki
Jump to: navigation, search
 
Line 15: Line 15:
  
 
==See Also==
 
==See Also==
CLOSE INDEX, INDEX, REINDEX, USE, MDX(), TAG(), TAGCOUNT(), TAGNO(), SET COMPATIBLE, SET INDEXEXT, SET ORDER, SET VIEW
+
[[CLOSE INDEX]], [[INDEX]], [[REINDEX]], [[USE]], [[MDX()]], [[TAG()]], [[TAGCOUNT()]], [[TAGNO()]], [[SET COMPATIBLE]], [[SET INDEXEXT]], [[SET ORDER]], [[SET VIEW]]
  
  
Line 34: Line 34:
 
==Products==
 
==Products==
 
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
 
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
 +
[[Category:Documentation]]
 +
[[Category:Commands]]
 +
[[Category:Set_Commands|INDEX]]

Revision as of 17:03, 11 March 2009

SET INDEX

Class

Indexing


Purpose

Open a list of index files associated with the active table


Syntax

SET INDEX TO [<index list>] | [ORDER <.ndx file> |<.dbx tag name>[OF <.dbx file>]] [ADDITIVE]


See Also

CLOSE INDEX, INDEX, REINDEX, USE, MDX(), TAG(), TAGCOUNT(), TAGNO(), SET COMPATIBLE, SET INDEXEXT, SET ORDER, SET VIEW


Description

The SET INDEX TO command is used to open single index files and /or multiple .dbx index files for a table. A maximum of twenty .ndx and .dbx files can be associated with a table at any one time. All of the open index files associated with a table are automatically updated when any modifications are made to the table.

If there is no production .dbx file, the first index in <index list> will be the master index, that is, the records are in order by this index expression. If there is a production index associated with the .dbf, the first tag in the production .dbx will be the master index. The ORDER qualifier may be used to specify a different order to be active after the indexes have been opened. If the tag name specified with the ORDER qualifier is used in more than one .dbx file, the OF qualifier can be used to specify the appropriate .dbx file name. The SET ORDER TO command can be used to select a master index from the currently active index files.

If the optional ADDITIVE keyword is specified, the indexes included in <index list> are opened in addition to any currently open indexes. If ADDITIVE is not specified or if the SET INDEX TO command is issued without an <index list>, any currently open indexes in the active workarea are closed.


Example

use patrons
set index to names, events
seek "smith"

Products

Recital Database Server, Recital Mirage Server, Recital Terminal Developer