Difference between revisions of "INDEXKEY()"
From Lianjapedia
Yvonne.milne (Talk | contribs) m (1 revision) |
Yvonne.milne (Talk | contribs) |
||
Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
Function to return the index key expression | Function to return the index key expression | ||
− | |||
==Syntax== | ==Syntax== | ||
INDEXKEY([<expN>]) | INDEXKEY([<expN>]) | ||
− | |||
==See Also== | ==See Also== | ||
− | [[DBF()]], [[FCOUNT()]], [[FIELD()]], [[FILTER | + | [[DBF()]], [[FCOUNT()]], [[FIELD()]], [[FILTER()]], [[INDEXEXT()]], [[INDEXORDER()]], [[LEN()]], [[NDX()]] |
− | + | ||
==Description== | ==Description== | ||
The INDEXKEY() function is synonymous with the KEY() function. The INDEXKEY() function returns the index key expression for the master index or index <expN> if specified. A null string is returned if no such index exists. The INDEXKEY() function always returns a character string in lower case. | The INDEXKEY() function is synonymous with the KEY() function. The INDEXKEY() function returns the index key expression for the master index or index <expN> if specified. A null string is returned if no such index exists. The INDEXKEY() function always returns a character string in lower case. | ||
− | |||
==Example== | ==Example== | ||
Line 28: | Line 24: | ||
</code> | </code> | ||
− | |||
− | |||
− | |||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
[[Category:Indexing]] | [[Category:Indexing]] | ||
[[Category:Indexing Functions]] | [[Category:Indexing Functions]] |
Revision as of 08:40, 10 February 2012
Contents
Purpose
Function to return the index key expression
Syntax
INDEXKEY([<expN>])
See Also
DBF(), FCOUNT(), FIELD(), FILTER(), INDEXEXT(), INDEXORDER(), LEN(), NDX()
Description
The INDEXKEY() function is synonymous with the KEY() function. The INDEXKEY() function returns the index key expression for the master index or index <expN> if specified. A null string is returned if no such index exists. The INDEXKEY() function always returns a character string in lower case.
Example
use accounts index acc_no, date_paid ? indexkey(1) acc_no + dtos(date_rec) set order to 2 ? indexkey(indexorder()) dtos(date_paid) + str(amo_paid,11,2) index on lower(left(company,20)) tag company ? indexkey() lower(left(company,20))