Difference between revisions of "KEY()"

From Recital Documentation Wiki
Jump to: navigation, search
(Class)
Line 1: Line 1:
==Class==
 
Indexing
 
  
  

Revision as of 15:54, 27 October 2009


Purpose

Function to return the index key expression


Syntax

KEY(<expN>)


See Also

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


Description

The KEY() function is synonymous with the INDEXKEY() function. The KEY() 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 KEY() function will return the index key expression of the master index. 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)) to company
? key(1)
lower(left(company,20))


Products

Recital Database Server, Recital Mirage Server, Recital Terminal Developer