INDEXKEY()

From Recital Documentation Wiki
Revision as of 13:05, 7 January 2010 by Yvonnemilne (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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 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))


Products

Recital Server, Recital