Difference between revisions of "DESCENDING()"
Yvonne.milne (Talk | contribs) m (1 revision) |
Yvonne.milne (Talk | contribs) |
||
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() | + | [[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 | + | 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> | ||
− | |||
− | |||
− | |||
[[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
Contents
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.