Difference between revisions of "CLOSE INDEX"

From Recital Documentation Wiki
Jump to: navigation, search
(Class)
Line 1: Line 1:
==Class==
 
Indexing
 
  
  

Revision as of 13:08, 23 October 2009


Purpose

Close index files in the current workarea


Syntax

CLOSE INDEX


See Also

CLOSE, CLOSE ALL, CLOSE ALTERNATE, CLOSE DATABASES, CLOSE FORMAT, CLOSE PROCEDURE, SET INDEX, USE


Description

The CLOSE INDEX command closes index files in the currently selected workarea. All single indexes and non-production multiple indexes will be closed. If the active table has a production index, that is a multiple index with the same basename as the table, the production index will remain open. Production indexes can be detached from their associated tables using the USE NODBX command.

Example

use patrons index events, dates, names
seek "BALLET"
list while event = "BALLET"
close index
list for event = "BALLET"


Products

Recital Database Server, Recital Mirage Server, Recital Terminal Developer