Difference between revisions of "INDEXKEY()"
From Recital Documentation Wiki
Helengeorge (Talk | contribs) (→Class) |
Helengeorge (Talk | contribs) |
||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
==Purpose== | ==Purpose== | ||
Function to return the index key expression | Function to return the index key expression | ||
| Line 32: | Line 30: | ||
==Products== | ==Products== | ||
| − | Recital | + | Recital Server, Recital |
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
[[Category:Indexing]] | [[Category:Indexing]] | ||
[[Category:Indexing Functions]] | [[Category:Indexing Functions]] | ||
Revision as of 16:33, 2 December 2009
Purpose
Function to return the index key expression
Syntax
INDEXKEY(<expN>)
See Also
DBF(), FCOUNT(), FIELD(), FILTER(), FMT(), INDEXEXT(), INDEXORDER(), LEN(), NDX()
Description
The INDEXKEY() function is synonymous with the KEY() function. The INDEXKEY() function returns the index key expression for index <expN>, or a null string if no index file exists. When used in conjunction with the INDEXORDER() function, the INDEXKEY() function will return the index key expression of the master index. 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)) to company ? indexkey(1) lower(left(company,20))
Products
Recital Server, Recital
