Difference between revisions of "DBXDESCEND()"
Yvonne.milne (Talk | contribs) m (1 revision) |
Yvonne.milne (Talk | contribs) |
||
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 | ||
− | |||
==Syntax== | ==Syntax== | ||
DBXDESCEND(<exp>) | DBXDESCEND(<exp>) | ||
− | |||
==See Also== | ==See Also== | ||
− | [[DESCENDING() | + | [[DESCENDING()]], [[INDEX]], [[SEEK]] |
− | + | ||
==Description== | ==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. | 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 | + | For index tags created using the DESCENDING keyword, the DBXDESCEND() function must be used in SEEK index searches. |
− | + | ||
==Example== | ==Example== | ||
Line 23: | Line 19: | ||
</code> | </code> | ||
− | |||
− | |||
− | |||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
[[Category:Indexing]] | [[Category:Indexing]] | ||
[[Category:Indexing Functions]] | [[Category:Indexing Functions]] |
Revision as of 05:55, 10 February 2012
Contents
Purpose
Function used in the creation and searching of descending order tag indexes
Syntax
DBXDESCEND(<exp>)
See Also
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 index searches.
Example
index on name tag descendname descending seek dbxdescend("Smith")