Difference between revisions of "DESCENDING()"
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
| (3 intermediate revisions by 2 users not shown) | |||
| 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 | ||
| 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 | + | 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 | + | Recital Server, Recital |
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
| + | [[Category:Indexing]] | ||
| + | [[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
