Difference between revisions of "DESCENDING()"

Revision as of 15:05, 2 June 2009

Class

Indexing

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 from 1 up to DB_MAXWKA, 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 Database Server, Recital Mirage Server, Recital Terminal Developer