Difference between revisions of "INDEXKEY()"

Revision as of 16:29, 1 June 2009

Class

Indexing

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 Database Server, Recital Mirage Server, Recital Terminal Developer