Difference between revisions of "DESCENDING()"

From Lianjapedia
Jump to: navigation, search
m (1 revision)
Line 1: Line 1:
 
==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
 
  
 
==Syntax==
 
==Syntax==
 
DESCENDING([[.dbx filename> | <expC>,] <expN> [,<alias>]])
 
DESCENDING([[.dbx filename> | <expC>,] <expN> [,<alias>]])
 
  
 
==See Also==
 
==See Also==
[[DBXDESCEND()]], [[FIND]], [[FOR()]], [[INDEX]], [[MDX()]], [[ORDER()]], [[SEEK]], [[SET INDEX]], [[TAG()]], [[TAGCOUNT()]], [[TAGNO()]], [[UNIQUE()]]
+
[[DBXDESCEND()]], [[FOR()]], [[INDEX]], [[MDX()]], [[ORDER()]], [[SEEK]], [[SET INDEX]], [[TAG()]], [[TAGCOUNT()]], [[TAGNO()]], [[UNIQUE()]]
 
+
  
 
==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, 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 index searches.
 
+
  
 
==Example==
 
==Example==
Line 24: Line 20:
 
</code>
 
</code>
  
 
==Products==
 
Recital Server, Recital
 
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Functions]]
 
[[Category:Functions]]
 
[[Category:Indexing]]
 
[[Category:Indexing]]
 
[[Category:Indexing Functions]]
 
[[Category:Indexing Functions]]

Revision as of 05:57, 10 February 2012

Purpose

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

Syntax

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

See Also

DBXDESCEND(), 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 index searches.

Example

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