Difference between revisions of "DBXDESCEND()"

From Recital Documentation Wiki
Jump to: navigation, search
 
 
(2 intermediate revisions by 2 users not shown)
Line 1: Line 1:
==Class==
 
Expressions and Type Conversion
 
 
 
 
==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 Database Server, Recital Mirage Server, Recital Terminal Developer
+
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