Difference between revisions of "SET ORDER"
Yvonne.milne (Talk | contribs) m (1 revision) |
Yvonne.milne (Talk | contribs) |
||
Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
Select the master index file from the active index file list | Select the master index file from the active index file list | ||
− | |||
==Syntax== | ==Syntax== | ||
SET ORDER TO [<expN> | [TAG] <tag-name> [OF <.dbx filename>] | <single index filename> [ASCENDING | DESCENDING]] | SET ORDER TO [<expN> | [TAG] <tag-name> [OF <.dbx filename>] | <single index filename> [ASCENDING | DESCENDING]] | ||
− | |||
==See Also== | ==See Also== | ||
− | [[INDEX]], [[INDEXKEY()]], [[INDEXORDER()]], [[MDX()]], [[NDX() | + | [[INDEX]], [[INDEXKEY()]], [[INDEXORDER()]], [[MDX()]], [[NDX()]], [[SET INDEX]], [[TAG()]], [[TAGCOUNT()]], [[TAGNO()]], [[USE]] |
− | + | ||
==Description== | ==Description== | ||
− | The SET ORDER TO <expN> command selects an open index file as the master index. The master index is the index file searched during the FIND and SEEK commands, and also defines the order in which records are retrieved from the table. The master index may be selected with a number, <expN>. This is the sequential number of the index in the current list of indexes associated with a .dbf file | + | The SET ORDER TO <expN> command selects an open index file as the master index. The master index is the index file searched during the FIND and SEEK commands, and also defines the order in which records are retrieved from the table. The master index may be selected with a number, <expN>. This is the sequential number of the index in the current list of indexes associated with a .dbf file. If .dbx files are in use, the master index may be selected using a tag name. If there are tags that have the same name, they may be specified exactly with the OF <.dbx filename> qualifier. |
The SET ORDER TO 0 or SET ORDER TO commands cause index files to be ignored when retrieving records, but they will still be updated if any changes are made to the table. The SET ORDER TO command is only valid with tables that have index files associated with them. | The SET ORDER TO 0 or SET ORDER TO commands cause index files to be ignored when retrieving records, but they will still be updated if any changes are made to the table. The SET ORDER TO command is only valid with tables that have index files associated with them. | ||
Line 18: | Line 15: | ||
====ASCENDING | DESCENDING==== | ====ASCENDING | DESCENDING==== | ||
The optional ASCENDING | DESCENDING can be used to determine the order in which records are accessed and displayed. | The optional ASCENDING | DESCENDING can be used to determine the order in which records are accessed and displayed. | ||
− | |||
==Example== | ==Example== | ||
Line 26: | Line 22: | ||
</code> | </code> | ||
− | |||
− | |||
− | |||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Commands]] | [[Category:Commands]] |
Revision as of 08:11, 10 February 2012
Purpose
Select the master index file from the active index file list
Syntax
SET ORDER TO [<expN> | [TAG] <tag-name> [OF <.dbx filename>] | <single index filename> [ASCENDING | DESCENDING]]
See Also
INDEX, INDEXKEY(), INDEXORDER(), MDX(), NDX(), SET INDEX, TAG(), TAGCOUNT(), TAGNO(), USE
Description
The SET ORDER TO <expN> command selects an open index file as the master index. The master index is the index file searched during the FIND and SEEK commands, and also defines the order in which records are retrieved from the table. The master index may be selected with a number, <expN>. This is the sequential number of the index in the current list of indexes associated with a .dbf file. If .dbx files are in use, the master index may be selected using a tag name. If there are tags that have the same name, they may be specified exactly with the OF <.dbx filename> qualifier.
The SET ORDER TO 0 or SET ORDER TO commands cause index files to be ignored when retrieving records, but they will still be updated if any changes are made to the table. The SET ORDER TO command is only valid with tables that have index files associated with them.
ASCENDING | DESCENDING
The optional ASCENDING | DESCENDING can be used to determine the order in which records are accessed and displayed.
Example
use patrons index address.dbx set order to tag zip of address