Difference between revisions of "DESCENDING()"

From Recital Documentation Wiki
Jump to: navigation, search
 
(2 intermediate revisions by one user not shown)
Line 1: Line 1:
==Class==
 
Indexing
 
 
 
 
==Purpose==
 
==Purpose==
 
Function to determine whether an index tag was created with the DESCENDING keyword
 
Function to determine whether an index tag was created with the DESCENDING keyword
Line 16: Line 12:
  
 
==Description==
 
==Description==
The DESCENDING() function returns a logical true (.T.) if the index tag specified by the tag number <expN> was created with the DESCENDING keyword.  If the index tag was not created with the DESCENDING keyword, the DESCENDING() function returns a logical false (.F.).  The DESCENDING keyword creates an index tag in descending (Z-A, 10-1) rather than ascending ( A-Z, 1-10) order.  The optional <.dbx filename> causes the DESCENDING() function to check the specified tag in that multiple index file.  You may specify a character expression that returns the name of a valid multiple index file.  If no multiple index filename is specified, the DESCENDING() function checks the currently open multiple index file.  If no multiple index file is open, the DESCENDING() function returns .F..  The DESCENDING() function returns a logical false (.F.) if the index is a single index (.ndx) file.  You may specify an alias name to check for descending index tags in other workareas.  The [<alias>] may be a workarea number from 1 up to DB_MAXWKA, an alias name which has been created with the USE command, or A through Z, excluding M.
+
The DESCENDING() function returns a logical true (.T.) if the index tag specified by the tag number <expN> was created with the DESCENDING keyword.  If the index tag was not created with the DESCENDING keyword, the DESCENDING() function returns a logical false (.F.).  The DESCENDING keyword creates an index tag in descending (Z-A, 10-1) rather than ascending ( A-Z, 1-10) order.  The optional <.dbx filename> causes the DESCENDING() function to check the specified tag in that multiple index file.  You may specify a character expression that returns the name of a valid multiple index file.  If no multiple index filename is specified, the DESCENDING() function checks the currently open multiple index file.  If no multiple index file is open, the DESCENDING() function returns .F..  The DESCENDING() function returns a logical false (.F.) if the index is a single index (.ndx) file.  You may specify an alias name to check for descending index tags in other workareas.  The [<alias>] may be a workarea number, an alias name which has been created with the USE command, or A through Z, excluding M.
  
 
For index tags created using the DESCENDING keyword, the DBXDESCEND() function must be used in SEEK or FIND index searches.
 
For index tags created using the DESCENDING keyword, the DBXDESCEND() function must be used in SEEK or FIND index searches.
Line 30: Line 26:
  
 
==Products==
 
==Products==
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
+
Recital Server, Recital  
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Functions]]
 
[[Category:Functions]]
 
[[Category:Indexing]]
 
[[Category:Indexing]]
 
[[Category:Indexing Functions]]
 
[[Category:Indexing Functions]]

Latest revision as of 16:38, 15 December 2009

Purpose

Function to determine whether an index tag was created with the DESCENDING keyword


Syntax

DESCENDING([[.dbx filename> | <expC>,] <expN> [,<alias>]])


See Also

DBXDESCEND(), FIND, FOR(), INDEX, MDX(), ORDER(), SEEK, SET INDEX, TAG(), TAGCOUNT(), TAGNO(), UNIQUE()


Description

The DESCENDING() function returns a logical true (.T.) if the index tag specified by the tag number <expN> was created with the DESCENDING keyword. If the index tag was not created with the DESCENDING keyword, the DESCENDING() function returns a logical false (.F.). The DESCENDING keyword creates an index tag in descending (Z-A, 10-1) rather than ascending ( A-Z, 1-10) order. The optional <.dbx filename> causes the DESCENDING() function to check the specified tag in that multiple index file. You may specify a character expression that returns the name of a valid multiple index file. If no multiple index filename is specified, the DESCENDING() function checks the currently open multiple index file. If no multiple index file is open, the DESCENDING() function returns .F.. The DESCENDING() function returns a logical false (.F.) if the index is a single index (.ndx) file. You may specify an alias name to check for descending index tags in other workareas. The [<alias>] may be a workarea number, an alias name which has been created with the USE command, or A through Z, excluding M.

For index tags created using the DESCENDING keyword, the DBXDESCEND() function must be used in SEEK or FIND index searches.


Example

set view to accounting
?descending(3)
.T.


Products

Recital Server, Recital