Difference between revisions of "CLOSE INDEX"
From Lianjapedia
Yvonne.milne (Talk | contribs) m (1 revision) |
Helen.george (Talk | contribs) |
||
| (2 intermediate revisions by one other user not shown) | |||
| Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
Close index files in the current workarea | Close index files in the current workarea | ||
| − | |||
==Syntax== | ==Syntax== | ||
CLOSE INDEX | CLOSE INDEX | ||
| − | |||
==See Also== | ==See Also== | ||
| − | [[CLOSE]], [[CLOSE ALL]], [[CLOSE ALTERNATE]], [[CLOSE DATABASES | + | [[CLOSE]], [[CLOSE ALL]], [[CLOSE ALTERNATE]], [[CLOSE DATABASES]], [[CLOSE PROCEDURE]], [[SET INDEX]], [[USE]] |
| − | + | ||
==Description== | ==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 <table> NODBX command. | 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 <table> NODBX command. | ||
| − | |||
==Example== | ==Example== | ||
| Line 24: | Line 20: | ||
</code> | </code> | ||
| − | |||
| − | |||
| − | |||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Commands]] | [[Category:Commands]] | ||
| − | [[Category: | + | [[Category:Databases]] |
| − | + | ||
Latest revision as of 10:54, 4 February 2013
Contents
Purpose
Close index files in the current workarea
Syntax
CLOSE INDEX
See Also
CLOSE, CLOSE ALL, CLOSE ALTERNATE, CLOSE DATABASES, 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 <table> NODBX command.
Example
use patrons index events, dates, names seek "BALLET" list while event = "BALLET" close index list for event = "BALLET"
