Difference between revisions of "DBXDESCEND()"
Yvonnemilne (Talk | contribs) |
Helengeorge (Talk | contribs) |
||
| (2 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
| − | |||
| − | |||
==Purpose== | ==Purpose== | ||
Function used in the creation and searching of descending order tag indexes | Function used in the creation and searching of descending order tag indexes | ||
| Line 29: | Line 25: | ||
==Products== | ==Products== | ||
| − | Recital | + | Recital Server, Recital |
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
| + | [[Category:Indexing]] | ||
| + | [[Category:Indexing Functions]] | ||
Latest revision as of 16:44, 27 November 2009
Purpose
Function used in the creation and searching of descending order tag indexes
Syntax
DBXDESCEND(<exp>)
See Also
DESCENDING(), FIND, INDEX, SEEK
Description
The DBXDESCEND() function is used in the creation and searching of descending order tag indexes. It can be used on CHARACTER, NUMERIC, LOGICAL and DATE fields. For character fields, the function operates by subtracting the ASCII code for each character from 255. For numeric fields, the sign is reversed. Logical Falses become .T. (true) and logical Trues become .F. (false). The DBXDESCEND() function can be used to search in DATE indexes created with the DESCENDING keyword, but use outside the context of an index search will result in an Invalid date being returned.
For index tags created using the DESCENDING keyword, the DBXDESCEND() function must be used in SEEK or FIND index searches.
Example
index on name tag descendname descending seek dbxdescend("Smith")
Products
Recital Server, Recital
