Difference between revisions of "SET ORDER"

From Recital Documentation Wiki
Jump to: navigation, search
Line 1: Line 1:
=SET ORDER=
 
 
 
 
==Class==
 
==Class==
 
Indexing
 
Indexing
Line 11: Line 8:
  
 
==Syntax==
 
==Syntax==
SET ORDER TO <expN> | [TAG] <tag-name> [OF <.dbx filename>] | <single index filename>
+
SET ORDER TO <expN> | [TAG] <tag-name> [OF <.dbx filename>] | <single index filename> [ASCENDING | DESCENDING]
[ASCENDING | DESCENDING]
+
  
  
 
==See Also==
 
==See Also==
[[INDEX]], [[USE]], [[INDEXKEY()]], [[INDEXORDER()]], [[MDX()]], [[NDX()]], [[TAG()]], [[TAGNO()]], [[TAGCOUNT()]], [[SET COMPATIBLE]], [[SET INDEX]]
+
[[INDEX]], [[INDEXKEY()]], [[INDEXORDER()]], [[MDX()]], [[NDX()]], [[TAG()]], [[TAGNO()]], [[TAGCOUNT()]], [[SET COMPATIBLE]], [[SET INDEX]], [[USE]]
  
  
Line 24: Line 20:
 
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.
  
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==
<pre>
+
<code lang="recital">
 
use patrons index address.dbx
 
use patrons index address.dbx
set order to tag zip of address</pre>
+
set order to tag zip of address
 +
</code>
  
  

Revision as of 08:52, 17 April 2009

Class

Indexing


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(), TAG(), TAGNO(), TAGCOUNT(), SET COMPATIBLE, SET INDEX, 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. Single index files (.ndx/.idx) may also be selected by name, <single index filename> if SET COMPATIBLE is set to FOXPRO, FOXPLUS, FOXBASE or VFP. 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


Products

Recital Database Server, Recital Mirage Server, Recital Terminal Developer