Difference between revisions of "KEY()"

Latest revision as of 11:17, 4 February 2013

Purpose

Function to return the index key expression

Syntax

KEY([<expN>])

See Also

DBF(), FCOUNT(), FIELD(), FILTER(), INDEXEXT(), INDEXORDER(), LEN(), NDX()

Description

The KEY() function is synonymous with the INDEXKEY() function. The KEY() 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 KEY() function always returns a character string in lower case.

Example

use accounts index acc_no, date_paid
? key(1)
acc_no + dtos(date_rec)
set order to 2
? key(indexorder())
dtos(date_paid) + str(amo_paid,11,2)
index on lower(left(company,20)) tag company
? key()
lower(left(company,20))